Tried that, same result. Any other ideas....? Newly revised code: Update sys_list set pass = 'abcdf;456' where sys_id = 'testboxa' and user_id = 'testuserid';
--- 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 <[EMAIL PROTECTED]> 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
