Hey gang - In the middle of a project and have run across an oddity, and I have yet to find any answers - I'm under the gun here.
Working on migrating our main database from MS SQL Server to MySQL. So far so good. Two different versions of CF running on different boxes - CF8 (works great) and CF6 (problem). On the CF6 box, queries to tables that work fine in CF8 have an issue - bit fields don't return 0 or 1 - instead they're returning the ASCII codes for 0 and 1. Is this an ODBC driver issue or what? I can code around it for the meantime but I'd like to get it back to returning the query results I'm used to. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:326454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
