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
