Val list
query.columnlist
<cfloop list="#query.columnlist#" index="idx">
<cfset temp = evaluate("#idx# = valuelist(query.#idx#)")>
</cfloop>
Of course this will create a list for each column.
> -----Original Message-----
> From: Tim Blair [mailto:[EMAIL PROTECTED]
> Sent: 29 January 2004 11:54
> To: [EMAIL PROTECTED]
> Subject: [ cf-dev ] MySQL date functions returning binary data
>
>
> 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]
>
>
>
--
** 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]
