Re: [sqlite] Update command Help....
Thanks for everyones help, I'm actually building the
query dynamically based on what the user inputs, must
be my string handling functionality in Borland that
causing probs Thanks again.
--- Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> > Put mulitple record into your table and see what
> > occurs.
>
> D:\temp\convention>sqlite3 test.db
> SQLite version 3.0.8
> Enter ".help" for instructions
> sqlite> create table t (a, b);
> sqlite> insert into t (a, b) values ('foo', 'bar');
> sqlite> insert into t (a, b) values ('test', '2');
> sqlite> select * from t;
> foo|bar
> test|2
> sqlite> update t set a = 'foo;qux', b = 'barr' where
> a = 'foo';
> sqlite> select * from t;
> foo;qux|barr
> test|2
> sqlite>
>
> works fine here.
>
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: [sqlite] Update command Help....
> Put mulitple record into your table and see what
> occurs.
D:\temp\convention>sqlite3 test.db
SQLite version 3.0.8
Enter ".help" for instructions
sqlite> create table t (a, b);
sqlite> insert into t (a, b) values ('foo', 'bar');
sqlite> insert into t (a, b) values ('test', '2');
sqlite> select * from t;
foo|bar
test|2
sqlite> update t set a = 'foo;qux', b = 'barr' where a = 'foo';
sqlite> select * from t;
foo;qux|barr
test|2
sqlite>
works fine here.
Re: [sqlite] Update command Help....
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
Re: [sqlite] Update command Help....
Nicholas Choate wrote:
Put mulitple record into your table and see what
occurs.
sure thing. We were at
sqlite> select * from t;
foo;qux|barr
after that I did the following...
sqlite> insert into t (a, b) values ('qux', 'baz');
sqlite> select * from t;
foo;qux|barr
qux|baz
sqlite> update t set a = 'foo;bar', b = 'barr' where b = 'barr';
sqlite> select * from t;
foo;bar|barr
qux|baz
sqlite>
still works just fine.
--- 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?
protection around
http://mail.yahoo.com
--
Puneet Kishor
Re: [sqlite] Update command Help....
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
Re: [sqlite] Update command Help....
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
Re: [sqlite] Update command Help....
I'll try that, thanks for the suggestion. 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 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
Re: [sqlite] Update command Help....
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
Re: [sqlite] Update command Help....
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
Re: [sqlite] Update command Help....
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
Re: [sqlite] Update command Help....
You should post your sql On 7/18/05, Nicholas Choate <[EMAIL PROTECTED]> 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?
[sqlite] Update command Help....
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
