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

Reply via email to