Having a few problems migrating to CF-8 and MySQL 5 on Red Hat. We have always used a connection string in CF that allowed dates like 00-00-0000 to be treated as nulls. Found out that we needed a second connection string to enable some of the features of stored procedures but haven't been able to find a syntax that works to concatenate the two strings on Linux. Either one works separately, just not together.
Someone has suggested just turning strict mode off altogether which does both those things and more. But I am wary of creating other problems because I don't know what else it adds much less the syntax for doing so. Rick Maosn ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:299061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4