I have to modify my MSSQL database and change some of my fields from varchars to text fields.
The question I have is that i have a bunch of querys that we are using the <cfqueryparam> function and we are binding with the cfsqltype="varchar". Do I need to go through the entire site and change this to CF_SQL_LONGVARCHAR or will this work fine. I ran some initial test and it looks good, but I am wondering if I am opening a can of worms. we are on CF 7. Thanks. Matt Friedman ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:300704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4