Thanks Ben
_____ From: Ben Johansen [mailto:[email protected]] Sent: Thursday, June 17, 2010 4:59 PM To: [email protected] 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 = '[email protected] <mailto:'[email protected]> '); UPDATE emaillist SET E_Deleted = { d '2010-06-17' }, E_Source = E_Source + 'CRON' WHERE (E_Email = '[email protected] <mailto:'[email protected]> '); UPDATE emaillist SET E_Deleted = { d '2010-06-17' }, E_Source = E_Source & 'CRON' WHERE (E_Email = '[email protected] <mailto:'[email protected]> '); 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> [email protected] <mailto:[email protected]> 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
