Try putting single quote marsk aroun #cmb_especialdidad# instead of
double quotes.
On Sun, 11 Mar 2001 15:28:06 -0400 "Javier Flores" <[EMAIL PROTECTED]>
writes:
> Hi everyone!
>
> I would like to know what I missing?
>
> .- here is my search page...
> <input type="text" name="txt_nombre">
> <select name="cmb_especialidad">
> <cfoutput query="obtener_especialidad">
> <optionvalue="#especialidad#">#esp_nombre#</option>
> <input type="submit" name="Submit2" value="Buscar!">
>
> .- this is the search query...
> <CFQUERY datasource="svn" NAME="busqueda">
> SELECT * FROM medico
> WHERE especialidad1 = "#cmb_especialidad#"
> AND nombre LIKE '%#txt_nombre#%'
> </CFQUERY>
>
> .- the result...
> [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
> Expected 1.
>
> Thanxs for your help!
>
> 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
