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
