At 11:31 AM 05/04/2001 +0100, you wrote:
> > This has always been the behavior of CF. I can agree that it at first
> > glances appears to be counter intuitive, but at the same
> > time, any reference
> > to queryname.fieldname outside the context of a <CFLOOP> or <CFOUTPUT>
> > results in a reference to the value of the field in the first
> > row of the
> > query. The functionality is such that there is no "inheritance" of
> > references.
>
>Well, I think you're at risk of sounding like an apologist for Allaire.
>
>There are a couple of things that I feel need "fixing" in ColdFusion, and
>this is one of them (the other one that springs to mind is the inability to
>optionally specify that empty list elements aren't ignored - really useful
>if you are populating database tables from delimited lists).
>
><CFOUTPUT QUERY="GetParents">
>
> *Crappy CFSET GetParents.ParentID code required here*
>
> <CFOUTPUT QUERY="GetChildren">
>
> #GetParents.ParentID# doesn't increment properly with each
> iteration of the outer loop.... WHY NOT ALLAIRE?!?!
>
> </CFOUTPUT>
></CFOUTPUT>
:huh?: Why would you expect an outer loop control variable to
increment in the inner loop? It doesn't seem to make any sense to me.
I haven't been following this thread, but I will point out that a query
object is an array of structures.
queryname.myfield will return the first row, true.
But you can easily change that to: queryname[10].myfield to return the
10th row, if you wish.
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0 | ISBN: 0-07-213238-8
Due out June 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
