>From my view of the code he was building the query by placing all the select criteria into a string. Building the query string dynamically. This string was then referenced in the query. The resulting CFQUERYPARAM would then appear within the query inside of the CFQUERY tag which is indeed a perfectly valid use.
Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Monday, April 28, 2008 9:04 AM To: SQL Subject: Re: Building the where clause using CF Ray, that example is incorrect. You cannot use cfqueryparam in a string like that, or outside of a cfquery block. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3056 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
