Pointer to a recordset?

[DomTrix]

The setup:
----------

I have several different queries that return recordsets from stored procedures on my SQL database. The data that each query returns contains the same fields and I want to display them in the same way. Each query has a different cfprocreturn name so that they can be uniquely identified.

The Sting:
----------

I want to write one module to display the sets of records. So this module needs a single query name, or other reference to a recordset, to display in a cfloop loop.

Question:
---------

Is there a way I can reference the cfprocresult set so that I can pass it as a parameter to my module (or set a request variable that will be available to the module).


Hope that makes sense and someone can help.

DT

 

[ecobb]

You may can put all of the procresults into an array.



Hope This Helps!

ECAR
ECAR Technologies, LLC

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[DomTrix]

Thankyou, I have now used a CFC approach where I store the results in a structure that contains arrays for each field so kinda like you said