Multiple Search Parameters in one Form

Hello,

I've been working on trying to figure out how to script something where if a user enters more then one search term in the same fieldbox, it would query both of them and output it to a cf page.

My scripting/issue is very similiar to an early thread by an individual here
http://bytes.com/forum/thread655581.html

Basically in my case....these are not words I am entering...I would be entering lets say 500-900 different email addresses into this one form -

then what it does is output them to view all of these email addresses with their phone numbers from the database on the search results page to a table ....now this only works if i enter one email address in the form it finds it fine...but when i enter more then one email addresses in the search form it doesn't find it....

Aug 1 '08 #1

Subscribe Post Reply

2754

acoder

16,027

Expert Mod 8TB

If it's in that format, you can use it as a list, or use the IN keyword in your SQL statement.

Aug 1 '08 #2

reddem0n

Sorry I'm a little ignorant when it comes to this...What exactly do you mean by that? Right now here is my coding on the search page where the user would input the search query:

Expand|Select|Wrap|Line Numbers

 
<HTML>

<HEAD>

    <TITLE>Bad Emails / Phone Compiler v0.1</TITLE>
 
<script language="JavaScript" >
 
function checkText(Item, Value)

{

 var next=Item.tabIndex;

 for(i=1; i <  document.getElementById("searchForm101").length; i++)

 {

  if(i == next)

  {

   // leave textfield as is.

  }

  else

  {

   document.getElementById("searchForm101").elements[i].value  = ""; // Erase other fields

  }

 }

 document.getElementById("searchForm101").elements[document.getElementById("searchForm101").length - 1].value  = "Search"; // Update the entry 

}
 
</script>
 
<script language="JavaScript" > 

function validate()

{

 var count=0;

 for(i=1; i <  document.getElementById("searchForm101").length; i++)

 {

  if (document.getElementById("searchForm101").elements[i].value  == "")

  {

   count++;

  }

 }

 if(count == (document.getElementById("searchForm101").length - 2) )

 {

  var newHTML = "<span style='color:#ff0000'>" + 'Please enter text.' + "</span>";

  document.getElementById('ErrorMessage').innerHTML = newHTML;

  return false;

 }

 else

 {

  return true;

 }

}    

</script>
 
</HEAD>
 
<BODY bgcolor="ffffff">

<CENTER>

<TABLE cellpadding="0" cellspacing="0" border="0" width="300" bgcolor="dddddd">

    <TR bgcolor="008800">

        <TD>

            <TABLE cellpadding="0" cellspacing="0" border="0" width="100%">

                <TR>

                    <TD align="left"><a href="<cfoutput>#blahblah_blahblah_com#</cfoutput>/"><font color="ffffff"><b>Main Menu</b></font></a></TD>

                    <TD align="right"><font color="ffffff"><b>Bad Emails / Phone Compiler v0.1</b></font></TD>

                </TR>

            </TABLE>

        </TD>

    </TR>

    <tr>

    <div id="ErrorMessage" >&nbsp

    </div>

    </tr>

<FORM method="post" name="searchform" action="getresults.cfm"  id="searchForm101">

<INPUT type="hidden" name="searchflag" value="2" />

    <TR>

        <TD><b>Email:</b><BR>

          <textarea name="email" cols="80" rows="30" tabindex="1" onChange="checkText(this, this.value)" onClick="checkText(this, this.value)"></textarea></TD>

    </TR>

        <TD align="center"><Input type="submit" name="submitbutton"  value="Search" onClick="return validate()" /></TD>

    </TR>

</FORM>

<!---

<FORM method="post" action="getresults.cfm">

<INPUT type="hidden" name="searchflag" value="1">

    <TR>

        <TD align="center"><br><br><hr><br><INpUT type="submit" name="SHOWALL" value="Show ALL"></TD>

    <TR>

</FORM>

--->

</TABLE>

</CENTER>

Once the user submits the query, the output results gets shown on the getresults.cfm page with the email the user entered and the system basically matches the email it finds on the database with the phone # and puts it in the table.

Expand|Select|Wrap|Line Numbers

  
<cfparam name="searchflag" default="-1">

<!---

<cfparam name="email" default="">

<cfparam name="lastname" default="">

<cfparam name="IDNUM" default="0">

--->
 
