Put mulitple record into your table and see what occurs..... --- Puneet Kishor <[EMAIL PROTECTED]> wrote:
> Nicholas Choate wrote: > > Tried that, same result. Any other ideas....? > > here is what I get > > D:\user\punkish>sqlite3 test.db > SQLite version 3.2.1 > Enter ".help" for instructions > sqlite> create table t (a, b); > sqlite> insert into t (a, b) values ('foo', 'bar'); > sqlite> select * from t; > foo|bar > sqlite> update t set a = 'foo;qux', b = 'barr' where > a = 'foo'; > sqlite> select * from t; > foo;qux|barr > sqlite> > > as you can see, it works just fine. Maybe you are > not using the latest > version of SQLite. Maybe you are doing something > else that is funky. > > > > > > 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 > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com