Try
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
Jorge Oliveira
[EMAIL PROTECTED]
----------------------------------------
© webfroggie.com - Recursos Online!
web: http://www.webfroggie.com
wap: http://www.webfroggie.com
-----Mensagem original-----
De: Shrout, Ryan [mailto:[EMAIL PROTECTED]]
Enviada: Segunda-feira, 18 de Junho de 2001 19:44
Para: '[EMAIL PROTECTED]'
Assunto: Unknown column in 'where clause' error
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.
Ryan Shrout
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
