Doug I too thought that the 'join' syntax was more proper but you do make a very valid point... the WACK does actually go in to some depth about joins using the where clause as perfectly acceptable before moving on to show the 'join syntax' as being an alternative.
to quote from the book: "Both tell your database driver to do the same thing, so use the syntax you prefer. You'll probably find you have a personal preference; I happen to find the WHERE syntax more intuitive." If it's good enough for Ben, I wouldn't argue against that strongly Andrew ! ;-) On 9/20/06, Doug Brown <[EMAIL PROTECTED]> wrote: > 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:253588 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
