cfloop with parameter array

[tj71587]

Hey Everyone,

I would like to pass an array as a parameter, now how would I have to use a cfloop to do the query for each parameter, ie....

<cfloop ......>

<cfquery name="Billing" datasource="#request.dsn#">
UPDATE table
SET field = "value"
WHERE ticketno = 'ArrayValue'
</cfquery>

</cfloop>

Thanks,

T.J.

[Newsgroup_User]

<cfloop array="#yourarray#" index="arrayel">
<cfquery...>
...
WHERE ticketno = '#arrayel#'
</...

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/