This is not a feature of cfqueryparam! It does treat a string as a string - it does no escaping. Your database is the place where the the underscore is being interpreted as a wildcard, not in cfqueryparam.
mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/30 Brett Davis <[email protected]>: > > Paul, > > Yes I am doing a search against a table in the database for either an exact > or a wildcard search on a term. I believe cfindex and cfsearch are more > suited towards searching large volumes of texts and files. My issue really > was a true misunderstanding of what the cfqueryparam and varchar attribute > did and didn't allow. I was under the impression that it treated anything > passed to it as a pure string of text. This was incorrect and I didn't know > it only escaped quotes and not all non alpha numeric. I was expecting it to > treat an underscore as and underscore and not a special wildcard character > like SQL uses. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327828 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
