I'll try that, thanks for the suggestion. Puneet Kishor <[EMAIL PROTECTED]> wrote: On Jul 18, 2005, at 10:57 AM, Nicholas Choate wrote:
> Sorry forgot the SQL on the previous email..... > > Update sys_list set pass = "abcdf;456" where sys_id = "testboxa" and > user_id = "testuserid"; afaik, the SQL way is to use single quotes to delimit text. With double quotes it is likely interpolating the ';' inside as an end of statement marker. try UPDATE sys_list SET pass = 'abcdf;456' WHERE sys_id = 'testboxa' AND user_id = 'testuserid'; > > Note, the update command works great, as long as a semicolon is not in > the text being updated. > > Jay Sprenkle wrote: > You should post your sql > > On 7/18/05, Nicholas Choate wrote: >> I have noticed a quirk with the Update command and was just wondering >> if there was a way to fix it. I am attempting to update two fields in >> my database and I've noticed that if there is a ";" in the text field >> for one of the fields I'm updating, it updates every record with the >> same information. Is there a way to escape the semicolon? Are there >> any other characters that woudl cause this behavior? > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com -- Puneet Kishor __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
