Then switch it from array of queries to struct of queries, and pass in the
struct of queries. You'll have the query name immediately available as the
struct key, and you'll have the added benefit of being able to easily check
whether a given query exists before trying to operate on it:
<cffunction name="processStuff" ...>
<cfargument name="queryStruct" type="struct" required="true">
<cfif structkeyexists(arguments.queryStruct,"qWidgets")>
<!--- do widget query stuff --->
</cfif>
</cffunction>
On Tue, Jul 10, 2012 at 7:07 PM, Matt C <[email protected]> wrote:
> 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
>
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
