Solved

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

Posted on 2008-06-22
7
184 Views
Last Modified: 2012-06-27
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

0
Comment
Question by:Eric Bourland
  • 4
  • 3
7 Comments
 
LVL 63

Accepted Solution

by:
Zvonko earned 500 total points
ID: 21843576
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
 
LVL 3

Author Comment

by:Eric Bourland
ID: 21843592
Interesting. I'm going to work on this. Thank you Zvonko.
0
 
LVL 63

Expert Comment

by:Zvonko
ID: 21843618
You are welcome.
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 3

Author Comment

by:Eric Bourland
ID: 21852527
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
 
LVL 3

Author Comment

by:Eric Bourland
ID: 21856182
Zvonko, this worked gorgeously and made sense. Thank you.

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

Have a great day.

Eric
0
 
LVL 3

Author Closing Comment

by:Eric Bourland
ID: 31469624
Very useful solution.
0
 
LVL 63

Expert Comment

by:Zvonko
ID: 21856451
Thank you for the feedback Eric.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Coldfusion print HTML tables 4 48
Coldfusion get content of HTML table 8 122
coldfusion, jQuery help 25 72
Problem with data displaying 2 12
Hi, I will be creating today a basic tutorial on how we can create a Mail Custom Function and use it where ever we want. The main advantage about creating a custom function is that we can accommodate a range of arguments to pass to the Function and …
This is an updated version of a post made on my blog over 3 years ago. It is unfortunately, still very relevant as we continue to see both SQLi (SQL injection) and XSS (cross site scripting) attacks hitting some of the most recognizable website and …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now