Title: RE: [CFCDev] CF running Witango

 

If you omit cfqueryparam for even one value in a query and just reference it directly, then the processing speed benefits of using the tag are negated. Does using a variable for Order By also negate the speed benefits of cfqueryparam?

 

Does this maintain the queryparam speed boost:

 

<cfquery>

SELECT Field1

FROM Table

WHERE Field2 = <cfqueryparam value="#Value#" cfsqltype="cf_sql_varchar" />

ORDER BY #variable#

</cfquery>

 

Cheers,

Baz

 

 

----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).

An archive of the CFCDev list is available at www.mail-archive.com/[email protected]

Reply via email to