Witango-Talk: MySQL Update (OT)

[Fogelson, Steve]

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');

UPDATE emaillist SET E_Deleted = { d '2010-06-17' }, E_Source = E_Source +
'CRON' WHERE (E_Email = 'x...@xxx.com');

UPDATE emaillist SET E_Deleted = { d '2010-06-17' }, E_Source = E_Source &
'CRON' WHERE (E_Email = '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