There's something screwy with the way the MySQL JDBC driver converts MySQL's computed strings to native types on newer versions of MySQL. I'm willing to bet this is because MM shipped CF with a version of the JDBC driver that's several years old. You can use CAST(... AS CHAR) around your expression and CF will handle it correctly, or you can use the toString() CF built-in function around the value when using it. Either will work.
cheers, barneyb On 1/24/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > For some odd reason ColdFusion returns binary column types when the CAST > function is used from within mySQL. > > Would you mind taking a look at this thread on Sitepoint and offering any > opinions, I'm the poster. > > http://www.sitepoint.com/forums/showthread.php?p=2450978#post2450978 > > <!----------------//------ > andy matthews -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230352 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
