Steve I have solved the first part. I was sending the two variables to the cfc seperately When I did the network debugging I could see that there were 2 sql requests in CF So what you need to do is in flash is cfcExample.getSecond(var1, var2);
Now just got to sort out the text field presentation Andrew -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Budan Sent: 24 May 2002 08:32 To: '[EMAIL PROTECTED]' Subject: RE: [CFTALKTor] Flash remoting with 2 or more variables I had this problem as well. I don't recall what fixed it. I do my remoting at home, I'll have a look to see if I can figure out what I did. I used the commenting out method to figure it out. Have you tried that with the second function? If you comment everything out and don't get the error, then you know the error really doesn't have anything to do with Var1. A table and a grid component would be great, and I'm also no up to writing one. -steve -----Original Message----- From: Andrew Clark [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 9:22 AM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] Flash remoting with 2 or more variables Steve Thanks for taking the time out. I have tried "any" without success but will play around with it more The weird thing is that the exact same argument works in the first function when it is the sole one There are some ideas floating around for a table component. I think there is one in the extensions section at macromedia and there is a tutorial on ultrashock for a grid. I'm hoping we get something robust and flexible soon. I'm certainly not up to constructing one Andrew -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Budan Sent: 24 May 2002 08:12 To: '[EMAIL PROTECTED]' Subject: RE: [CFTALKTor] Flash remoting with 2 or more variables Hi Andrew, Ok so first let me say, I'm no expert with remotting, but try either not specifying the argument type or set to something like "any". There maybe an issue when you call the cf function from flash, if you pass the argument with "" around it I believe it is a string no matter the content. I'm not 100% sure about this though. Re #2) dunno, but sure would like to. What I would like to know is basically how to get a similar result as using HTML tables and CF, the ever popular <cfloop> <tr><td>#data#</td></tr></cfloop>. I find listbox and textarea to not always be the greatest for display. Let us know what the answer is. -steve -----Original Message----- From: Andrew Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 8:28 PM To: [EMAIL PROTECTED] Subject: [CFTALKTor] Flash remoting with 2 or more variables A couple of queries 1) With Flash remoting is it possible to pass two arguments to a function? The first function works fine where var1 is obtained from a list box <cffunction name="getFirst" > <cfargument name="Var1" type="numeric"> <CFQUERY NAME="q_a"> SELECT * FROM tblA WHERE ID=#Var1# </CFQUERY> <cfreturn q_a> </cffunction> However, I then want some details related to a specific time period for that ID I use the calendar UI. Var2 is the date <cffunction name="getSecond" > <cfargument name="Var1" type="numeric"> <cfargument name="Var2" type="date"> <CFQUERY NAME="q_b"> SELECT * FROM tblB WHERE ID=#Var1# and Date=#Var2# </CFQUERY> <cfreturn q_b> </cffunction> I get an error "The argument Var1 passed to function getSecond is not of the type numeric" It is a number and works in function getFirst I have tried alternatives such as just passing the var2 argument and referring to #getFirst.Var1# or #1_a.Var1# without success The calendar component aspects work correctly i.e if I hardcode var1 in getSecond I obtain the correct answer 2) If I want to use a listbox to report the result I can do My_lb.setDataProvider(result); How would I do it with a dynamic text field, My_txt. Do I need to set the var field to anything in properties and what would be the correct AS to show the result Cheers Andrew - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Andrew Clark" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Steve Budan <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Andrew Clark" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Steve Budan <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Andrew Clark" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
