In regards to your sorting... Here's what I do:
When I need to sort a query - I will often pass the sort back to the page in
the URL...
<cfif IsDefined("URL.SORT")>
ORDER BY #URL.SORT#
#URL.Order#
<cfelse>
ORDER BY LastName
ASC
</cfif>
That way I can place links in the Column heads and pass it back to the
query... Helps with sorting ASC and DESC in cases where Alpha/Numerical
sorting may be confusing/not obvious to the user - as it allows them to sort
they data as the wish.
A complete example would look like: (Which also allows the user to search on
the results as well.)
<cfquery name="qryGetEmailSubscribers" datasource="#Application.DSN#"
username="#Application.username#" password="#Application.password#">
SELECT EmailSubscribers.*
FROM EmailSubscribers
<cfif IsDefined("Form.data")>
WHERE #FORM.type# Like <cfqueryparam
cfsqltype="cf_sql_varchar" value="%#form.data#%">
<cfelse>
<cfif IsDefined("URL.Term") AND #URL.Term#
NEQ "">
WHERE LastName Like "#URL.Term#%"
<cfif IsDefined("URL.SORT")>
ORDER BY #URL.SORT#
#URL.Order#
<cfelse>
ORDER BY LastName
ASC
</cfif>
<cfelse>
<cfif IsDefined("URL.SORT")>
ORDER BY #URL.SORT#
#URL.Order#
<cfelse>
ORDER BY LastName
ASC
</cfif>
</cfif>
</cfif>
</cfquery>
Maybe not the most elegant (?) - but it works.
- Nick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4099
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
