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 that matter, I'd suspect "FORM" or
"Form" as well. Note your query says FORM but the fieldname is Form.
I bet something got munged as above to produce this. Your table also
has no primary key. Could this be an index problem? Did you define
one? What data did you populate in the fields?
Or, there must be something obvious I've overlooked.
/m
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 contains the string "form".
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------