I think my first post failed :-(
SQL with JOIN
CFOUTPUT with group
<cfquery datasource="#dsn#" name="qryPetPerson">
SELECT tblPerson.id, tblPerson.name,
tblPets.pet
FROM tblPerson, tblPets
WHERE tblPets.ownerID = tblPerson.id
order by tblPerson.id
</cfquery>
<table>
<cfoutput query="qryPetPerson" group="id">
<tr>
<td>#ID#</td>
<td>#name#</td>
<cfoutput>
<td>#pet#<br></td>
</cfoutput>
</tr>
</cfoutput>
</table>
On 20 March 2010 06:32, brandon kennedy <[email protected]> wrote:
>
> 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:331910
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
