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
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
Put quotes around the Customer_No:
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
- TIM
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
[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
?
Ryan Shrout
-Original Message-
From: Bill Elvis Gibbs [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 3:20 PM
To: Shrout, Ryan
Subject: RE: Unknown column in 'where clause' error
WHERE Customer_No = 'CMET3558539239'
you need to use quotes when trying to reference data
- Computer Jobs at all LEVELS *
*
-Original Message-
From: Shrout, Ryan [mailto:[EMAIL PROTECTED]]
Sent: 18 June 2001 19:44
To: '[EMAIL PROTECTED]'
Subject: Unknown column in 'where clause' error
Here is the full error I
://www.computerstaff.net - Computer Jobs at all LEVELS *
*
-Original Message-
From: Shrout, Ryan [mailto:[EMAIL PROTECTED]]
Sent: 18 June 2001 20:14
To: '[EMAIL PROTECTED]'
Subject: RE: Unknown column in 'where clause' error
Thanks
: Shrout, Ryan [mailto:[EMAIL PROTECTED]]
Enviada: Segunda-feira, 18 de Junho de 2001 20:14
Para: '[EMAIL PROTECTED]'
Assunto: RE: Unknown column in 'where clause' error
Thanks for the suggestions, but this is actually a variable that is passed
via a URL. For example:
http://localhost/cus-lookup.php
]]
Sent: Monday, June 18, 2001 3:20 PM
To: Shrout, Ryan
Subject: RE: Unknown column in 'where clause' error
WHERE Customer_No = 'CMET3558539239'
you need to use quotes when trying to reference data that is not 100%
numeric, otherwise MySQL thinks you are trying to reference a column.
Bill