Re: [sqlite] Query returns all rows

2006-09-25 Thread drh
"Igor Tandetnik" <[EMAIL PROTECTED]> wrote: > David Champagne > wrote: > > If I have a table defined in the following manner > > > >CREATE TABLE License (Form varchar(256), Type int, NbOcc int) > > > > and then I execute a query > > > >SELECT * FROM License WHERE FORM = "form"; > > > > I

Re: [sqlite] Query returns all rows

2006-09-25 Thread Paolo Vernazza
David Champagne wrote: If I have a table defined in the following manner CREATE TABLE License (Form varchar(256), Type int, NbOcc int) and then I execute a query SELECT * FROM License WHERE FORM = "form"; I get all rows returned, even though I only want the rows where the column FORM

Re: [sqlite] Query returns all rows

2006-09-25 Thread Mark Richards
I would tend to avoid mixed case and never use all upper case to specify anything (other than when defining a constant perhaps). Your use of case between "FORM" and "Form" as example. Also the use of the term "Type" for a fieldname (or variable) may be stretching reserved words a bit. For

Re: [sqlite] Query returns all rows

2006-09-25 Thread Doug Currie
Monday, September 25, 2006, 1:46:12 PM, David Champagne wrote: > and then I execute a query > SELECT * FROM License WHERE FORM = "form"; > I get all rows returned Try: SELECT * FROM License WHERE FORM = 'form'; e -- Doug Currie Londonderry, NH

[sqlite] Query returns all rows

2006-09-25 Thread David Champagne
If I have a table defined in the following manner CREATE TABLE License (Form varchar(256), Type int, NbOcc int) and then I execute a query SELECT * FROM License WHERE FORM = "form"; I get all rows returned, even though I only want the rows where the column FORM contains the string