Also, assuming you're not working with legacy code and it can be easily changed, perhaps the easiest thing is to simply change from an array of queries to a struct of queries, in which case the struct key tells you all you need to know about the original query name.
<cfset myQueryStruct["qFoobar"] = qFoobar> On Tue, Jul 10, 2012 at 6:51 PM, Jeff Lucido <[email protected]> wrote: > Got it, I can see how you got this from his question. I too have no > idea how you would know other than to look at the code where the query > was created and set to the array variable. > > On Tue, Jul 10, 2012 at 10:45 AM, Alex Skinner <[email protected]> wrote: > > I think what he's asking is how can i find out the name of my query > > > > so given > > > > <cfquery name="qFoobar" datasource="myds"> > > Select 1 > > </cfquery> > > > > <cfset myArray[3]=qFooBar> > > > > How would you on myArray[3] be able to work out that the query name was > > qFoobar. > > > > Personally I've no idea, and I think it would depend on how the query was > > made. > > > > cfdirectory, cfpop, queryNew(), cfquery, cfstoredproc, cfsearch etc > > > > Cheers > > > > Alex > > > > > > > > On 10 July 2012 16:42, Jeff Lucido <[email protected]> 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 > >> > >> On Tue, Jul 10, 2012 at 9:21 AM, Matt C <[email protected]> wrote: > >> > Is there any way to take a query object that is stored in a variable > (or > >> > an > >> > array position) and retrieve the query's name? I'm quite surprised I > >> > couldn't just say "myQryArray[3].name". > >> > > >> > -- > >> > 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 > > > > > > > > > > -- > > Alex Skinner > > Managing Director > > Pixl8 Interactive > > > > Tel: +448452600726 > > Email: [email protected] > > Web: pixl8.co.uk > > > > > > -- > > 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 > -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en
