Have to forgive me my mind is not working too great today(getting over the
flu) but why would it not work? Seems to display correctly using this
sample data: I have two volunteers for the first person who has one degree
then three volunteers for the second person who has one degree then the last
person has two degrees and two volunteers. Although I guess as I type that
out something is not lining up right since I would imagine a volunteer
relates to more than just the person.
<cfscript>
qry1 = queryNew("ENTITYID,FULLNAME,ZIP,DEGREE,VOLUNTID,VOLUNTNAME");
queryAddRow(qry1,1);
querySetCell(qry1,"ENTITYID","0000123450");
querySetCell(qry1,"FULLNAME","John A. Doe");
querySetCell(qry1,"ZIP","48169");
querySetCell(qry1,"DEGREE","BS");
querySetCell(qry1,"VOLUNTID","janedoe1");
querySetCell(qry1,"VOLUNTNAME","Jane A. Doe");
queryAddRow(qry1,1);
querySetCell(qry1,"ENTITYID","0000123450");
querySetCell(qry1,"FULLNAME","John A. Doe");
querySetCell(qry1,"ZIP","48169");
querySetCell(qry1,"DEGREE","BS");
querySetCell(qry1,"VOLUNTID","janedoe2");
querySetCell(qry1,"VOLUNTNAME","Jane B. Doe");
queryAddRow(qry1,1);
querySetCell(qry1,"ENTITYID","0000123451");
querySetCell(qry1,"FULLNAME","John B. Doe");
querySetCell(qry1,"ZIP","27502");
querySetCell(qry1,"DEGREE","BA");
querySetCell(qry1,"VOLUNTID","janedoe3");
querySetCell(qry1,"VOLUNTNAME","Jane C. Doe");
queryAddRow(qry1,1);
querySetCell(qry1,"ENTITYID","0000123451");
querySetCell(qry1,"FULLNAME","John B. Doe");
querySetCell(qry1,"ZIP","27502");
querySetCell(qry1,"DEGREE","BA");
querySetCell(qry1,"VOLUNTID","janedoe4");
querySetCell(qry1,"VOLUNTNAME","Jane D. Doe");
queryAddRow(qry1,1);
querySetCell(qry1,"ENTITYID","0000123451");
querySetCell(qry1,"FULLNAME","John B. Doe");
querySetCell(qry1,"ZIP","27502");
querySetCell(qry1,"DEGREE","BA");
querySetCell(qry1,"VOLUNTID","janedoe5");
querySetCell(qry1,"VOLUNTNAME","Jane E. Doe");
queryAddRow(qry1,1);
querySetCell(qry1,"ENTITYID","0000123450");
querySetCell(qry1,"FULLNAME","John C. Doe");
querySetCell(qry1,"ZIP","48169");
querySetCell(qry1,"DEGREE","BS");
querySetCell(qry1,"VOLUNTID","janedoe1");
querySetCell(qry1,"VOLUNTNAME","Jane A. Doe");
queryAddRow(qry1,1);
querySetCell(qry1,"ENTITYID","0000123450");
querySetCell(qry1,"FULLNAME","John C. Doe");
querySetCell(qry1,"ZIP","48169");
querySetCell(qry1,"DEGREE","AA");
querySetCell(qry1,"VOLUNTID","janedoe2");
querySetCell(qry1,"VOLUNTNAME","Jane B. Doe");
</cfscript>
<cfoutput query="qry1" GROUP="ENTITYID">
#ENTITYID# #FULLNAME# #ZIP# <br>
Degrees: <cfoutput group="DEGREE">#DEGREE# <br></cfoutput>
<cfoutput group="VOLUNTID">
<!--- qry1.entityid should output the CURRENT entity,
but it does not --->
Volunteer: #ENTITYID# #VOLUNTID# #VOLUNTNAME#<br>
</cfoutput>
<br>
</cfoutput>
On 2/22/06, Rick Root <[EMAIL PROTECTED]> wrote:
>
>
>
> Can't do that in my case, because I'm already grouping over OTHER data -
> the degrees. That's why I had to go the route that I did.
>
> Rick
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233150
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
