On Wed, Oct 29, 2008 at 1:07 PM, Scott Kokotovitch <[EMAIL PROTECTED]> wrote: > It's supposed to do that. Double quotes signifies that you're > specifying a fieldname.
True, sort of. The way sqlite interprets SQL is pretty loose. When I specify a="1", rather than throw an exception stating there is no field "1", sqlite "does the right thing" by looking at the fieldnames, discovering there is no field "1", and assuming that what I really meant was a='1'. And 99%+ of the time that works. The only time it comes as a surprise is when the field value is the same as the field name. Regards, - Robert --~--~---------~--~----~------------~-------~--~----~ Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] More options: http://groups.google.com/group/cwelug -~----------~----~----~----~------~----~------~--~---
