Thanks Ben
_____ From: Ben Johansen [mailto:b...@pcforge.com] Sent: Thursday, June 17, 2010 4:59 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: MySQL Update (OT) you need to use the CONCAT sub function E_Source = CONCAT(E_Source,'CRON') On Jun 17, 2010, at 3:02 PM, Fogelson, Steve wrote: Hi, I am using MySQL with Witango and I want to append some text to a field in an UPDATE SQL. MySQL doc indicates you can do this. UPDATE t1 SET col1 = col1 + 1; I have tried the following: UPDATE emaillist SET E_Deleted = { d '2010-06-17' }, E_Source = E_Source'CRON' WHERE (E_Email = 'x...@xxx.com <mailto:'x...@xxx.com> '); UPDATE emaillist SET E_Deleted = { d '2010-06-17' }, E_Source = E_Source + 'CRON' WHERE (E_Email = 'x...@xxx.com <mailto:'x...@xxx.com> '); UPDATE emaillist SET E_Deleted = { d '2010-06-17' }, E_Source = E_Source & 'CRON' WHERE (E_Email = 'x...@xxx.com <mailto:'x...@xxx.com> '); Maybe it only works for INTEGER or numeric fields. E_Source is a TEXT field. Appreciate any suggestions. Thanks Steve Fogelson Internet Commerce Solutions ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf <http://www.witango.com/developer/maillist.taf> Ben Johansen http://www.webspinr.com <http://www.webspinr.com> b...@webspinr.com <mailto:b...@webspinr.com> Phone: 360-597-3372 Mobile: 360-600-7775 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
