At 09:28 AM 08/02/2001 -0400, you wrote:
> > Also, its better practice to build your where clause outside
> > of the CFQUERY.
>
>Out of curiosity, what's the reason for this?
I'm jumping in during the middle of this conversation, so bear with me.
If I understand correctly, I have heard this before. I believe the
theory is that stand-alone CF statements are more efficient than nested CF
statements. So, creating your where clause using CFIFs outside of a
CFQUERY tag, and just sending it your generated string to the query is more
efficient than nesting a lot of CFIF's inside the CFQUERY tag.
This is all entirely speculation and I have not done any number crunching
myself. I've also never seen anyone use the method described above.
--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
I'm looking for a room-mate in the Hartford CT area, starting in August
--
Instant ColdFusion 5.0 | ISBN: 0-07-213238-8
http://www.instantcoldfusion.com
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Far Cry Fly, Alternative Folk Rock
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
