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
