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 On 1/24/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > 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 -- 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:230382 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