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.

Itemchanged event on dddw's

5 posts in General Discussion (old) Last posting was on 2000-03-19 06:25:00.0Z
Jorge Luzarraga C. Posted on 2000-03-08 22:15:10.0Z
Newsgroups: sybase.public.easerver
From: "Jorge Luzarraga C." <jluzarra@alboradasystems.com>
Subject: Itemchanged event on dddw's
Date: Wed, 8 Mar 2000 17:15:10 -0500
Lines: 15
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: 209.170.68.205
Message-ID: <347_fwgly9Ui$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26852
Article PK: 157818

Hi Guys,

I'm wondering how I could code a powerdynamo script in order to load a dddws
that takes parameter according to another ddws whenever the user changes the
selected item.

Any example would help me a lot

--
Ing. Jorge Luzarraga C.
Analista de Sistemas
Alborada Systems, S.A.
www.alboradasystems.com


Larry Cermak[Team Sybase] Posted on 2000-03-09 05:22:07.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: Itemchanged event on dddw's
Date: Wed, 8 Mar 2000 23:22:07 -0600
Lines: 55
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: node6.dhcpchi.dslspeed.zyan.com 208.41.199.6
Message-ID: <347_fZEyniYi$GA.201@forums.sybase.com>
References: <347_fwgly9Ui$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26820
Article PK: 157791

This will force a reload of the page, but it can be done with the
itemchanged event. Hold on, let me find an example...

<SCRIPT language=JavaScript>
function dwMine_ItemChanged(row, colName, newValue)
{
if (colName == "profession")
{
link = "s_verify_license_criteria.html?profession=" + newValue
parent.right.location.href = link
}
}
</SCRIPT>

s_verify_license_criteria.html is the same window that this code is for.
So, I'm getting the field named profession and then reloading the same page
with that as a parameter. Then in the server-side script of
s_verify_license_criteria.html check if document.value.profession exists and
if so take appropriate action.

if exists (document.value.profession)
{
call whatever method to load dddws (customized component)
}

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"Jorge Luzarraga C." <jluzarra@alboradasystems.com> wrote in message
news:fwgly9Ui$GA.111@forums.sybase.com...
> Hi Guys,
>
> I'm wondering how I could code a powerdynamo script in order to load a
dddws
> that takes parameter according to another ddws whenever the user changes
the
> selected item.
>
> Any example would help me a lot
>
> --
> Ing. Jorge Luzarraga C.
> Analista de Sistemas
> Alborada Systems, S.A.
> www.alboradasystems.com
>
>


Jorge Luzarraga C. Posted on 2000-03-09 15:56:51.0Z
Newsgroups: sybase.public.easerver
From: "Jorge Luzarraga C." <jluzarra@alboradasystems.com>
Subject: Re: Itemchanged event on dddw's
Date: Thu, 9 Mar 2000 10:56:51 -0500
Lines: 128
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: 209.170.68.205
Message-ID: <347_LrJvHPei$GA.251@forums.sybase.com>
References: <347_fwgly9Ui$GA.111@forums.sybase.com> <347_fZEyniYi$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:26792
Article PK: 157766

Larry,
I'm rather confused about this, I understand what the javascript function
does but don't know how to call it from my dynamo script. Besides as I'm not
a pro in Javascript code, I don't know how to get the parameter to call my
retrieve function.

My idea is to get the page with the following parameters:

...dw3.stm?tipprd2=00640&codfab2=V&codveh=006&...
Here is my code:

<HTML>

