Is there an easy way re-order data -- using the same ColdFusion template?

Hi. I have a simple ColdFusion application that displays data from a database:

http://ascassociation.org/chicagoOct2008_view_registration.cfm

(Code snippet attached. This page, when it launches later this week, will be secured by HTTPS.)

Currently this CF template sorts information by RegistrationID.

I want to offer the user the ability to sort information by Date Submitted | Name | Facility / Company.

(See the links at the top of the page.)

I could write three other templates to sort the information in these three different ways.

But, is there an easier way?

I am thinking some kind of CFIF statement would do. IF the user clicks here, THEN she sees the information sorted by Name. Etc.

But I am not sure how to code that. Or if this is the right path.

Does anybody have advice regarding this?

I'd like to try very hard to learn this task well. Rather than supplying me code, can you give me a hint, or start me off in a way that allows me to teach myself? This improves my education.

Thanks very much!

Peace,

Eric
<cfinclude template="/SiteHeader.cfm">
 
<p class="align-center">[ Sort By: <a href="/chicagoOct2008_view_registration.cfm">Registration ID</a> | <a href="#">Date Submitted</a> | <a href="#">Name</a> | <a href="#">Facility / Company</a> ]</p>
 
 
 <!--- Display values into database columns --->
<cfquery datasource="ebwebwork" dbname="ascassociation" name="viewRegistration">
	SELECT RegistrationID,
		Name,
		Degree,
		Title,
		FacilityCompany,
		Address1,
		Address2,
		City,
		State,
		Zip,
		Phone,
		Fax,
		Email,
		WebSite,
		MainConference1stAttendeeAmountBefore8Sep625,
		MainConference2ndAttendeeAmountBefore8Sep575,
		MainConference3rdAttendeeAmountBefore8Sep525,
		MainConference4thAttendeeAmountBefore8Sep500,
		MainConference1stAttendeeAmountAfter8Sep725,
		MainConference2ndAttendeeAmountAfter8Sep675,
		MainConference3rdAttendeeAmountAfter8Sep625,
		MainConference4thAttendeeAmountAfter8Sep600,
		MainandPreConference1stAttendeeAmountBefore8Sep825,
		MainandPreConference2ndAttendeeAmountBefore8Sep775,
		MainandPreConference3rdAttendeeAmountBefore8Sep725,
		MainandPreConference4thAttendeeAmountBefore8Sep700,
		MainandPreConference1stAttendeeAmountAfter8Sep975,
		MainandPreConference2ndAttendeeAmountAfter8Sep875,
		MainandPreConference3rdAttendeeAmountAfter8Sep825,
		MainandPreConference4thAttendeeAmountAfter8Sep800,
		BeckersASCReviewSpecialDiscount,
		ASCReviewSubscriberDiscountFifty,
		TotalEnclosed,
		CheckEnclosed,
		CheckNumber,
		AuthorizeCharge,
		CreditCard,
		CreditCardNumber,
		ExpirationDate,
		PrintedCardHolderName,
		CreditCardZIPCode,
		CVV,
		DateCreated
		
FROM RegistrationEntries
ORDER BY RegistrationID
 
</cfquery>
 
 
 
 
 
<cfoutput query="viewRegistration">
 
	  <cfif CurrentRow MOD 2 IS 1>
<cfset bgcolor="##FFFFFF">
<cfelse>
<cfset bgcolor="##ebebeb">
</cfif>
 
<p style="background-color:#bgcolor#;padding:10px;margin:20px 0;">
 
<strong>RegistrationID:</strong> #RegistrationID# [<a href="deleteChicagoRegOct2008.cfm?RegistrationID=#RegistrationID#" onclick="return confirm('Are you sure you want to delete this Registration Entry?')">Delete</a>]
 
