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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm