Well - I may not be following you correctly -
But I would guess you need to store the from variables as session variables
and pass what column you want to sort by to your cfc.
Setup your variables:
<cfparam name="SESSION.cntAv" default=""> ..etc
And then on form submit:
<cfif IsDefined("FORM.YOURFORM") AND FORM.YOURFORM EQ "1">
<cfset SESSION.cntAv= FORM.cntAv>
.... etc
Do querry....
<cfinvoke
Component="YourCFC"
Method="getCollDataLib"
Libcode="#SESSION.Libcode#"
Sort="#SESSION.Sort#"
Order="#SESSION.Libcode#"
Returnvariable="BIGTABLE">
</cfif>
In the CFC add something like:
<cfargument name="SORT" type="string" default="l.library">
<cfargument name="ORDER" type="string" default="ASC">
and then at the bottom of your querry:
ORDER BY #ARGUMENTS.SORT# #ARGUMENTS.Order#
And then when you resort - all you have to do is re-hit the cfc - as your
session variables will already be set....
Is that closer?
- Nick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2980
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
