> However this isn't working, whenever I put the loop
> in the output, it only returns one record. When I
> take OUT the loop, it returns all the records but
> only one rate:
>
> ...
>
> And here's version one of the output:
> <cfoutput query="getmylistings" group="PropertyID">
Is there a reason you're using the GROUP attribute in CFOUTPUT? That's only
used when you want to build a hierarchical data display. For example, let's
say you had states and cities, and you wanted to select them all in one
query, but display them like this:
state:
city_in_state
city_in_state
state2:
city_in_state
...
In that case, you could use nested CFOUTPUTs with the GROUP attribute to
display each state once (in the outermost CFOUTPUT), then display all cities
within the nested CFOUTPUT.
<cfoutput query="..." group="state">
#state#:<br>
<cfoutput>
#city_in_state#<br>
</cfoutput>
</cfoutput>
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
