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
