Hey Dave,
I have waited for a while for this :) You can do this:
myQuery['col_id']['rowNumber']
On CF 4.5 on Solaris at least. It also works in CFMX on Win 2k.
My test code:
<CFQUERY name="getStuff" datasource="home">
select * from guestbook
</CFQUERY>
<CFOUTPUT>
<CFLOOP list="#getStuff.columnlist#" index="i">
<CFLOOP from="1" to="#getStuff.recordCount#" index="ii">
#getStuff[i][ii]#<br>
</CFLOOP>
</CFLOOP>
#getStuff['cFirstName'][3]#
</CFOUTPUT>
Tim
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 10:05 PM
To: CF-Talk
Subject: RE: Help with using query with [] notation
> I know it's possible to do something like this:
> MyQuery["FieldName"] (I know it's probably wrong, but
> serves the purpose here)
For the record, you can't do that, but you can do this:
MyQuery.FieldName[i]
to reference the column value at row i.
> The CF Documentation does mention this somewhere, but doesn't
> really go into detail. Does anyone know of any good links,
> articles, or resources that describe this in more detail???
> I'd prefer to understand this properly, rather than just find
> the "solution" for my current situation. Not to mention that
> it would be better if I can direct my coworkers and
> subordinates to these resources as well....
The only mention of it of which I'm aware is in the "Advanced ColdFusion
Development" course offered by MM, but I suspect it's in the docs somewhere.
However, there really isn't that much else to say about it, beyond the three
lines near the top of the message. You can reference a column's value for a
specific row using array notation.
Of course, how you use this is up to you. For example, if you wanted to
refer to the last row of a recordset, you could do it like this:
MyQuery.FieldName[MyQuery.RecordCount]
Or, you could use this feature to loop over the recordset in a CFSCRIPT
block, since there's nothing analogous to the QUERY attribute of CFOUTPUT
within CFSCRIPT:
<cfscript>
for (i = 1; i lte MyQuery.RecordCount; i = i + 1) {
WriteOutput(MyQuery.FieldName[i] & "<br>");
}
</cfscript>
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