<br />
<strong>Name:</strong> #Name#<br />
<strong>Degree:</strong> #Degree#<br />
<strong>Title:</strong> #Title#<br />
<CFIF FacilityCompany IS NOT ""><strong>Facility / Company:</strong> #FacilityCompany#<br /></CFIF>
<strong>Address Line 1:</strong> #Address1#<br />
<CFIF Address2 IS NOT ""><strong>Address Line 2:</strong> #Address2#<br /></CFIF>
<strong>City:</strong> #City#<br />
<strong>State:</strong> #State#<br />
<strong>Zip:</strong> #Zip#<br />
<strong>Phone:</strong> #Phone#<br />
<CFIF Fax IS NOT ""><strong>Fax:</strong> #Fax#<br /></CFIF>
<strong>Email:</strong> #Email#<br />
<CFIF WebSite IS NOT ""><strong>Web Site:</strong> #WebSite#<br /></CFIF>
<CFIF MainConference1stAttendeeAmountBefore8Sep625 IS NOT ""><strong>Main Conference 1st Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainConference1stAttendeeAmountBefore8Sep625#<br /></CFIF>
<CFIF MainConference2ndAttendeeAmountBefore8Sep575 IS NOT ""><strong>Main Conference 2nd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainConference2ndAttendeeAmountBefore8Sep575#<br /></CFIF>
<CFIF MainConference3rdAttendeeAmountBefore8Sep525 IS NOT ""><strong>Main Conference 3rd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainConference3rdAttendeeAmountBefore8Sep525#<br /></CFIF>
<CFIF MainConference4thAttendeeAmountBefore8Sep500 IS NOT ""><strong>Main Conference 4th Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainConference4thAttendeeAmountBefore8Sep500#<br /></CFIF>
<CFIF MainConference1stAttendeeAmountAfter8Sep725 IS NOT ""><strong>Main Conference 1st Attendee Amount Remitted After 8 Sep 2008:</strong> #MainConference1stAttendeeAmountAfter8Sep725#<br /></CFIF>
<CFIF MainConference2ndAttendeeAmountAfter8Sep675 IS NOT ""><strong>Main Conference 2nd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainConference2ndAttendeeAmountAfter8Sep675#<br /></CFIF>
<CFIF MainConference3rdAttendeeAmountAfter8Sep625 IS NOT ""><strong>Main Conference 3rd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainConference3rdAttendeeAmountAfter8Sep625#<br /></CFIF>
<CFIF MainConference4thAttendeeAmountAfter8Sep600 IS NOT ""><strong>Main Conference 4th Attendee Amount Remitted After 8 Sep 2008:</strong> #MainConference4thAttendeeAmountAfter8Sep600#<br /></CFIF>
<CFIF MainandPreConference1stAttendeeAmountBefore8Sep825 IS NOT ""><strong>Main and PreConference 1st Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference1stAttendeeAmountBefore8Sep825#<br /></CFIF>
<CFIF MainandPreConference2ndAttendeeAmountBefore8Sep775 IS NOT ""><strong>Main and PreConference 2nd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference2ndAttendeeAmountBefore8Sep775#<br /></CFIF>
<CFIF MainandPreConference3rdAttendeeAmountBefore8Sep725 IS NOT ""><strong>Main and PreConference 3rd Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference3rdAttendeeAmountBefore8Sep725#<br /></CFIF>
<CFIF MainandPreConference4thAttendeeAmountBefore8Sep700 IS NOT ""><strong>Main and PreConference 4th Attendee Amount Remitted Before 8 Sep 2008:</strong> #MainandPreConference4thAttendeeAmountBefore8Sep700#<br /></CFIF>
<CFIF MainandPreConference1stAttendeeAmountAfter8Sep975 IS NOT ""><strong>Main and PreConference 1st Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference1stAttendeeAmountAfter8Sep975#<br /></CFIF>
<CFIF MainandPreConference2ndAttendeeAmountAfter8Sep875 IS NOT ""><strong>Main and PreConference 2nd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference2ndAttendeeAmountAfter8Sep875#<br /></CFIF>
<CFIF MainandPreConference3rdAttendeeAmountAfter8Sep825 IS NOT ""><strong>Main and PreConference 3rd Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference3rdAttendeeAmountAfter8Sep825#<br /></CFIF>
<CFIF MainandPreConference4thAttendeeAmountAfter8Sep800 IS NOT ""><strong>Main and PreConference 4th Attendee Amount Remitted After 8 Sep 2008:</strong> #MainandPreConference4thAttendeeAmountAfter8Sep800#<br /></CFIF>
<CFIF FacilityCompany IS NOT ""><strong>Beckers ASC Review Special Discount:</strong> #BeckersASCReviewSpecialDiscount#<br /></CFIF>
<CFIF FacilityCompany IS NOT ""><strong>ASC Review Subscriber Discount ($50):</strong> #ASCReviewSubscriberDiscountFifty#<br /></CFIF>
<CFIF FacilityCompany IS NOT ""><strong>Total Enclosed:</strong> #TotalEnclosed#<br /></CFIF>
<CFIF FacilityCompany IS NOT ""><strong>Check Enclosed:</strong> #CheckEnclosed#<br /></CFIF>
<CFIF FacilityCompany IS NOT ""><strong>Check Number:</strong> #CheckNumber#<br /></CFIF>
<CFIF FacilityCompany IS NOT ""><strong>Authorize Charge:</strong> #AuthorizeCharge#<br /></CFIF>
<CFIF FacilityCompany IS NOT ""><strong>Credit Card:</strong> #CreditCard#<br /></CFIF>
<CFIF CreditCardNumber IS NOT ""><strong>Credit Card Number:</strong>#CreditCardNumber#<br /></CFIF>
<CFIF ExpirationDate IS NOT ""><strong>Expiration Date:</strong>#ExpirationDate#<br /></CFIF>
<CFIF PrintedCardHolderName IS NOT ""><strong>Printed Card Holder Name:</strong> #PrintedCardHolderName#<br /></CFIF>
<CFIF CreditCardZIPCode IS NOT ""><strong>Credit Card ZIP Code:</strong> #CreditCardZIPCode#<br /></CFIF>
<CFIF CVV IS NOT ""><strong>CVV:</strong> #CVV#<br /></CFIF>
<strong>Date Submitted:</strong> #DateCreated#
 
  </p>
