yan 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 = 'CMET355853923
gem original-
De: 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 e
***
* Visit http://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]'
> Subjec
ustomer_No = '".$id."';
if for some reason the first one didn't work.
HTH,
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Shrout, Ryan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday
Hello,
Your field(column) is a CHAR and therefore the parameter to it should be in
single
quotes:
Change your query to:
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
*
* Visit http://www.computerstaff.net - Compu
uotes around' a variable?
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 nee
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 [mail
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
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