Hi Daniel Im not sure here but have you tried using single quotes instead of double quotes? I think the correct syntax uses single quotes.
-----Original Message----- From: Daniel Morphett [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 March 2003 2:10 PM To: CFAussie Mailing List Subject: [cfaussie] mysql binary return I'm querying a mysql db, using the following statement 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/ ************** IMPORTANT MESSAGE ************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. ************************************************** --- 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/
