Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

how to pass array to Jaguar

3 posts in General Discussion (old) Last posting was on 2000-03-20 18:12:47.0Z
Peter Kuit Posted on 2000-03-19 06:10:15.0Z
Newsgroups: sybase.public.easerver
Reply-To: "Peter Kuit" <peterkuit@hotmail.com>
From: "Peter Kuit" <peterkuit@hotmail.com>
Subject: how to pass array to Jaguar
Date: Sun, 19 Mar 2000 14:10:15 +0800
Lines: 108
Organization: Peter Kuit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: brk-24-162.tm.net.my 202.188.24.162
Message-ID: <347_aZo$ShWk$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26127
Article PK: 156806

how to pass a string array to jaguar?

my html script is:

=============
<!--SCRIPT
/* Function to test whether page parameters are defined */
function f_getParam( envparam ) {
if( exists(document.value[envparam] ) ) {
return document.value[envparam]
}
return ""
}

dwLocal =
java.CreateComponent("qcrs/nv_remote_datawindow","iiop://localhost:9000","ja
gadmin","");
dwLocal.setdwobject("wbqcsvr2.pbl","d_search_cofc_table");
dwLocal.setbrowser(document.GetServerVariable("HTTP_USER_AGENT"));
dwLocal.sethtmlobjectname ("dwMine");

dwLocal.settrans("ODBC","ConnectString='DSN=qcrs_oracle;UID=abc;PWD=abc'",
"", "", "", "", "");
var dwMine_action = f_getParam("dwMine_action");
var dwMine_context = f_getParam("dwMine_context");
if ("undefined" != "" + dwMine_action) {
retVal = dwLocal.setaction (dwMine_action, dwMine_context);
}
var s_customer = new Array(6);
var s_order = new Array(6);
s_dummy = f_getParam( "customer_code");
if (s_dummy==""){s_customer[0] = "";}
else{s_customer=s_dummy;}

s_dummy = f_getParam( "order_no");
if (s_dummy==""){s_order[0] = "";}
else{s_order=s_dummy;}

s_args =
"customer_code='\""+s_customer+"\"'|order_no='\""+s_order+"\"'";
dwLocal.setselflink( document.name, s_args);

if (s_customer.length == 0){s_customer[0]="";}
if (s_order.length == 0){s_order[0]="";}

// Set default values based on page parameters.
if (s_customer != "")
{
dwLocal.of_setitem(1,"customer_code",s_customer[0]);
}
if (s_order != "")
{
dwLocal.of_setitem(1,"order_no",s_order[0]);
}
dwLocal.setweight( true, true, true, true, true);
i_retcode = dwLocal.retrievedddw("customer_code",s_customer);
i_retcode = dwLocal.retrievedddw("order_no",s_order);

document.Write( dwLocal.generate());
-->
=============

i looked at the srv.log, i DONT SEE ANY TRACE that dwMine.retrievedddw() is
executing.
i dont even see any error messages related to this call.

fyi: retrievedddw in the PB nvo is defined as Int retrievedddw( string
as_colname, string as_args[]):
// Start of PB NVO
DataWindowChild dwc_1
String s_value
Long l_rows = -1

if ib_trace then of_log_enter("retrievedddw();passed col='"+&
as_column+"';passed array len="+String(UpperBound(as_args)))

IF ids_datastore.GetChild( as_column, dwc_1) = 1 THEN
dwc_1.SetTrans( SQLCA)
l_rows =
wc_1.Retrieve( as_args[1],as_args[2],as_args[3],as_args[4],as_args[5])
END IF

if ib_trace then of_log_exit("retrievedddw() "+String(l_rows))

of_ContinueWork( TRUE)

RETURN 1
// End of PB NVO


i look at the method's property, i can see that the equivalent datatype
given by jaguar during project deployment is qcrs::STRINGSEQ. i assume that
this is jaguar's array implemention, am i right?

i tried playing around with the declaration in my html script:
var s_customer = new Array(6);
or
var s_customer = new Array(5);

still it wont work.

the rest of the method calls are working fine.

tia,
peter


Dave Wolf [Sybase] Posted on 2000-03-19 08:01:17.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: how to pass array to Jaguar
Date: Sun, 19 Mar 2000 03:01:17 -0500
Lines: 125
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: vpn-eme-010.sybase.com 130.214.8.10
Message-ID: <347_Gg64qnXk$GA.201@forums.sybase.com>
References: <347_aZo$ShWk$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26115
Article PK: 156795

A few things

1) I dont think the datawindow takes arrays in any of its methods
2) To work with arrays you'll need my helper classes. They are posted on
here alot.
3) I think there was a bug in 3.5 GA with arrays

