Teddy, No interuption at all, I appreciate the response :) Anyway, for now, that is exactly how we're handling it. We just decided to put a trim on the coldfusion side.
After talking to some database folk it seems to be a known Oracle JDBC driver issue. I'm not sure if there are workarounds on their end or not, but this seems to be the driving factor. We're in the midst of talking to some DBA's and figuring out why the drivers cause this issue. We have these type of sql statements all throughout our application, so now it requires us to add the trim on the Coldfusion side in all those places . .. where before that was never necessary. Just didn't make sense to us why it changed, but to your point at least there is a solution that takes care of it. Anyway again, thanks for the response! Take care, Jen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
