passing URL variable containing multiple values

lminmei · Aug 30, 2000

I have a list box that allows for multiple value selections. when i submit this, the results page comes out clean HOWEVER....when i click on the (ex: "next 5 records&quot

button....i get an error about that listbox URL variable.
>>example.................

on my search.cfm page I have a list box:

<CFQUERY DATASOURCE="Advice2000" NAME="Issues">
SELECT Issues
FROM ISSUES
GROUP BY Issues
ORDER BY Issues
</CFQUERY>

<select name="GetIssues" size="5" multiple>
<option value="" Selected>All
<cfoutput query="Issues">
<option value="#Issues#">#Issues# </cfoutput>
</select>

Now on my results.cfm page i have:
<a href="results.cfm?Issues=#GetIssues#">

i don't know what else i have to add...
Please Help!!!

NeoTurtle · Aug 30, 2000

I'm pretty new to CF myself, but here's my two cents worth:

search.cfm"
<CFQUERY DATASOURCE="Advice2000" NAME="Issues">
SELECT Issues
FROM Issues
GROUP BY Issues
ORDER BY Issues
</CFQUERY>

<cfoutput query="Issues">

<FORM ACTION=results.cfm?GetIssues=#Issues#>
<select name="GetIssues" size="5" multiple>
<option value=" " Selected>
All
<option value="#Issues#">#Issues#
</select>
<BR>
<INPUT TYPE="Submit" VALUE="Search">
</FORM>
</cfoutput>

results.cfm page:
<CFQUERY DATASOURCE="Advice2000" NAME="Results">
SELECT Issues
FROM Issues
WHERE FORM.GetIssues = #FORM.Issues#
ORDER BY Issues
</CFQUERY>

<cfoutput query="Results">
#Issues#
</CFOUTPUT>

Hope this helped . . . if not, I would need more detail in what you want your results to be.

-NeoTurtle

lminmei · Sep 1, 2000

NeoTurtle,

you suggestion won't work because i'm gonna need to add a link that will show "the next 5 records"
but in your code...the "WHERE" sql statement is looking for a form variable. So that code would only work for the first page of records.

DarkMan · Sep 1, 2000

In your results.cfm page, you could do something like:

Code:

<CFPARAM NAME = "Issues" default=""> <CFPARAM NAME = "Page" default=1> <CFSET Start = ((Page - 1)* 5) + 1> <CFIF len(Issues)> <CFQUERY DATASOURCE="Advice2000" NAME="Results"> SELECT Issues FROM Issues WHERE Issues = '#Issues#' ORDER BY Issues </CFQUERY> <CFOUTPUT QUERY="Results" STARTROW="#Start#" MAXROWS=5> <P>#Issues#</P> </CFOUTPUT> <CFIF Start + 5 lt Results.Recordcount> <CFSET NextPage=Page+1> <CFOUTPUT> <A HREF="results.cfm?issues=#UrlEncodedFormat(issues)#&page=#NextPage#">Next 5 Results</A> </CFOUTPUT> </CFIF> <CFELSE> Click <A HREF="search.cfm">Here</A> to select a search option </CFIF>

Hope this helps...

DM

lminmei · Sep 5, 2000

DarkMan,

I'm not sure what i'm doing wrong but for the multiple select list box, i used the function "ListChangeDelims() in the query and the number of records to display is a combo box from the search page (it is a variable called "records to display&quot

...please take a look at my entire code....here it is:

results.cfm:

<HTML>
<HEAD>
<TITLE>Advice Letter Search Results</TITLE>
<CFQUERY name="Result" datasource="Advice2000">
SELECT ID, Analyst, Year, DateIss, AdvNbr, Issues,
IssDescrp, LastName, FirstName, LawSec
FROM ISSUES
WHERE ID = ID
<CFIF IsDefined("Form.FirstName&quot

IS "Yes">
<CFIF Form.FirstName IS NOT "">AND FirstName LIKE '%
#Form.FirstName#%'
</CFIF>
</CFIF>

<CFIF IsDefined("Form.LastName&quot

IS "Yes">
<CFIF Form.LastName IS NOT "">AND LastName LIKE '%
#Form.LastName#%'
</CFIF>
</CFIF>

<CFIF IsDefined("Form.Year&quot

IS "Yes">
<CFIF Form.Year IS NOT "All">AND Year Like '%
#Form.Year#%'
</CFIF>
</CFIF>

<CFIF IsDefined("Form.Issues&quot

IS "Yes">
<CFIF Form.Issues IS NOT "">AND (Issues
LIKE '#ListChangeDelims(Form.Issues,"'OR Issues LIKE'&quot

#')
</CFIF>
</CFIF>

<CFIF IsDefined("Form.LawSection&quot

IS "Yes">
<CFIF Form.LawSection IS NOT "">AND LawSec LIKE '%
#Form.LawSection#%'
</CFIF>
</CFIF>

<CFIF IsDefined("Form.IssDescrp&quot

IS "Yes">
<CFIF Form.IssDescrp IS NOT "">And IssDescrp LIKE '%
#Form.IssDescrp#%'
</CFIF>
</CFIF>

ORDER BY AdvNbr
</CFQUERY>

<CFPARAM name="StartRecord" default="1">
<CFIF IsDefined("StartRecord&quot

>
<CFSET NextRecord = #StartRecord# + #records_to_display#>
</CFIF>

</HEAD>
<BODY>

<cfoutput>
<table>
<tr>
<td>
<CFIF #StartRecord# IS NOT 1>
<a href="Adviceresults.cfm?StartRecord=#Evaluate
(StartRecord - records_to_display)#&records_to_display=#records_to_display#&Year=#Year#&FirstName=#FirstName#&LastName=#LastName#&IssDescrp=#IssDescrp#&LawSec=#LawSec#&Issues=#UrlEncodedFormat(Issues)#">Previous #records_to_display#</a>
</CFIF>
</TD>
<TD align="right">
<CFIF #NextRecord# LTE result.recordcount>
<CFIF #Evaluate(NextRecord + #records_to_display# - 1)
# GT result.recordcount> <CFSET LastRecord = #result.recordcount# MOD
#records_to_display#>

<a href="Adviceresults.cfm?StartRecord=#nextRecord#&records_to_display=#records_to_display#&Year=#Year#&FirstName=#FirstName#&LastName=#LastName#&IssDescrp=#IssDescrp#&LawSec=#LawSec#&Issues=#UrlEncodedFormat(Issues)#">Next #LastRecord#</a>

<CFELSE>
<a href="Adviceresults.cfm?StartRecord=#NextRecord#&records_to_display=#records_to_display#&Year=#Year#&FirstName=#FirstName#&LastName=#LastName#&IssDescrp=#IssDescrp#&LawSec=#LawSec#&Issues=#UrlEncodedFormat(Issues)#">Next #records_to_display#</a>

</CFIF>
</CFIF>

The rest is just displaying the records....
my problem is this, the query works for the first page but when i click on the nect 5 button...the variables are not being passed.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

passing URL variable containing multiple values

lminmei

Programmer

NeoTurtle

Programmer

lminmei

Programmer

DarkMan

Programmer

lminmei

Programmer

Similar threads

Part and Inventory Search

Sponsor