<CFIF IsDefined("Form.IDNUM") and (Form.IDNUM NEQ "")>

 <cfoutput>

    <CFQUERY name="GetInfo" datasource="#ODBC_Datasource#">

        Select Gaming_clients.clientid, Gaming_clients.lastname, Gaming_clients.firstname, Gaming_clients.email, Gaming_clients.phone

        from Gaming_clients WITH (NOLOCK)

        WHERE Gaming_clients.idnum = #form.idnum#

        ORDER by Gaming_clients.lastname

    </CFQUERY>

</cfoutput>    

<cfelseif IsDefined("Form.lastname") and (Form.lastname NEQ "")>

<cfoutput> 

    <CFQUERY name="GetInfo" datasource="#ODBC_Datasource#">

        Select Gaming_clients.clientid, Gaming_clients.lastname, Gaming_clients.firstname, Gaming_clients.email, Gaming_clients.phone

        from Gaming_clients WITH (NOLOCK)

        WHERE Gaming_clients.lastname LIKE '%#trim(lastname)#%'

        ORDER by Gaming_clients.lastname

    </CFQUERY>

</cfoutput>

<cfelseif IsDefined("Form.email")and (Form.email NEQ "")>

<cfoutput>

    <CFQUERY name="GetInfo" datasource="#ODBC_Datasource#">

    <cfloop index="i" list="#form.searchflag#" delimiters=" ">

        Select Gaming_clients.clientid, Gaming_clients.lastname, Gaming_clients.firstname, Gaming_clients.email, Gaming_clients.phone

        from Gaming_clients WITH (NOLOCK)

        WHERE Gaming_clients.email LIKE '%#trim(email)#%'

        ORDER by Gaming_clients.lastname

        </cfloop>

    </CFQUERY>

</cfoutput>

</cfif>
 
<!---  This redirects to page that shows all resumes

<CFIF ParameterExists(SHOWALL)>

    <CFLOCATION url="viewresumes.cfm">

  <CFABORT>

</CFIF>

--->
 
<HTML>

<HEAD>

    <TITLE>Bad Emails / Phone Compiler v0.1 Results</TITLE>

</HEAD>

<FORM method="post" action="viewresumes.cfm">

<INPUT type="hidden" name="clientid_required" value="Please choose someone to edit.">

<CFOUTPUT>

<INPUT type="hidden" name="searchflag" value="#searchflag#">

</CFOUTPUT>

<BODY bgcolor="ffffff">

<CENTER>

<TABLE bgcolor="dddddd" cellpadding="0" cellspacing="0" border="0" width="500">

    <TR bgcolor="008800">

        <TD colspan="3">

            <TABLE cellpadding="0" cellspacing="0" border="0" width="100%">

                <TR>

                    <TD align="left"><a href="<cfoutput>#blahblah_blahblah_com#</cfoutput>/"><font color="ffffff"><b>Main Menu</b></font></a></TD>

                    <TD align="right"><font color="ffffff"><b>Bad Emails v0.1</b></font></TD>

                </TR>

                <tr><td colspan="2" >

<!---
 
<CFIF IsDefined("Form.IDNUM") and (Form.IDNUM NEQ "")>

<cfoutput>    <h1>IDNUM is - #Form.IDNUM#</h1></cfoutput>    

<cfelseif IsDefined("Form.lastname") and (Form.lastname NEQ "")>

<cfoutput>     <h1>Last Name is - #Form.lastname#</h1></cfoutput>

<cfelseif IsDefined("Form.email")and (Form.email NEQ "")>

<cfoutput>     <h1>email is - #Form.email#</h1></cfoutput>

</cfif>

--->            

                </td></tr>

            </TABLE>

        </TD>

    </TR>
 
<cfif isDefined("GetInfo.Recordcount")>

<CFIF #GetInfo.Recordcount# IS 0>

    <TR>

        <TD colspan="3" align="center">No matches were found</TD>

    </TR>

    <TR>

        <TD colspan="3" align="center"><a href="search.cfm">New Search</a></TD>

    </TR>

<CFELSE>

  <TR>

        <TD><b>Email</b></TD>

        <td><b>Phone</b></td>

    </TR>

<CFOUTPUT query="GetInfo">

    <TR>

        <TD>#email#</TD>

        <td>#phone#</td>

    </TR>

