Hi,
I am trying to convert some method actions to the <@callmethod> tag with
parameters but I cannot get the results into a variable. The
<@callmethod> tag without parameters works fine.
Here is my object creation, query being used and the method call:
<@ASSIGN NAME="vInfogatherobj" VALUE='<@CREATEOBJECT
OBJECTID="InfoGather.tcf" TYPE="TCF">' SCOPE="domain">
<@ASSIGN NAME="vsqlstatement" VALUE="select * from manager2.dbo.usrnames
with (nolock) where clientid=@@user$vclientid" SCOPE="request">
<@ASSIGN NAME="varrayout" VALUE='<@CALLMETHOD OBJECT="vInfogatherobj"
SCOPE="Domain" METHOD="sqlarray(@@request$vsqlstatement,)"
METHODTYPE="get">' SCOPE="request">
I get an output variable that I did not create: request$__t28=
The method action takes 2 parameters (an input and an output),
@@request$vsqlstatement and @@request$varrayout
The documentation is not to clear.
I've tried
<@ASSIGN NAME="varrayout" VALUE='<@CALLMETHOD
OBJECT="vInfogatherobj" SCOPE="Domain" METHOD="sqlarray(<@VARPARAM
NAME=vsqlstatement scope=request>)" METHODTYPE="invoke">'
SCOPE="request">
Ted Wolfley
Lead Internet and Database Programmer
The Ogden Group of Rochester
phone: (585) 321 1060 x23
fax: (585) 321 0043
[email protected] <mailto:[email protected]>
www.ogdengroup.com <http://www.ogdengroup.com>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf