Skip to main content
Participant
April 7, 2008
Question

cfloop with parameter array

  • April 7, 2008
  • 1 reply
  • 238 views
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.
    This topic has been closed for replies.

    1 reply

    Inspiring
    April 7, 2008
    <cfloop array="#yourarray#" index="arrayel">
    <cfquery...>
    ...
    WHERE ticketno = '#arrayel#'
    </...

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