Yes there is....
itemToAdd
={DSN:"Test",SourceTable:recordsetname.SourceTable,SourceField:recordsetname.SourceField,NewValue:newvalue,ContactID:_global.ContactID};
newvalues_rs.addItem(itemToAdd)
-----Original Message-----
From: Collin Tobin [mailto:[EMAIL PROTECTED]]
Sent: 02 October 2002 18:04
To: CF-Talk
Subject: RE: Recordset as cfargument?
Paul-
So you have columns in your local recordset, but is there data?
Collin Tobin
QA Engineer
617 219 2000
[EMAIL PROTECTED]
MacromediaŽ
What the web can be.(tm)
-----Original Message-----
From: Paul Wilson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 1:16 PM
To: CF-Talk
Subject: RE: Recordset as cfargument?
I can't get it working. Can you take a look at my code.
If my actionscript recordset has the followingstructure...
newvalues_rs=new RecordSet(["DSN","SourceTable","SourceField","NewValue","ContactID"])
and my method call is ...
service.UpdateContactRS(newvalues_rs)
In my cfc i have......
<cffunction name="UpdateContactRS" access="remote" returntype="string">
<cfargument name="DCRecordSet" type="query" required="Yes">
<cfloop query="#DCRecordSet#">
<cfstoredproc datasource="#dsn#" procedure="sp_CallFlowUpdateContact">
<cfprocparam dbvarname="@BoundTable" cfsqltype="CF_SQL_VARCHAR"
value="#SourceTable#">
<cfprocparam dbvarname="@BoundField" cfsqltype="CF_SQL_VARCHAR"
value="#SourceField#">
<cfprocparam dbvarname="@NewValue" cfsqltype="CF_SQL_VARCHAR"
value="#NewValue#">
<cfprocparam dbvarname="@ContactID" cfsqltype="CF_SQL_INTEGER"
value="#ContactID#">
</cfstoredproc>
</cfloop>
</cffunction>
Thanks
-----Original Message-----
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: 02 October 2002 16:46
To: CF-Talk
Subject: RE: Recordset as cfargument?
It should be converted to a query. So your argument would be:
<cfargument name="whatever" type="query" required="true or
false, up to you">
=======================================================================
Raymond Camden, ColdFusion Jedi Master for Hire
Email : [EMAIL PROTECTED]
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Paul Wilson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 02, 2002 11:56 AM
> To: CF-Talk
> Subject: Recordset as cfargument?
>
>
> How can I pass a recordset from Flash to ColdFusion through
> Flash remoting and loop through the recordset in the cfc?
>
> In actionscript I have......
>
> myservice.UpdateContactRS(newvalues_rs) // This sends the
> recordset to the cfc
>
> I know i need a function (cffunction) called
> "UpdateContactRS", but how do i use the recordset? What is
> the datatype in CF?
>
> Thanks
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
