if comments is null then comments||? is also null, try this: comments=coalesce(comments,'')||?
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Gert Cuykens Sent: Sunday, January 18, 2009 10:15 AM To: [email protected] Subject: [sqlite] 'UPDATE shop_orders SET comments=comments||? WHERE oid=?',('test', '1') How do i do the following ? comments=comments||? When I add a comment nothing happens ? (please reply to my email address no subscription) _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
