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
