On Mon, Jun 18, 2001 at 02:44:00PM -0400, Shrout, Ryan wrote:
> Here is the full error I am getting when running the query included:
>
> Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239
> 1054 : Unknown column 'CMET3558539239' in 'where clause'
> Here's the problem, I know that Customer_No exists. I can see it in the
> database. This code works fine when using a Customer_No such as 15 or 153,
> something numeric. The field itself is defined as a CHAR (50).
>
> Any ideas what is causing this? It happens with every Customer_No in this
> format and gives the same error.
Try:
SELECT * FROM customers WHERE Customer_No = "CMET3558539239";
Greetz, Peter
--
Against Free Sex! http://www.dataloss.nl/Megahard_en.html
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
