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
