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
