Sorry forgot the SQL on the previous email..... 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
