in your SQL statement you have quotes around an integer. Take the quotes
from LTE "100" should be
SELECT * FROM Masajista WHERE precio LTE 100
----- Original Message -----
From: "Javier Flores" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 04, 2001 3:36 PM
Subject: Query CFIF & CFELSEIF
> Hi everyone!
>
> I would like to know what I´m doing wrong...
>
> I try to get the following query using CF and Access...
>
> <CFQUERY NAME="resultado_busqueda" DATASOURCE="citascaracas">
> <cfif #edad# is "todas">
> <cfif #precio# is "precio1">
> SELECT * FROM Masajista WHERE precio LTE "100"
> <cfelseif #precio# is "precio2">
> SELECT * FROM Masajista WHERE precio GT "100" and precio GTE "150"
> <cfelseif #precio# is "precio3">
> SELECT * FROM Masajista WHERE precio GT "150" and precio GTE "250"
> <cfelseif #precio# is "precio4">
> SELECT * FROM Masajista WHERE precio GT "250"
> </cfif>
> </cfif>
> </CFQUERY>
>
> And I get the following error...
>
> Error Diagnostic Information
> ODBC Error Code = ()
> Invalid SQL String ""
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (1:1) to (1:61).
>
> I have the fiel precio in TEXT format, that is th reason of the ""...
>
> Regards,
>
> Javier
>
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
