If you want it "cleaner", use a persistent structure. At least you won't
have a bunch of hidden fields clogging up the FORM structure from page to
page, it will execute a little faster as the data is in server memory and
not being passed and parsed over and over...
On the initial search page, make sure the structure is created and empty
(nulled).
On the results/re-search page:
1)Check if the FORM structure is there (came from initial search page). If
it exists, populate the structure with the FORM values.
2)Default the SortBy field
3)Perform the query using the structure's values.
4)Make the column heading links to the same page and set the SortBy
accordingly.
If the FORM structure isn't present, then you know you came from the
previous results/re-search page and don't need to parse the FORM fields to
set up the query. You just re-execute the query with the new SortBy value.
Alternatively, you could setup a JS array and populate it with the query's
result and use JS code to re-order the list on the fly. The re-ordering is
all done client-side. Cleaner, leaner, and less "stress" on the server since
it only does the query once and the client is responsible for sorting and
redrawing the output.
Good luck!!
On the initial search page, check for the structure and clear it.
On the results/re-search page, check if the structure is empty and populate
it if so; then use the structure to perform the query. On the header links,
do what Curtis said and pass the OrderBy value on the URL of the link.
-----Original Message-----
From: Chris Geanious [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 3:29 PM
To: [EMAIL PROTECTED]
Subject: Sorting search results: revisited
Further Greetings,
So, thanking those who did respond to my original posting concerning
sorting search results,
This is what I ended up doing. Not elegant or very pretty but here goes:
The problem: Search results produced by a dynamic query:
<CFQUERY DATASOURCE="db" NAME="getcontact">
SELECT
Contact_Information.First_Name,
Contact_Information.Last_Name,
Contact_Information.Organization_Name,
Contact_Information.Contact_ID,
Contact_Information.City,
Contact_Information.County
FROM Contact_Information
WHERE 1=0
<CFIF IsDefined('FORM.First_Name')>
<CFIF #First_Name# IS NOT "">
OR First_Name = '#FORM.First_Name#'
</CFIF>
</CFIF>
<!---snip--->
<CFIF IsDefined('FORM.County')>
<CFIF #FORM.County# IS NOT "">
OR County = '#FORM.County#'
</CFIF>
</CFIF>
<CFIF IsDefined('getid.Contact_ID')>
<CFIF #getid.Contact_ID# IS NOT "">
OR Contact_ID IN (#PreserveSingleQuotes(idList)#)
</CFIF>
</CFIF>
ORDER BY "#OrderBy#"
</CFQUERY>
How to sort these by the variables in the query:
In the results page the contacts are displayed tabularly with the <th>
headings</th>
a button with the heading name: ie: First Name, Last Name, City, etc.
<table border="1" width="100%">
<tr>
<th width="15%">
<CFOUTPUT>
<FORM ACTION="contsearch.cfm" METHOD="POST">
<INPUT TYPE="hidden" NAME="First_name" VALUE="#form.First_Name#">
<INPUT TYPE="hidden" NAME="Last_name" VALUE="#form.Last_Name#">
<INPUT TYPE="hidden" NAME="Organization_name"
VALUE="#Organization_Name#">
<INPUT TYPE="hidden" NAME="City" VALUE="#City#">
<INPUT TYPE="hidden" NAME="Zip_Code" VALUE="#Zip_Code#">
<INPUT TYPE="hidden" NAME="County" VALUE="#County#">
<INPUT TYPE="hidden" NAME="Contact_ID"
VALUE="#PreserveSingleQuotes(idList)#">
<INPUT TYPE="hidden" NAME="OrderBy" VALUE="First_Name">
<INPUT TYPE="hidden" NAME="Classification_Code"
VALUE="#Classification_Code#">
<INPUT TYPE="SUBMIT" VALUE="First Name">
</FORM>
</CFOUTPUT>
</th>
Each belonging to a form which passes the query variables as hidden fields
plus #OrderBy# as First Name, Last Name, City, etc.
Works like a charm but not as pretty as sending everything along via WDDX,
I guess.
Would still be interested if someone had a niftier way...
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
