if comments is null then comments||? is also null, try this: comments=coalesce(comments,'')||?
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gert Cuykens Sent: Sunday, January 18, 2009 10:15 AM To: sqlite-users@sqlite.org 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users