Morning, Now I remember this from a while back but can't remember what the solution was: after using a date function in MySQL such as DATE_FORMAT the field returns has a binary value such as "50484851454948455050" instead of the required date string of "2003-10-22". I can convert the binary by doing a chr(x) on every group of 2 characters, but surely there's a better way?
Also, does anyone know how I can do a valuelist() on a query column that I don't know the name of, such as valuelist(myquery[colname])? I tried that and it wasn't having any of it... 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]
