Setting client variables with a query

[Lotruth]

I need to use a query to set client variables equal to each field in the db table for a single record.

To set them with a list of form fields I use this code:
<cfloop index=&quot;element&quot; list=&quot;form.#fieldnames#&quot;>
<cfset &quot;client.#element#&quot;=evaluate(&quot;form.#element#&quot>
</cfloop>

Is there something like query.#fieldnames# that I need to use to create the list? Thanks for your help.

 

[GunJack]

Hey Lotruth,

I think query.columnList is what you're looking for.

Hope this helps,
GJ