Trey, Could you site a reference on this? I have been looking for documentation on how SQL deals with quoted things for a while now, but have not found anything.
Thanks, Mike On Feb 6, 2008 8:21 PM, Trey Mack <[EMAIL PROTECTED]> wrote: > > 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 > -- Peace may sound simple—one beautiful word— but it requires everything we have, every quality, every strength, every dream, every high ideal. —Yehudi Menuhin (1916–1999), musician _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
