Trey, Thank you for the prompt reply.
Did not realize that double quote would denote column name. Will have to check for column names when building sql statement and insert single quotes around that part of data. Thanks again Walt Mc Whirter ----- Original Message ----- From: "Trey Mack" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, February 06, 2008 7:21 PM Subject: Re: [sqlite] Version 3.2.2 > > UPDATE listings SET buyer = 'Price' WHERE listnum = 12345 > > Double quotes are for column names. > > Walt wrote: >> I have a table 'listings' with fields 'listnum', 'price' and 'buyer' etc. >> >> executing the following sql >> >> UPDATE listings SET buyer = "Price" WHERE listnum = 12345 >> >> results in the 'buyer' field being set to the contents of the 'price' >> field instead of setting the field 'buyer' to "Price". >> >> Need HELP >> >> Walt Mc Whirter >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