Dave Wolf
Internet Applications Division

"Peter Kuit" <peterkuit@hotmail.com> wrote in message
news:aZo$ShWk$GA.202@forums.sybase.com...
> how to pass a string array to jaguar?
>
> my html script is:
>
> =============
> <!--SCRIPT
> /* Function to test whether page parameters are defined */
> function f_getParam( envparam ) {
> if( exists(document.value[envparam] ) ) {
> return document.value[envparam]
> }
> return ""
> }
>
> dwLocal =
>
java.CreateComponent("qcrs/nv_remote_datawindow","iiop://localhost:9000","ja
> gadmin","");
> dwLocal.setdwobject("wbqcsvr2.pbl","d_search_cofc_table");
> dwLocal.setbrowser(document.GetServerVariable("HTTP_USER_AGENT"));
> dwLocal.sethtmlobjectname ("dwMine");
>
> dwLocal.settrans("ODBC","ConnectString='DSN=qcrs_oracle;UID=abc;PWD=abc'",
> "", "", "", "", "");
> var dwMine_action = f_getParam("dwMine_action");
> var dwMine_context = f_getParam("dwMine_context");
> if ("undefined" != "" + dwMine_action) {
> retVal = dwLocal.setaction (dwMine_action, dwMine_context);
> }
> var s_customer = new Array(6);
> var s_order = new Array(6);
> s_dummy = f_getParam( "customer_code");
> if (s_dummy==""){s_customer[0] = "";}
> else{s_customer=s_dummy;}
>
> s_dummy = f_getParam( "order_no");
> if (s_dummy==""){s_order[0] = "";}
> else{s_order=s_dummy;}
>
> s_args =
> "customer_code='\""+s_customer+"\"'|order_no='\""+s_order+"\"'";
> dwLocal.setselflink( document.name, s_args);
>
> if (s_customer.length == 0){s_customer[0]="";}
> if (s_order.length == 0){s_order[0]="";}
>
> // Set default values based on page parameters.
> if (s_customer != "")
> {
> dwLocal.of_setitem(1,"customer_code",s_customer[0]);
> }
> if (s_order != "")
> {
> dwLocal.of_setitem(1,"order_no",s_order[0]);
> }
> dwLocal.setweight( true, true, true, true, true);
> i_retcode = dwLocal.retrievedddw("customer_code",s_customer);
> i_retcode = dwLocal.retrievedddw("order_no",s_order);
>
> document.Write( dwLocal.generate());
> -->
> =============
>
> i looked at the srv.log, i DONT SEE ANY TRACE that dwMine.retrievedddw()
is
> executing.
> i dont even see any error messages related to this call.
>
> fyi: retrievedddw in the PB nvo is defined as Int retrievedddw( string
> as_colname, string as_args[]):
> // Start of PB NVO
> DataWindowChild dwc_1
> String s_value
> Long l_rows = -1
>
> if ib_trace then of_log_enter("retrievedddw();passed col='"+&
> as_column+"';passed array len="+String(UpperBound(as_args)))
>
> IF ids_datastore.GetChild( as_column, dwc_1) = 1 THEN
> dwc_1.SetTrans( SQLCA)
> l_rows =
> wc_1.Retrieve( as_args[1],as_args[2],as_args[3],as_args[4],as_args[5])
> END IF
>
> if ib_trace then of_log_exit("retrievedddw() "+String(l_rows))
>
> of_ContinueWork( TRUE)
>
> RETURN 1
> // End of PB NVO
>
>
> i look at the method's property, i can see that the equivalent datatype
> given by jaguar during project deployment is qcrs::STRINGSEQ. i assume
that
> this is jaguar's array implemention, am i right?
>
> i tried playing around with the declaration in my html script:
> var s_customer = new Array(6);
> or
> var s_customer = new Array(5);
>
> still it wont work.
>
> the rest of the method calls are working fine.
>
> tia,
> peter
>
>
>


Peter Kuit Posted on 2000-03-20 18:12:47.0Z
Newsgroups: sybase.public.easerver
Reply-To: "Peter Kuit" <peterkuit@hotmail.com>
From: "Peter Kuit" <peterkuit@hotmail.com>
Subject: Re: how to pass array to Jaguar
Date: Tue, 21 Mar 2000 02:12:47 +0800
Lines: 133
Organization: Peter Kuit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: brk-24-147.tm.net.my 202.188.24.147
Message-ID: <347_I4xSmZpk$GA.290@forums.sybase.com>
References: <347_aZo$ShWk$GA.202@forums.sybase.com> <347_Gg64qnXk$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26069
Article PK: 156074

thanks a lot.

Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
news:Gg64qnXk$GA.201@forums.sybase.com...
> A few things
>
> 1) I dont think the datawindow takes arrays in any of its methods
> 2) To work with arrays you'll need my helper classes. They are posted on
> here alot.
> 3) I think there was a bug in 3.5 GA with arrays
>
> Dave Wolf
> Internet Applications Division
>
> "Peter Kuit" <peterkuit@hotmail.com> wrote in message
> news:aZo$ShWk$GA.202@forums.sybase.com...
> > how to pass a string array to jaguar?
> >
> > my html script is:
> >
> > =============
> > <!--SCRIPT
> > /* Function to test whether page parameters are defined */
> > function f_getParam( envparam ) {
> > if( exists(document.value[envparam] ) ) {
> > return document.value[envparam]
> > }
> > return ""
> > }
> >
> > dwLocal =
> >
>
java.CreateComponent("qcrs/nv_remote_datawindow","iiop://localhost:9000","ja
> > gadmin","");
> > dwLocal.setdwobject("wbqcsvr2.pbl","d_search_cofc_table");
> > dwLocal.setbrowser(document.GetServerVariable("HTTP_USER_AGENT"));
> > dwLocal.sethtmlobjectname ("dwMine");
> >
> >
dwLocal.settrans("ODBC","ConnectString='DSN=qcrs_oracle;UID=abc;PWD=abc'",
> > "", "", "", "", "");
> > var dwMine_action = f_getParam("dwMine_action");
> > var dwMine_context = f_getParam("dwMine_context");
> > if ("undefined" != "" + dwMine_action) {
> > retVal = dwLocal.setaction (dwMine_action, dwMine_context);
> > }
> > var s_customer = new Array(6);
> > var s_order = new Array(6);
> > s_dummy = f_getParam( "customer_code");
> > if (s_dummy==""){s_customer[0] = "";}
> > else{s_customer=s_dummy;}
> >
> > s_dummy = f_getParam( "order_no");
> > if (s_dummy==""){s_order[0] = "";}
> > else{s_order=s_dummy;}
> >
> > s_args =
> > "customer_code='\""+s_customer+"\"'|order_no='\""+s_order+"\"'";
> > dwLocal.setselflink( document.name, s_args);
> >
> > if (s_customer.length == 0){s_customer[0]="";}
> > if (s_order.length == 0){s_order[0]="";}
> >
> > // Set default values based on page parameters.
> > if (s_customer != "")
> > {
> > dwLocal.of_setitem(1,"customer_code",s_customer[0]);
> > }
> > if (s_order != "")
> > {
> > dwLocal.of_setitem(1,"order_no",s_order[0]);
> > }
> > dwLocal.setweight( true, true, true, true, true);
> > i_retcode = dwLocal.retrievedddw("customer_code",s_customer);
> > i_retcode = dwLocal.retrievedddw("order_no",s_order);
> >
> > document.Write( dwLocal.generate());
> > -->
> > =============
> >
> > i looked at the srv.log, i DONT SEE ANY TRACE that dwMine.retrievedddw()
> is
> > executing.
> > i dont even see any error messages related to this call.
> >
> > fyi: retrievedddw in the PB nvo is defined as Int retrievedddw( string
> > as_colname, string as_args[]):
> > // Start of PB NVO
> > DataWindowChild dwc_1
> > String s_value
> > Long l_rows = -1
> >
> > if ib_trace then of_log_enter("retrievedddw();passed col='"+&
> > as_column+"';passed array len="+String(UpperBound(as_args)))
> >
> > IF ids_datastore.GetChild( as_column, dwc_1) = 1 THEN
> > dwc_1.SetTrans( SQLCA)
> > l_rows =
> > wc_1.Retrieve( as_args[1],as_args[2],as_args[3],as_args[4],as_args[5])
> > END IF
> >
> > if ib_trace then of_log_exit("retrievedddw() "+String(l_rows))
> >
> > of_ContinueWork( TRUE)
> >
> > RETURN 1
> > // End of PB NVO
> >
> >
> > i look at the method's property, i can see that the equivalent datatype
> > given by jaguar during project deployment is qcrs::STRINGSEQ. i assume
> that
> > this is jaguar's array implemention, am i right?
> >
> > i tried playing around with the declaration in my html script:
> > var s_customer = new Array(6);
> > or
> > var s_customer = new Array(5);
> >
> > still it wont work.
> >
> > the rest of the method calls are working fine.
> >
> > tia,
> > peter
> >
> >
> >
>
>