</cfoutput>
  
 
 
 
<cfinclude template="/SiteFooter.cfm">

Open in new window

LVL 3
Eric BourlandAsked:
Who is Participating?
 
ZvonkoConnect With a Mentor Systems architectCommented:
Sorry to give you code :)



<p class="align-center">[ Sort By: <a href="?sort=RegistrationID">Registration ID</a> | <a href="?sort=DateCreated">Date Submitted</a> | <a href="?sort=Name">Name</a> | <a href="?sort=FacilityCompany">Facility / Company</a> ]</p>
 
<cfparam name="url.sort" default="RegistrationID" >



....
            
FROM RegistrationEntries
ORDER BY #url.sort#
 
</cfquery>

0
 
Eric BourlandAuthor Commented:
Interesting. I'm going to work on this. Thank you Zvonko.
0
 
ZvonkoSystems architectCommented:
You are welcome.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Eric BourlandAuthor Commented:
Hi, Zvonko,

Today was a very hectic day, which is not yet over. I will get time to work on your ideas tomorrow. Thanks for your ideas and guidance.

More tomorrow. Have a good evening.

Best from Eric
0
 
Eric BourlandAuthor Commented:
Zvonko, this worked gorgeously and made sense. Thank you.

http://ascassociation.org/chicagoOct2008_view_registration.cfm?sort=DateCreated

Have a great day.

Eric
0
 
Eric BourlandAuthor Commented:
Very useful solution.
0
 
ZvonkoSystems architectCommented:
Thank you for the feedback Eric.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.