Firstly I notice you have some extra space sin there E.g "form.region " #form.department #
Which you should get rid of. Also you do not seem to have any checks as to whether any results were returned form the query. E.g <cfif rsSearch.recordcount GT 0> Display your records </cfif> Russ > -----Original Message----- > From: sanjay sidar [mailto:[EMAIL PROTECTED] > Sent: 06 April 2004 19:11 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] search problems > > > Hey guys i have this code that is supposed to search for data > in my access > db. Now i have created a form in which the search is > avaliable, (called > form2.cfm) the way you search on this form is by a drop-down > option ie > choose a county, and you can select a country from the > dropdown list. I > have created an action page called search.cfm, (which is > below), now there > is info in my database, but when i try to search for it > nothing comes up, > and another thing im confused about is that if say the user > tired to search > for a person's name which does exisit in my db, how do i display that? > > as you may have guessed im very new to this language, so any > help would be > much appreciated:-) > > sanjay, p.s the code for the action page(search.cfm is below) > > > <body> > <cfquery name="rsSearch" datasource="sanjay_1"> > SELECT employee_name, company_name, country, region, > position,department, section, random > FROM tblAdmins > WHERE 1 = 1 > <CFIF isDefined("form.employee_name") and > form.employee_name neq ""> > AND employee_name = '#form.employee_name#' > <CFIF isDefined("form.company_name") and > form.company_name neq ""> > AND company_name = '#form.company_name#' > <CFIF isDefined("form.country") and form.country neq ""> > AND country = '#form.country#' > </CFIF> > <CFIF isDefined("form.region ") and form.region neq ""> > AND region = '#form.region #' > </CFIF> > <CFIF isDefined("form.section ") and form.section neq ""> > AND section = '#form.section #' > </CFIF> > <CFIF isDefined("form.position") and form.position neq ""> > AND position = '#form.position#' > </CFIF> > <CFIF isDefined("form.department ") and form.department neq ""> > AND department = '#form.department #' > </CFIF> > </cfquery> > > > </body> > > _________________________________________________________________ > Express yourself with cool emoticons - download MSN Messenger today! > http://www.msn.co.uk/messenger > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
