On 7/5/05, Russ <[EMAIL PROTECTED]> wrote: > I believe SQL (and probably oracle) will cache the execution path if you > use a cfqueryparam..
Right, but my point was that if you did not pass variables into your cfquery, why would you need a cfqueryparam? for example, consider this select statement: select emp.name, emp.salary from emp where emp.id = 324 would you use a cfqueryparam in the above query? like this: select emp.name, emp.salary from emp where emp.id = <cfqueryparam cfsqltype="cf_sql_varchar" value="324"> I would have to say you could, but it is not necessary. Using it won't give you any advantage since cfqueryparam is used for variable binding, and since there is no variable to bind, why use it? -- Eddie. http://awads.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211210 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54