Javier,
i think you miss close your select tag:
> <input type="text" name="txt_nombre">
> <select name="cmb_especialidad">
> <cfoutput query="obtener_especialidad">
> <optionvalue="#especialidad#">#esp_nombre#</option>
</cfoutput> <----------- missed it !
> <input type="submit" name="Submit2" value="Buscar!">
</SELECT> <-------- missed it !
At 03:28 PM 11/03/2001 -0400, you 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
>
---------------------------------------------------------
. . . . . . . . . . . . . . . . . . . . . . . . .
Mauro Enrique Luna Avelar
Supervisor Grupo Web
Planta Nuclear Laguna Verde
Veracruz MEXICO
Internet: [EMAIL PROTECTED]
Intranet: [EMAIL PROTECTED]
-------------------------------------------------------------------------
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
