Page 1 of 1

Problem....

Posted: Sun Oct 20, 2002 4:54 pm
by Zoram
їcode]Could not execute query:

SELECT * FROM `Products` WHERE `id` = 'ba03';

Unknown column 'ba03' in 'where clause'ї/code]

How do i get it to work? the id is a varchar... it works when the ba03 is a number with no characters...

Posted: Sun Oct 20, 2002 10:46 pm
by protokol
Try putting it in double quotes: "ba03" ... also make sure that your id column can take a value other than a number

Posted: Sun Oct 20, 2002 11:25 pm
by Zoram
The variable type of id is varchar. And the double quotes didn't work.

absolutely positive

Posted: Mon Oct 21, 2002 1:39 am
by phpScott
Are you absolutely sure that 'id' is a varchar. I ran a quick test on a test db i run on my machine and using id and name as test columns and inserted 'ba03' in the id column and it was happy.

I would double check your your table definition and see what it says.

phpScott

Posted: Mon Oct 21, 2002 1:57 am
by volka
even if it wasn't varchar it would not produce an sql-error in a WHERE clause.
But anyway this problem is (hopefully) history ;)