Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Python > MySQLdb insert HTML code error

Reply
Thread Tools

MySQLdb insert HTML code error

 
 
Anatoli Hristov
Guest
Posts: n/a
 
      12-11-2012
Hi all,

I'm facing an issue inserting an html code into the DB, it comes out
with a syntax error but I face it only when I have html code. Could
help me escape the error somehow ?

Here is my code

def InsertSpecsDB(product_id, spec, lang, name):
db = MySQLdb.connect("localhost","getit","opencart")
cursor = db.cursor()
sql = ("INSERT INTO product_description (product_id, language_id,
name, description) VALUES ('%s','%s','%s','%s')")
params = (product_id, lang, name, spec)
cursor.execute(sql, params)
id = cursor.lastrowid
print"Updated ID %s description %s" %(int(id), lang)
return id

Thanks
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: MySQLdb insert HTML code error MRAB Python 0 12-11-2012 12:51 AM
Re: MySQLdb insert HTML code error Mark Lawrence Python 0 12-11-2012 12:38 AM
Re: MySQLdb insert HTML code error Anatoli Hristov Python 0 12-11-2012 12:31 AM
Re: MySQLdb insert HTML code error Anatoli Hristov Python 0 12-11-2012 12:29 AM
Re: MySQLdb insert HTML code error Mark Lawrence Python 0 12-11-2012 12:22 AM



Advertisments