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)
