Netid needs to be the first in the list of the Order by
OR
Do this after the first query is run, but before you do the display.
<cfquery name="qGetPublications" dbtype="query">
Select * from qGetPublications Order By netid asc
</cfquery>
--
William E. Seiter
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
Web Developer
http://William.Seiter.com
-----Original Message-----
From: Adam Parker [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 24, 2008 10:24 AM
To: CF-Newbie
Subject: Re: Group Output
Thank you for the suggestion. I have added the 'cfqueryparam' tags to my
queries. Also, I have changed the ordering of the query to lastname asc,
firstname, publication_date asc. I believe my query is good and is getting
the data I intend to display. Displaying the data is where I think I'm
having the problem.
To output the query, I'm using:
<cfoutput query="qGetPublications" group="netid">
<p><a href="facultyProfile.cfm?netid=#netid#">#lastname#,
#firstname#</a><br />
<em><cfoutput group="citation">#citation#</em><br /><br /></cfoutput>
</p>
</cfoutput>
I'm not sure how I would do a query of a query.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3257
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
