Or use a two dimensional array aMyArray[i][1]='MyQueryname'; aMyArray[i][2]=referencetoQueryObject
A On 10 July 2012 16:55, websolete <[email protected]> wrote: > 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 > -- 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
