Barney... The ToString(column) worked perfectly. Sucks though because I use cfdump a lot to peer into the recordset and when dumping this query, I just get binary. Oh well.
<!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 1:02 PM To: CF-Talk Subject: Re: Question about ColdFusion and the mySQL CAST function 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:230357 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