</CFOUTPUT>
 
    <TR>

        <TD colspan="3">

            <TABLE cellpadding="0" cellspacing="0" border="0" width="100%">

                <TR>

                    </FORM>

                    <FORM method="post" action="search.cfm">

                    <TD align="center"><INPUT type="submit" value="Go Back"></TD>

                    </FORM>

                </TR>

            </TABLE>

        </TD>

    </TR>
 
</CFIF>

</cfif>
 
    <!---

<cfelse>

    <TR>

        <TD colspan="3">You may have pushed the "enter" key on the previous page - please <a href="javascript:history.go(-1);">go back</a> and push one of the 2 search buttons.</TD>

    </TR>

</cfif>

--->

 </TABLE>

</CENTER>

</BODY>

</HTML>

Aug 1 '08 #3

acoder

16,027

Expert Mod 8TB

On line 32, you could replace "LIKE '%#trim(email)#%'" with "IN ('#trim(email)#')".

Note that this assumes you've validated the input and you should use cfparam/cfqueryparam to prevent sql injection attacks.

Aug 1 '08 #4

reddem0n

thanks for your response

Expand|Select|Wrap|Line Numbers

 <cfoutput>

    <CFQUERY name="GetInfo" datasource="#ODBC_Datasource#">

    <cfloop index="i" list="#form.searchflag#" delimiters=",">

        Select Gaming_clients.clientid, Gaming_clients.lastname, Gaming_clients.firstname, Gaming_clients.email, Gaming_clients.phone

        from Gaming_clients WITH (NOLOCK)

        WHERE Gaming_clients.email IN ('#trim(email)#')'

        ORDER by Gaming_clients.lastname

        </cfloop>

    </CFQUERY>

</cfoutput>

</cfif>

Here is what i have now...this didn't do anything tho...whenever i enter multiple email addresses in the form, it results to no match found

Aug 1 '08 #5

acoder

16,027

Expert Mod 8TB

Sorry, forgot the single quotes around each email. You'll need to do to wrap quotes around each email string. You could treat the string as a list with the comma as delimiter and use cfloop to loop over and add quotes and concatenate again.

Aug 1 '08 #6

by: CharitiesOnline | last post by:

Hello, I have set this script up to add paging to a search results page. Which on the first page works fine. I calculates how many pages there should be depending on the number of results returned...

ASP / Active Server Pages

Configuring Multiple Instances DB2 WINNT

by: Mike | last post by:

Looking to find any information on how to properly configure multiple instances of DB2. This is on Win2k db2 ver 7.2. I am basically looking for information on how the multiple instance settings...

DB2 Database

Multiple Criteria Parameter Query

by: dskillingstad | last post by:

I'm trying to set up a parameter query based on an unbound form. This search form has about 5 text boxes where the user can type in values within each box and search a specific table based on the...

Microsoft Access / VBA

Search for multiple things in a string

by: tshad | last post by:

Can you do a search for more that one string in another string? Something like: someString.IndexOf("something1","something2","something3",0) or would you have to do something like: if...

C# / C Sharp

insert multiple records

by: shank | last post by:

I'm trying to use online samples for submitting multiple records from ASP into a stored procedure. Failing! Through the below form, a user could be submitting many records at a time. I'm not...

ASP / Active Server Pages

Multiple simulataneous forms in a sinlge application

by: Peter Oliphant | last post by:

How does one launch multiple forms in an application? Using Photoshop as an example, this application seems to be composed of many 'disjoint' forms. Yet, they all seem somewhat 'active' in...

.NET Framework

Create a multiple parameter search form for a query

by: angie | last post by:

I need to figure out how to create a user interface to search a query, but here's the bad part...I need to account for criteria on at least 7 of the fields. Here's what I'm thinking I need to do:...

Microsoft Access / VBA

Multiple Search Parameters

by: Panlflzs | last post by:

Howdy, I am working on a system where I need a basic HTML form to pass data to a cfm page. The cfm page will then query a database and return any matching data. I am using MySQL. I have my HTML...

ColdFusion

Problem passing multiple form variables for search form

by: jmartmem | last post by:

Greetings, Perhaps someone can help me resolve what I hope is a simple dilemma... I have one ASP page (TEST_RoadmapData_Search.asp) which contains two list/menus within a form, which, upon...

ASP / Active Server Pages

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Multiple Search Parameters in one Form

Similar topics