RE: Witango-Talk: @callmethod

[Ted Wolfley]

Thanks for your help but I figured it out after reading the
<@callmethod> syntax more carefully. 

 

My method action has an input and an output parameters so using the
following code, the second parameter receives the output array:

<@CALLMETHOD OBJECT='vInfogatherobj' SCOPE='Domain'
METHOD='sqlarray(<@VAR vsqlstatement SCOPE=Request>,<@VARPARAM
NAME="varrayout" SCOPE="request">)' METHODTYPE='invoke'>

 

The confusion came when I dragged over the "Call Method and Assign
Results to Variables" tag from Objects under the Meta Tags .  This tag
does not work with parameters.

<@ASSIGN NAME="" SCOPE="" VALUE=<@CALLMETHOD OBJECT="" SCOPE=""
METHOD="()" METHODTYPE="invoke">

 

Should of known the tag was the problem since it was also missing an
ending ">."

 

Ted

 

From: Dale Graham [mailto:dale.gra...@gmail.com] 
Sent: Wednesday, February 24, 2010 4:31 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: @callmethod

 

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


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

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

Witango-Talk: <@CALLMETHOD>

[Trevor Green]

I have just noticed that using <@CALLMETHOD …..>
within the ERROR HTML of an email action does not seem to work. Is this normal?

 

Trevor Green