> I specifically said I had not used such some of the options Yeah, but not for your first message.
I'm not trying to offend or anything, simply would like to encourage proper learning and sharing of knowledge. :) > If there is going to be truncation the > DB will inform and the query will fail. You'd think so, but that's exactly why I made the point about datasource renaming - the CF admin settings *will* truncate without falling over, so I don't trust CF code not to do the same thing. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/sql/message.cfm/messageid:3308 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm