> first, put all of your user defined (form) data into 'cfqueryparam'
> tags to protect your database.
> second, you are Ordering by publication date. If you want to group by
> 'netid' then you will need to order by netid first, then by
> publication date. If this is too much to put into your query right
> off, then you can always pull the query results then do a query of a
> query to 're-sort' the results.
>
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:3253
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
