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" <[email protected]> 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 >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
