Well, the biggest reason is that it provides significant protection against SQL injection attacks. It basically does in-line data validation. There have been several discussions here on the list of the various benefits, so a quick search at the HoF site should give you a good idea about it.
--Ben Doom Richard White wrote: >> Also, alot of people will advise you to use cfqueryparam (me included), so >> the code would look like: > > out of interest what is the difference in using the cfqueryparam and not? > > thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296977 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4