RE: [ cf-dev ] search problems

sanjay sidar Tue, 06 Apr 2004 11:10:57 -0700

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]

RE: [ cf-dev ] search problems

Reply via email to