Barney... Correct. CAST ( ... AS CHAR) does not work. BUT...the REALLY bizarre thing that I found last night is that the query works when I remove the DISTINCT keyword from the beginning of the SELECT statement.
The query returns binary results for each row WITH the DISTINCT keyword and normal results without it. Wierdest thing ever! <!----------------//------ 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 4:38 PM To: CF-Talk Subject: Re: Question about ColdFusion and the mySQL CAST function CAST(.. AS CHAR) in your SQL didn't work? I know it's an extra step to add around computed columns, but it lets CF behave as if the JDBC driver works as intended, which means things like CFDUMP will work as well. cheers, barneyb ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230415 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
