select replace(left(logdatetime, 10),"-",".") as viewday,count(logId) as count_views
from webstats
group by viewday
order by logdatetime
I can execute this fine from mysql control centre, and it comes back as something readable, but running it from coldfusion, brings back a binary result for the replace(left(logdatetime, 10),"-",".") bit. ColdFusion then can't deal with it.
It seems to happen as soon as I use a function in the select statement (I tried using concat() as well, binary too)
Anyone know how to return it as a string?
Daniel Morphett Web Developer, DBA www.daemon.com.au
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
