Column header sort not working

Please see attached file. Can you tell me why the column header sort isn't working? Sorry ... it's in ColdFusion...

I don't receive any errors - it just doesn't sort. Thanks!

your sort link is passing a column name that does not exist "applicantLastName":

<a href="tblScholarshipsAwarded_Results.cfm?sort=tblApplicants.applicantLastName">


it should be "last_name"

<a href="tblScholarshipsAwarded_Results.cfm?sort=tblApplicants.last_name">

Jason, that still doesn't work, and the field dateAwarded doesn't sort either. No errors, it just doesn't work...??/

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Jason, I just got it working. This piece of code was missing from the query:

#PreserveSingleQuotes(WADA_Sort_1.FinalOrderClause)#

I now used this code to replace the default sort order. Thanks!

ok, glad to hear it is working.

Thanks, Jason. You can cancel the support request.

Cool, will do.

(pheewee, dodged the CFM bullet.......)

Hahahaha! Yes, you did dodge that one :)