I've got a unique situation thats got me a bit stuck. I've got a query that is completely dynamic, as such:
SELECT #form.fieldlist# FROM #form.tablelist# WHERE #form.wherefield# #form.conditional# #form.WhereClause# The results of the query are displayed in a table, with the column headings as links who's intention is to allow for the table to be resorted by clicking on the heading. The problem is, how to get the myriad of FORM variables i've got (which essentially build the report), passed through to the report as it is re-generated with the new order by clause? For obvious reasons, I don't want to use URL variables. I have not played with some of the new features in CF 5, but we will be moving there soon. Perhaps query-a-query can help me? Or is there some way that I can get at the cached results of the query (without rewriting the query) thereby eliminating the need to pass through those variables again? Hopefully this makes sense. Thanks, Brian Grant Programmer/Analyst MATCOM, Inc. Leawood, Kansas [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
