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
