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.
Thanks Brett >Brett, >It appears your doing some sort of search. > >Have you looked into the cfindex and cfsearch tags? If this is what your >doing, I think you would find these tags useful instead of doing a straight >sql query. It also has bonus features like sorting by relevancy which sql >doesn't have. > >http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_i_06.html- >cfIndex >http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_r-s_13.html- >cfSearch > >Paul Alkema >http://www.AlkemaDesigns.com > > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327822 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
