Javier, not 100% sure, but I think you have to have a space between the
option and value, as optionvalue is not a recognized parameter that is being
passed.
i.e. <option value="#especialidad#">#esp_nombre#</option>
Milo
Javier Flores wrote:
> 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
