Hello,
I'm playing around with "query of queries" to lighten the load on our server and make the code a little more compact. Problem I've run into is that the method of ordering alphanumerics seems to change when ordering a call from a query of query as opposed to doing it directly from the database tables. Specifially, ALLCAPS names come before uppercase names. For example, EVERETT comes before Eackart... and Zigfield comes before applegate. I guess the coldfusion is treating all capital characters as a distict set that comes before all lowercase letters. Pretty stupid.
Anyway around this problem? Here's my code....
<CFQUERY Name = "DisplayAllAttendeesbyAuthNum" Datasource = "#sourcename#">
SELECT AttendeeInfo.RefNum, AttendeeInfo.FName, AttendeeInfo.LName, PayProccessed.PayAuthNum
FROM AttendeeInfo, PayProccessed
WHERE AttendeeInfo.RefNum = PayProccessed.RefNum AND PayProccessed.PayAuthNum <> ''
ORDER by PayProccessed.PayAuthNum
</CFQUERY>
<CFQUERY Name = "DisplayAllAttendeesbyAuthNumSortbyLName" dbtype="query">
SELECT *
FROM DisplayAllAttendeesbyAuthNum
ORDER by LName
</CFQUERY>
I'm playing around with "query of queries" to lighten the load on our server and make the code a little more compact. Problem I've run into is that the method of ordering alphanumerics seems to change when ordering a call from a query of query as opposed to doing it directly from the database tables. Specifially, ALLCAPS names come before uppercase names. For example, EVERETT comes before Eackart... and Zigfield comes before applegate. I guess the coldfusion is treating all capital characters as a distict set that comes before all lowercase letters. Pretty stupid.
Anyway around this problem? Here's my code....
<CFQUERY Name = "DisplayAllAttendeesbyAuthNum" Datasource = "#sourcename#">
SELECT AttendeeInfo.RefNum, AttendeeInfo.FName, AttendeeInfo.LName, PayProccessed.PayAuthNum
FROM AttendeeInfo, PayProccessed
WHERE AttendeeInfo.RefNum = PayProccessed.RefNum AND PayProccessed.PayAuthNum <> ''
ORDER by PayProccessed.PayAuthNum
</CFQUERY>
<CFQUERY Name = "DisplayAllAttendeesbyAuthNumSortbyLName" dbtype="query">
SELECT *
FROM DisplayAllAttendeesbyAuthNum
ORDER by LName
</CFQUERY>