Re: Witango-Talk: @callmethod

[Dale Graham]

Just a thought, but if you refer to an array in other Witango calls, they are 
called this way

array='request$vsqlstatement'
NOT
array='@@request$vsqlstatement'

That is, Witango is looking for an array as a variable, and therefore the <@var 
or @@ is presumed already  and you will (typically) get the "request$__t28" 
sort of response when you miscall an array.

If you're still having issues using Bill's format, try changing it by calling 
the arrays that way and see if that fixes things. 

On Feb 24, 2010, at 1:22 PM, Bill Downall wrote:

> Ted,
> 
> Try:
> 
> <@callmethod object='domain$vInfogatherobj' 
>  method='sqlarray("@@reqeust$vsqlstatement", "<@varparam name=vArrayOut 
> scope=request>")' methodtype='invoke'>
> 
> Bill
> On Wed, Feb 24, 2010 at 12:15 PM, Ted Wolfley  wrote:
> 
> 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="varrayout" VALUE='<@CALLMETHOD OBJECT="vInfogatherobj" 
> SCOPE="Domain" METHOD="sqlarray(@@request$vsqlstatement,)" METHODTYPE="get">' 
> SCOPE="request">
> 
> The method action takes 2 parameters (an input and an output), 
> @@request$vsqlstatement and @@request$varrayout
> 
> I’ve tried
> 
> <@ASSIGN NAME="varrayout" VALUE='<@CALLMETHOD OBJECT="vInfogatherobj" 
> SCOPE="Domain" METHOD="sqlarray(<@VARPARAM NAME=vsqlstatement 
> scope=request>)" METHODTYPE="invoke">' SCOPE="request">
> 
> 
> 
> 
> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: @callmethod

[Bill Downall]

Ted,

Try:

<@callmethod object='domain$vInfogatherobj'
 method='sqlarray("@@reqeust$vsqlstatement", "<@varparam name=vArrayOut
scope=request>")' methodtype='invoke'>

Bill

On Wed, Feb 24, 2010 at 12:15 PM, Ted Wolfley  wrote:

>  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="varrayout" VALUE='<@CALLMETHOD OBJECT="vInfogatherobj"
> SCOPE="Domain" METHOD="sqlarray(@@request$vsqlstatement,)"
> METHODTYPE="get">' SCOPE="request">
>
> The method action takes 2 parameters (an input and an output),
> @@request$vsqlstatement and @@request$varrayout
>
> I’ve tried
>
> <@ASSIGN NAME="varrayout" VALUE='<@CALLMETHOD OBJECT="vInfogatherobj"
> SCOPE="Domain" METHOD="sqlarray(<@VARPARAM NAME=vsqlstatement
> scope=request>)" METHODTYPE="invoke">' SCOPE="request">
>
>
>


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: @callmethod

[Ted Wolfley]

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 
t...@ogdengroup.com  

www.ogdengroup.com  



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf