This is a situation where the group property of cfoutput comes in very handy:
<cfoutput query="qImages" group="prop">
<!--- Do stuff with a property ---></cfoutput>
<cfoutput><!--- Do stuff with each instance of the property, eg process an image field ---></cfoutput
Cheers
Blair
Okay, so how would I actually get the query, though? To do it the way you're suggesting, I would have to run the query when the user clicks a row in the grid. The query would get all of the images linked to the ID of the selected row, and then I could output them.
The question is: how do I pass the ID to the query and make it run every time a new row is clicked? I believed that was what bindings were supposed to offer a solution to? And that, of course, brings us back to needing everything to be in one query so I can bind it to the grid.
The sub-selects that have been selected won't work - the server I'm on is running MySQL 4.0.26 and apparently that can't handle them. So can anyone else come up with a way I can write this query so that I get the following criteria filled?:
* Each property appears in the recordset, regardless of whether or not it has images
* Each property knows the details for it's agent, referenced by agentID
* Properties with more than one image will appear only once in the recordset, but will know about all of their images.
Cheers,
Seona.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
