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
> >
> 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>
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
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
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
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,
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
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
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
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
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
11 matches
Mail list logo
