> I guess the question would be, are there better or more proficient ways to > write these cfqueryparams? I haven't been able to find a lot of > "complete" documentation on the use of cfqueryparam. Just bits and pieces > here and there. So I tried to build in as many instances and > different uses as I could in order to get feedback and affirmation from the > experts that are on the forum.
Your examples look pretty good to me, so I'd say no, there aren't better or more proficient ways to write them. In addition to your examples, you'd also want to use CFQUERYPARAM any time you have any user-entered or untrusted data within a query - not just within INSERT/UPDATE/DELETE queries. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
