Michael, You still use the cfoutput as I sent through before in another message, just that your sql query is preaching bad standards that's all:-) Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273
-----Original Message----- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 3:39 PM To: CF-Talk Subject: RE: How to get these query results Btw, Andrew, can you also send your idea on how it should be done on the SQL query with joins, but this time include your CF tags to output the results? I truly want to see how much better it is from a simple select with a simple cfoutput grouping. Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253569 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

