structure for the DB: CREATE TABLE `zingers` ( `zid` int(9) unsigned NOT NULL auto_increment, `keywords` varchar(255) default NULL, `citation` text, `quotation` text, PRIMARY KEY (`zid`) ) ENGINE=MyISAM DEFAULT CHARSET=UTF8 AUTO_INCREMENT=422 ;
code for storing to database: querystring = "update zingers set keywords = '%s', citation = '%s', quotation = %s' where zid = %d" % (keywords,citation,quotation,zid) ; cursor.execute(querystring) at this point, querystring = update zingers set keywords = ' aaaaaa;Action', citation = ''''''''' ', quotation = ''''''''''''' ' where zid = 422 where '''' are an assortment of apostrophes and single quotes copied and pasted from a Word Document. > > And where is the actual code... What you've supplied doesn't show > how you are generating the SQL... > -- -- http://mail.python.org/mailman/listinfo/python-list