I know that a pounded variable in a cfuery alwasy should be cfqueryparam'd And ive herd it actually makes the Query run faster.
but what about non pounded variables take the folowing query: <cfquery name="ListFams" datasource="#dsn#" username="#dbusername#" password="#dbpassword#"> SELECT Child_ID, Firstname, sibs FROM tbl_children WHERE DispWithFamily = 1 and Availability = 1 AND sibs = <cfqueryparam value="#form.sibs#" cfsqltype="CF_SQL_INTEGER" /> ORDER BY sibs DESC </cfquery> Would the query gain a speed benifit like this? <cfquery name="ListFams" datasource="#dsn#" username="#dbusername#" password="#dbpassword#"> SELECT Child_ID, Firstname, sibs FROM tbl_children WHERE DispWithFamily = <cfqueryparam value="1" cfsqltype="CF_SQL_TINYINT" /> AND Availability = <cfqueryparam value="1" cfsqltype="CF_SQL_TINYINT" /> AND sibs = <cfqueryparam value="#form.sibs#" cfsqltype="CF_SQL_INTEGER" /> ORDER BY sibs DESC </cfquery> hard to tell with only 400 records,,, but in a years time this table should be upwards of 300,000 records so every bit of speed i can get... -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 "...the very powerful and the very stupid have one thing in common, they don't alter their views to fit the facts, they alter the facts to fit the views." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:256379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
