> So in order to get this performance boost we wouldn't be able
> to use CF if's in the statement? I have one query which I made
> that has something like this
>
> If this
> where something = #something#
> end if
>
> So am I correct in assuming cfqueryparam would have no
> benefit for me unless I made seperate queries?
Fortunately, no, you're not correct. The prepared statement is generated at
runtime, using the string you create with your CF conditional logic.
However, you can't use the CF 4+ CACHEDWITHIN/CACHEDAFTER attributes with
CFQUERYPARAM.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
