Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #34583 > unrolled thread

MySQLdb insert HTML code error

Back to article view | Back to comp.lang.python

Contents

  MySQLdb insert HTML code error Anatoli Hristov <tolidtm@gmail.com> - 2012-12-11 01:04 +0100

#34583 — MySQLdb insert HTML code error

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

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web