Thanks for the quick reply! No, no... I'm not looking for the column name,
but rather the whole query's name. In other words, let's say I have the
following...
*
<cfquery name="qryWidgets" datasource="myDS">
SELECT Number, Widget_Name, Widget_Date
FROM Widgets
</cfquery>
*
*<cfset myQ = qryWidgets>*
Now I want to know if there is any way to use the variable *myQ* to get the
name or some other uniquely identifiable information of what query is
stored there. So basically, if qryWidgets is passed into a CFC, I want my
CFC to be able to determine that myQ points to qryWidgets versus qryCookies
versus qryEmployees. I know that sounds like it defeats the purpose of a
CFC, but I have a logical reason. Basically I want my CFC to do something
with an array of queries, but then it's important that the results returned
to the user from my CFC be able to indicate which query a certain piece of
the results came from. I could leave it up to the user to keep track
of the order in which each query is added to the array that goes to the
CFC, but the simpler I can make this for the user, the better. The ideal
case would be for the user to send an array of queries to the CFC, then
have the CFC return results that not only show a piece of data, but also
which query that data came from. More details available upon request.
On Tuesday, July 10, 2012 11:42:41 AM UTC-4, J.Lucido wrote:
> I am a little lost here with your specific question. Are you asking
> for the query column name for a specific query resultset at a
> particular row (in your example row '3')? If this is the case, how
> would you not know the query column names? There are functions which
> will give you all the data for a specific query column either as a
> list or an array (queryColumnArray() or queryColumnList()).
>
> One last thought, if you are looking for the value of a specific query
> column and row combination then your would refer to this data as:
> myQueyName['myColumnName'][rowIdx]
>
> Hope this helps a little. If not, clarify your message a little
> further and I will be glad to help.
>
> Good luck,
> -JSLucido
>
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
