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]');
UPDATE emaillist SET E_Deleted = { d '2010-06-17' }, E_Source =
E_Source + 'CRON' WHERE (E_Email = '[email protected]');
UPDATE emaillist SET E_Deleted = { d '2010-06-17' }, E_Source =
E_Source & 'CRON' WHERE (E_Email = '[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
Ben Johansen
http://www.webspinr.com
[email protected]
Phone: 360-597-3372
Mobile: 360-600-7775
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
