I think this has been asked answered, but I want to be clear on something about <cfqueryparam>.
All of the examples in this thread show <cfqueryparam> being used in a WHERE clause, and I understand the benefits of doing that now. Will I get the same benefit if I use them on an INSERT statement, e.g.: INSERT INTO user (firstname,lastname) VALUES ( <cfqueryparam cfsqltype="cf_sql_varchar" value=#myfirstname#>, <cfqueryparam cfsqltype="cf_sql_varchar" value=#mylastname#> ) I'm going to guess the simple answer is "yes", but I'm not sure if bind variables work the same with insert (or even UPDATE) statements as they would with SELECT statements. Thanks again, Ben ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
