Hi, Neil...I think out conversations are crossing...(reminds me of
why I hated chat rooms... :oP)
Anyway, the code I was referring to was in the original post, not
any post referencing joins...
<cfquery name="your_query">
SELECT *
FROM dates_table,
events_table
WHERE dates_table.EventID = events_table.EventID
</cfquery>
I guess from what Andrew was saying, it would skip a step that
would be necessary by an SQL server to translate it into a join?
But, my question concerning it being "bad code" was, really, how
much slower for probably a small amount of data would this
code be?
(And I was wondering, too, why there would even be a separate
"dates" table in a relational database...if this is a calendar, I would
have put the dates of an event in the event table itself...???)
Rick
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20, 2006 7:39 AM
To: CF-Talk
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:253583
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
