When I posed this question to the group some time ago, the consensus was basically your point, but the one counter point the struck me was, "well it's not a variable now, but might it become one in the future?" So, depends on how malleable you feel the code may be over its lifetime.
-------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ....-----Original Message----- ....From: Eddie [mailto:[EMAIL PROTECTED] ....Sent: Tuesday, July 05, 2005 4:29 PM ....To: CF-Talk ....Subject: Re: Query help .... ....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:211211 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
