As noted, it is non-standard.
-----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 20 September 2006 12:32 To: CF-Talk Subject: RE: How to get these query results Why is it bad code? Is it slower to process? Rick -----Original Message----- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 1:03 AM To: CF-Talk Subject: RE: How to get these query results Michael, You really need to learn inner joins, sorry but that is bad sql code without it. 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 2:55 PM To: CF-Talk Subject: RE: How to get these query results <cfquery name="your_query"> SELECT * FROM dates_table, events_table WHERE dates_table.EventID = events_table.EventID </cfquery> <cfoutput query="your_query" group="EventID"> #EventName#<br> <cfoutput group="EventDate"> #EventDate#<br> </cfoutput> <br> <br> </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:253582 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
