I have a situation where i need to display info from two queries on the same row of a table. Here is the background, each person in a database table has a name and ID which is then linked to another table that lists pets. Each person can have as many as 4 pets. Now i need to display the ID, name, and each pet on the same row of table, preferably with the pets all listed in the same cell. I'm not that experienced with ColdFusion so my first attempt looked like this:
<cfquery datasource="#dsn#" name="person"> SELECT * FROM tblPerson </cfquery> <table> <cfoutput query="person"> <tr> <td>#ID#</td> <td>#name#</td> <cfquery datasource="#dsn#" name="pets"> SELECT * FROM tblPets WHERE ownerID = #person.ID# </cfquery> <cfoutput query="pets"> <td>#pet#<br></td> </cfoutput> </tr> </cfoutput> </table> If you've read this far, i'm sure you know this won't work but i hope can see what i'm trying to do. Please help if have any solutions ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm