> Don't format your data, format your display. ;o)
Unfortunately I can't do that - further processing needs to be done
before it's returned to the display.
The query is for a stats-type thing: "how many occurences of X were
there during time period Y". Doing the query SELECT COUNT(blah), date
GROUP BY DATE_FORMAT(date) doesn't include "zero" days (where there
aren't any records for X occuring on that day) so I have to add them to
the query manually - to do that I need to know what dates are already
there!
Ho hum, I got there but it isn't pretty...
BTW, for future reference, you can treat a binary value as an array and
do something like:
<cfloop from="1" to="#arraylen(binaryval)#" index="i">
<cfset stringval = stringval & chr(binaryval[i])>
</cfloop>
Although I'm *sure* I read somewhere that you could do it a lot easier
than that, possibly involving toString(), but I can't for the life of me
work out where...
Cheers,
Tim.
-------------------------------------------------------
Try the ColdFusion Coding Contest! Current contest:
Maze Solver - http://tech.badpen.com/cfcontest/
-------------------------------------------------------
RAWNET LTD - Internet, New Media and ebusiness Gurus.
WE'VE MOVED - for our new address, please visit our
website at http://www.rawnet.com/ or call us any time
on 0800 294 24 24.
-------------------------------------------------------
This message may contain information which is legally
privileged and/or confidential. If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
-------------------------------------------------------
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
