Not to keep this thread chiming right along, but just one little thing regarding what is standard and non standard. I am assuming that by not referencing your inner join or outer joins directly is what we are calling (non standard) and visa-versa. My question is then, if this is the case, why are there still books being written with (non-standard) SQL statements in them IE: (CFWACK)? I would assume that Forta knows a few things about standard practices and would adhere to coding standards. This being said, it is hard to jump on people about their coding when they learn this from all the (experts)
Regards, Doug ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, September 20, 2006 5:39 AM Subject: RE: How to get these query results > 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:253585 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
