>>No, they can certainly have a bad effect on performance. I must admit two things here: 1. I was more quoting many people here about performance than giving my own experience, 2. personnally, I don't like CFQUERYPARAM, I use it only when really necessary, ie. only on text fields coming from a form in the public part of my sites. If it is only for SQL injection prevention, there are other means that do not make queries unreadable. And there are other kinds of attack CFQUERYPARAM will not protect from anyway.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4