cffunction with a loop inside - need some advice

[Les Mizzell]

OK - before I tried turning this particular problem into a service, I 
had a simple query like this, which works (examples simplified for 
clarity, whatever that is!):

<cfloop from="1" to="#form.totalPERSONS#" index="idx">
   <cfquery name="WRITE_ENROLL">
      INSERT INTO participants (
        enrID,
        part_class )
   VALUES (
        #evaluate("form.enrID#idx#")#,
        '#evaluate("form.part_class#idx#")#' )
   </cfquery>
</cfloop>


The function to handle this once converted is failing with 'Can't 
generate stub....blan, blah.... so I've got a syntax problem or just 
simply don't know what I'm doing trying to translate the above.

Here's what I've got:

To invoke the beast:

<cfinvoke webservice="myWEBSERVICE"
           method="ENROLLMENTS"
           WStotalPERSONS="#form.totalPERSONS#"
<cfloop from="1" to="#form.totalPERSONS#" index="idx">
    WSenrID#idx#="#evaluate("form.enrID#idx#")#"
    WSpart_class#idx#="#evaluate("form.part_class#idx#")#"
</cfloop>

 >


And here's the function:

<cffunction name="ENROLLMENT_TWO"
             access="remote"
             returntype="query" >
                                                        
<cfargument name="WStotalPERSONS" type="numeric" />
<cfloop from="1" to="#arguments.WStotalPERSONS#" index="idx">
    <cfargument name="WSenrID#idx#" type="string" />
    <cfargument name="WSpart_class#idx#" type="string" />
</cfloop>
                                                                                
<cfloop from="1" to="#WStotalPERSONS#" index="idx">
   <cfquery name="WRITE_ENROLL">
INSERT INTO participants (
   enrID,
   part_class )
VALUES (
   WSenrID#idx#,
   'WSpart_class#idx#")#' )
</cfquery>

</cfloop>




I probably need to rethink the way this particular function has to work, 
but I desperately need some pointers please!

Thanks,


Les


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264101
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4