<HEAD>
<TITLE>Datos Iniciales</TITLE>
</HEAD>
<BODY>
<!--SCRIPT
document.writeln("Creating Component...");
dwMine =
java.CreateComponent("Generator/HTMLGenerator","iiop://myip:9000",
"jagadmin","","Generator/HTMLGenerator");
if ( dwMine != null ){

document.write("Generating HTML Datawindow...");
dwMine.setdwobject("web.pbl","d_web_forma1");
dwMine.sethtmlobjectname("dwMine");
dwMine.setbrowser(document.GetServerVariable("HTTP_USER_AGENT"));

dwMine.settrans("ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',St
ripParmNames='Yes'","","","","","");
retVal2 = dwMine.retrieve2('tipprd','00640',
"ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',StripParmNames='Ye
s'");
retVal2 = dwMine.retrieve2('codfab','V',
"ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',StripParmNames='Ye
s'");
retVal2 = dwMine.retrieve4('tipveh','006','A','V',
"ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',StripParmNames='Ye
s'");
dwMine.retrieve3();
dwMine.setselflink(document.name,"");
dwMine.setweight(true,true,true,true,true);
document.write(dwMine.generate());

}
else{
document.writeln("No se pudo crear el componente deseado");
file://document.writeln(site.getErrorInfo());
}


-->

<script language=JavaScript
var tipprd2
function dwMine_itemChanged(row,colName,newValue)
{
if(colName == 'tipprd')
{
link = "dw3.stm?tipprd2="+newValue
parent.right.location.href = link
}
}
</script>
</BODY>
</HTML>

Larry Cermak[Team Sybase] <lcermak@ctpartners.com> wrote in message
news:fZEyniYi$GA.201@forums.sybase.com...
> This will force a reload of the page, but it can be done with the
> itemchanged event. Hold on, let me find an example...
>
> <SCRIPT language=JavaScript>
> function dwMine_ItemChanged(row, colName, newValue)
> {
> if (colName == "profession")
> {
> link = "s_verify_license_criteria.html?profession=" + newValue
> parent.right.location.href = link
> }
> }
> </SCRIPT>
>
> s_verify_license_criteria.html is the same window that this code is for.
> So, I'm getting the field named profession and then reloading the same
page
> with that as a parameter. Then in the server-side script of
> s_verify_license_criteria.html check if document.value.profession exists
and
> if so take appropriate action.
>
> if exists (document.value.profession)
> {
> call whatever method to load dddws (customized component)
> }
>
> --
>
> Larry Cermak [Team Sybase]
> Corporate Technology Partners, Inc.
> www.ctpartners.com
> Web DataWindow Articles
> (http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
>
>
> "Jorge Luzarraga C." <jluzarra@alboradasystems.com> wrote in message
> news:fwgly9Ui$GA.111@forums.sybase.com...
> > Hi Guys,
> >
> > I'm wondering how I could code a powerdynamo script in order to load a
> dddws
> > that takes parameter according to another ddws whenever the user changes
> the
> > selected item.
> >
> > Any example would help me a lot
> >
> > --
> > Ing. Jorge Luzarraga C.
> > Analista de Sistemas
> > Alborada Systems, S.A.
> > www.alboradasystems.com
> >
> >
>
>


Larry Cermak[Team Sybase] Posted on 2000-03-10 04:42:34.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: Itemchanged event on dddw's
Date: Thu, 9 Mar 2000 22:42:34 -0600
Lines: 151
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: node6.dhcpchi.dslspeed.zyan.com 208.41.199.6
Message-ID: <347_hbbTQxki$GA.74@forums.sybase.com>
References: <347_fwgly9Ui$GA.111@forums.sybase.com> <347_fZEyniYi$GA.201@forums.sybase.com> <347_LrJvHPei$GA.251@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26722
Article PK: 157708

If you select client-events and client-scriptable on the datawindow, it will
generate the calls to the client-side events, like ItemChanged for you. All
you have to do is make sure that you name the client-side function correct.

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"Jorge Luzarraga C." <jluzarra@alboradasystems.com> wrote in message
news:LrJvHPei$GA.251@forums.sybase.com...
> Larry,
> I'm rather confused about this, I understand what the javascript function
> does but don't know how to call it from my dynamo script. Besides as I'm
not
> a pro in Javascript code, I don't know how to get the parameter to call my
> retrieve function.
>
> My idea is to get the page with the following parameters:
>
> ...dw3.stm?tipprd2=00640&codfab2=V&codveh=006&...
> Here is my code:
>
> <HTML>
>
> <HEAD>
> <TITLE>Datos Iniciales</TITLE>
> </HEAD>
> <BODY>
> <!--SCRIPT
> document.writeln("Creating Component...");
> dwMine =
> java.CreateComponent("Generator/HTMLGenerator","iiop://myip:9000",
> "jagadmin","","Generator/HTMLGenerator");
> if ( dwMine != null ){
>
> document.write("Generating HTML Datawindow...");
> dwMine.setdwobject("web.pbl","d_web_forma1");
> dwMine.sethtmlobjectname("dwMine");
> dwMine.setbrowser(document.GetServerVariable("HTTP_USER_AGENT"));
>
>
dwMine.settrans("ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',St
> ripParmNames='Yes'","","","","","");
> retVal2 = dwMine.retrieve2('tipprd','00640',
>
"ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',StripParmNames='Ye
> s'");
> retVal2 = dwMine.retrieve2('codfab','V',
>
"ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',StripParmNames='Ye
> s'");
> retVal2 = dwMine.retrieve4('tipveh','006','A','V',
>
"ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',StripParmNames='Ye
> s'");
> dwMine.retrieve3();
> dwMine.setselflink(document.name,"");
> dwMine.setweight(true,true,true,true,true);
> document.write(dwMine.generate());
>
> }
> else{
> document.writeln("No se pudo crear el componente deseado");
> file://document.writeln(site.getErrorInfo());
> }
>
>
> -->
>
> <script language=JavaScript
> var tipprd2
> function dwMine_itemChanged(row,colName,newValue)
> {
> if(colName == 'tipprd')
> {
> link = "dw3.stm?tipprd2="+newValue
> parent.right.location.href = link
> }
> }
> </script>
> </BODY>
> </HTML>
> Larry Cermak[Team Sybase] <lcermak@ctpartners.com> wrote in message
> news:fZEyniYi$GA.201@forums.sybase.com...
> > This will force a reload of the page, but it can be done with the
> > itemchanged event. Hold on, let me find an example...
> >
> > <SCRIPT language=JavaScript>
> > function dwMine_ItemChanged(row, colName, newValue)
> > {
> > if (colName == "profession")
> > {
> > link = "s_verify_license_criteria.html?profession=" + newValue
> > parent.right.location.href = link
> > }
> > }
> > </SCRIPT>
> >
> > s_verify_license_criteria.html is the same window that this code is for.
> > So, I'm getting the field named profession and then reloading the same
> page
> > with that as a parameter. Then in the server-side script of
> > s_verify_license_criteria.html check if document.value.profession exists
> and
> > if so take appropriate action.
> >
> > if exists (document.value.profession)
> > {
> > call whatever method to load dddws (customized component)
> > }
> >
> > --
> >
> > Larry Cermak [Team Sybase]
> > Corporate Technology Partners, Inc.
> > www.ctpartners.com
> > Web DataWindow Articles
> > (http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
> >
> >
> > "Jorge Luzarraga C." <jluzarra@alboradasystems.com> wrote in message
> > news:fwgly9Ui$GA.111@forums.sybase.com...
> > > Hi Guys,
> > >
> > > I'm wondering how I could code a powerdynamo script in order to load a
> > dddws
> > > that takes parameter according to another ddws whenever the user
changes
> > the
> > > selected item.
> > >
> > > Any example would help me a lot
> > >
> > > --
> > > Ing. Jorge Luzarraga C.
> > > Analista de Sistemas
> > > Alborada Systems, S.A.
> > > www.alboradasystems.com
> > >
> > >
> >
> >
>
>


Peter Kuit Posted on 2000-03-19 06:25:00.0Z
Newsgroups: sybase.public.easerver
Reply-To: "Peter Kuit" <peterkuit@hotmail.com>
From: "Peter Kuit" <peterkuit@hotmail.com>
Subject: Re: Itemchanged event on dddw's
Date: Sun, 19 Mar 2000 14:25:00 +0800
Lines: 183
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_Lm9lmpWk$GA.202@forums.sybase.com>
References: <347_fwgly9Ui$GA.111@forums.sybase.com> <347_fZEyniYi$GA.201@forums.sybase.com> <347_LrJvHPei$GA.251@forums.sybase.com> <347_hbbTQxki$GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26126
Article PK: 156805

hi jorge,
i think your problem is in the client-side scripting:
should be:
function dwMine_ItemChanged()
not
dwMine_itemChanged()

UpperCase: Item

actually, we have the same requirement. i might help you if you browse my
posting:
'how to pass array to jaguar' dated today (march 19).

hth,
peter

Larry Cermak[Team Sybase] <lcermak@ctpartners.com> wrote in message
news:hbbTQxki$GA.74@forums.sybase.com...
> If you select client-events and client-scriptable on the datawindow, it
will
> generate the calls to the client-side events, like ItemChanged for you.
All
> you have to do is make sure that you name the client-side function
correct.
>
> --
>
> Larry Cermak [Team Sybase]
> Corporate Technology Partners, Inc.
> www.ctpartners.com
> Web DataWindow Articles
> (http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
>
>
> "Jorge Luzarraga C." <jluzarra@alboradasystems.com> wrote in message
> news:LrJvHPei$GA.251@forums.sybase.com...
> > Larry,
> > I'm rather confused about this, I understand what the javascript
function
> > does but don't know how to call it from my dynamo script. Besides as I'm
> not
> > a pro in Javascript code, I don't know how to get the parameter to call
my
> > retrieve function.
> >
> > My idea is to get the page with the following parameters:
> >
> > ...dw3.stm?tipprd2=00640&codfab2=V&codveh=006&...
> > Here is my code:
> >
> > <HTML>
> >
> > <HEAD>
> > <TITLE>Datos Iniciales</TITLE>
> > </HEAD>
> > <BODY>
> > <!--SCRIPT
> > document.writeln("Creating Component...");
> > dwMine =
> > java.CreateComponent("Generator/HTMLGenerator","iiop://myip:9000",
> > "jagadmin","","Generator/HTMLGenerator");
> > if ( dwMine != null ){
> >
> > document.write("Generating HTML Datawindow...");
> > dwMine.setdwobject("web.pbl","d_web_forma1");
> > dwMine.sethtmlobjectname("dwMine");
> > dwMine.setbrowser(document.GetServerVariable("HTTP_USER_AGENT"));
> >
> >
>
dwMine.settrans("ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',St
> > ripParmNames='Yes'","","","","","");
> > retVal2 = dwMine.retrieve2('tipprd','00640',
> >
>
"ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',StripParmNames='Ye
> > s'");
> > retVal2 = dwMine.retrieve2('codfab','V',
> >
>
"ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',StripParmNames='Ye
> > s'");
> > retVal2 = dwMine.retrieve4('tipveh','006','A','V',
> >
>
"ODBC","ConnectString='DSN=as_file;UID=myuser;PWD=mypwd;',StripParmNames='Ye
> > s'");
> > dwMine.retrieve3();
> > dwMine.setselflink(document.name,"");
> > dwMine.setweight(true,true,true,true,true);
> > document.write(dwMine.generate());
> >
> > }
> > else{
> > document.writeln("No se pudo crear el componente deseado");
> > file://document.writeln(site.getErrorInfo());
> > }
> >
> >
> > -->
> >
> > <script language=JavaScript
> > var tipprd2
> > function dwMine_itemChanged(row,colName,newValue)
> > {
> > if(colName == 'tipprd')
> > {
> > link = "dw3.stm?tipprd2="+newValue
> > parent.right.location.href = link
> > }
> > }
> > </script>
> > </BODY>
> > </HTML>
> > Larry Cermak[Team Sybase] <lcermak@ctpartners.com> wrote in message
> > news:fZEyniYi$GA.201@forums.sybase.com...
> > > This will force a reload of the page, but it can be done with the
> > > itemchanged event. Hold on, let me find an example...
> > >
> > > <SCRIPT language=JavaScript>
> > > function dwMine_ItemChanged(row, colName, newValue)
> > > {
> > > if (colName == "profession")
> > > {
> > > link = "s_verify_license_criteria.html?profession=" + newValue
> > > parent.right.location.href = link
> > > }
> > > }
> > > </SCRIPT>
> > >
> > > s_verify_license_criteria.html is the same window that this code is
for.
> > > So, I'm getting the field named profession and then reloading the same
> > page
> > > with that as a parameter. Then in the server-side script of
> > > s_verify_license_criteria.html check if document.value.profession
exists
> > and
> > > if so take appropriate action.
> > >
> > > if exists (document.value.profession)
> > > {
> > > call whatever method to load dddws (customized component)
> > > }
> > >
> > > --
> > >
> > > Larry Cermak [Team Sybase]
> > > Corporate Technology Partners, Inc.
> > > www.ctpartners.com
> > > Web DataWindow Articles
> > > (http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
> > >
> > >
> > > "Jorge Luzarraga C." <jluzarra@alboradasystems.com> wrote in message
> > > news:fwgly9Ui$GA.111@forums.sybase.com...
> > > > Hi Guys,
> > > >
> > > > I'm wondering how I could code a powerdynamo script in order to load
a
> > > dddws
> > > > that takes parameter according to another ddws whenever the user
> changes
> > > the
> > > > selected item.
> > > >
> > > > Any example would help me a lot
> > > >
> > > > --
> > > > Ing. Jorge Luzarraga C.
> > > > Analista de Sistemas
> > > > Alborada Systems, S.A.
> > > > www.alboradasystems.com
> > > >
> > > >
> > >
> > >
> >
> >
>
>