>
> 5. execute the dataobject
>
This step looks unnecessary and a waste. Since the second page is linked to
the DataObject it would be executed automatically. Otherwise the solution
looks ok. Another place to do that kind of stuff is
this_onBeforeDisplayEvent() of the second Page.
The original mistake was to do addDynamicCriterion() inside
public int this_onBeforeExecuteEvent(CSpDataObjectEvent event)
By the time control reaches this point, it is too late. ND has already
looked at the existing DynamicCriteria and prepared the SQL.
Aby
> -----Original Message-----
> From: Seshu [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 28, 2000 8:26 AM
> To: Shamdasani Nimmi-ANS004
> Cc: 'NetDynamics'
> Subject: Re: [ND] data object with dynamic criteria
>
>
> Nimmi,
>
> After doing what you suggested, it worked fine. Thanks.
>
> Seshu
>
> Shamdasani Nimmi-ANS004 wrote:
>
> > Seshu,
> >
> > I think you can simplify your code by putting everything in the
> > submit_onWebEvent instead of using
> > this_onBeforeExecuteEvent(CSpDataObjectEvent event) too.
> >
> > All you have to do in submit_onWebEvent is
> >
> > 1. get the userSessionObjects uid and pword value.
> >
> > 2. Get a handle to the dataobject
> > CSpSelect doVer =
> (CSpSelect)CSpider.getDataObject("doVerify");
> > 3. clear the dynamic criteria
> >
> > 4. add your dynamic area
> >
> > 5. execute the dataobject
> >
> > 6. proceed with the rest
> >
> > Hope this helps.
> >
> > -Nimmi
> >
> > -----Original Message-----
> > From: Seshu [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, January 28, 2000 8:54 AM
> > To: Aby Mathew
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [ND] data object with dynamic criteria
> >
> > Hi All,
> >
> > Now I undestand the problem but do not know how to fix it.
> I try to explain
> > it
> > more clearly now. In the first page( pagLogin), I have this
> code in the web
> > event of the button.
> >
> > //[[SPIDER_EVENT<submit_onWebEvent>
> > public int submit_onWebEvent(CSpWebEvent event)
> > {
> > CSpider.putUserSessionObject( "sesuserid",
> > getDisplayFieldValue("userid"));
> > CSpider.putUserSessionObject( "sespassword",
> > getDisplayFieldValue("password"));
> >
> > CSpSelect doVer = (CSpSelect)CSpider.getDataObject("doVerify");
> > doVer.execute();
> >
> > return(PROCEED);
> >
> > //]]SPIDER_EVENT<submit_onWebEvent>
> >
> > Two user sessios objects are set and then the call to data
> object is made
> > for
> > it's execution. Then, I have this code in the
> onBeforeExecute event of data
> > object. As can be seen, I am retrieving those user session
> objects which
> > become
> > part of the dynamic criteria. During the first time
> execution of data
> > object,
> > these user session objects are some how not available. In
> the second click
> > of
> > the button ( after using browser back button), the user
> session objects are
> > becoming available and the dynamic criteria is set
> correctly and code
> > executes.
> >
> > I have used user session objects because they are needed in
> a few pages down
> > the
> > login page. I think there may be a better way for doing the
> login validation
> > instead of using the user session objects.
> >
> > //[[SPIDER_EVENT<this_onBeforeExecuteEvent>
> > public int this_onBeforeExecuteEvent(CSpDataObjectEvent event)
> > {
> > CSpString uid =
> (CSpString)CSpider.getUserSessionObject("sesuserid");
> > CSpString pword =
> (CSpString)CSpider.getUserSessionObject("sespassword");
> > String mySQL = new String("dbo.user_prof.id_user = '"+uid+"'"
> > +" AND dbo.user_prof.Password
> ='"+pword+"'");
> > CSpSelect doVer = (CSpSelect)CSpider.getDataObject("doVerify");
> > doVer.clearDynamicCriteria();
> > doVer.addDynamicStrCriterion(mySQL);
> > return (PROCEED);
> > }
> > //]]SPIDER_EVENT<this_onBeforeExecuteEvent>
> >
> > Hope I have clarified. Can any one please provide the solution?
> >
> > Seshu
> >
> > Aby Mathew wrote:
> >
> > > This is a long and somewhat confusing thread. I haven't
> followed it
> > > entirely. The scope of my reply is confined to:
> > >
> > > > Using back button of browser and clicking the button again
> > > > has generated the SQL
> > > > correctly and worked fine.
> > >
> > > This doesn't surprise me. It tells me something is wrong
> with the code or
> > > Linking of the Pages thru the Studio or most likely, a
> combination of
> > both.
> > > Something to watch out for when you combine custom code
> with Studio
> > > (pointy-clicky according to Curt) stuff.
> > >
> > > My guess is that the SQL is executed first time without
> the dynamic
> > > criteria and later some addDynamicCriteria(), implicit or
> explicit is
> > done.
> > > It can be a explicit code in the second page or implicit
> link between the
> > > pages created thru the Studio.
> > >
> > > DynamicCriteria are sticky. Once added, they stay for the
> UserSession
> > unless
> > > cleared.
> > >
> > > Aby
> > > TeamND
> > >
> > > > -----Original Message-----
> > > > From: Seshu [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, January 27, 2000 2:39 PM
> > > > To: Shamdasani Nimmi-ANS004;
> > > > [EMAIL PROTECTED]
> > > > Subject: Re: [ND] data object with dynamic criteria
> > > >
> > > >
> > > > Hi all,
> > > >
> > > > Before I implement what Nimmi has suggested, I explain below
> > > > exact behaviour
> > > > once again.
> > > >
> > > > The first click of has generated this SQL, with no result.
> > > > execute SQL command: |SELECT ALL
> dbo.grp_prof.cd_appl_type_authtn FROM
> > > > dbo.user_prof, dbo.grp_prof WHERE (dbo.user_prof.name_grp =
> > > > dbo.grp_prof.name_grp)|
> > > >
> > > > Using back button of browser and clicking the button again
> > > > has generated the SQL
> > > > correctly and worked fine.
> > > >
> > > > execute SQL command: |SELECT ALL
> dbo.grp_prof.cd_appl_type_authtn FROM
> > > > dbo.user_prof, dbo.grp_prof WHERE (((dbo.user_prof.name_grp =
> > > > dbo.grp_prof.name_grp)) AND dbo.user_prof.id_user =
> 'widmxpHVE' AND
> > > > dbo.user_prof.Password ='hve')|
> > > >
> > > >
> > > > However, I notice another SQL being generated. I do not
> > > > understand how this is
> > > > generated?
> > > >
> > > > SQL command: |SELECT ALL dbo.user_prof.id_user,
> > > > dbo.user_prof.name_user,
> > > > dbo.user_prof.name_grp, dbo.user_prof.name_job_title,
> > > > dbo.user_prof.nbr_ph,
> > > > dbo.user_prof.name_proj, dbo.user_prof.addr_email,
> > > > dbo.user_prof.addr_strt,
> > > > dbo.user_prof.cd_inpt_type, dbo.user_prof.flag_rslt_onli,
> > > > dbo.user_prof.flag_rslt_ftp, dbo.user_prof.id_ftp_lgn,
> > > > dbo.user_prof.text_ftp_pswrd, dbo.user_prof.text_ftp_ip_addr,
> > > > dbo.user_prof.text_trgt_drctry, dbo.user_prof.Password FROM
> > > > dbo.user_prof WHERE
> > > > (dbo.user_prof.id_user = 'widmxpHVE')|
> > > >
> > > >
> > > > Shamdasani Nimmi-ANS004 wrote:
> > > >
> > > > > Yes you do have to put in the join criteria again for
> the tables
> > > > >
> > > > > -Nimmi
> > > > >
> > > > > -----Original Message-----
> > > > > From: Seshu [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Thursday, January 27, 2000 4:07 PM
> > > > > To: Shamdasani Nimmi-ANS004
> > > > > Subject: Re: [ND] data object with dynamic criteria
> > > > >
> > > > > Hi Nimmi,
> > > > >
> > > > > Thanks for your reply. I have another question that I am
> > > > pasting below
> > > > > which
> > > > > I asked Janet in reply back to her. Could you also look
> > > > into and suggest
> > > > > some
> > > > > thing?
> > > > >
> > > > > Hi Janet,
> > > > >
> > > > > Thanks. It worked. But I have one more problem. The
> > > > concerned dataobject is
> > > > > using two tables. And
> > > > > there is one join condition used in the data object
> > > > properties in studio.
> > > > > The
> > > > > first click of the
> > > > > button generates the following SQL.
> > > > >
> > > > > execute SQL command: |SELECT ALL
> > > > dbo.grp_prof.cd_appl_type_authtn FROM
> > > > > dbo.user_prof, dbo.grp_prof
> > > > > WHERE (((dbo.user_prof.name_grp =
> dbo.grp_prof.name_grp)) AND
> > > > > dbo.user_prof.id_user = 'widmxpHVE'
> > > > > AND dbo.user_prof.Password ='hve')|
> > > > >
> > > > > And all the subsequent clicks of the button generate this
> > > > SQL and this works
> > > > > file.
> > > > >
> > > > > SELECT ALL dbo.user_prof.id_user, dbo.user_prof.name_user,
> > > > > dbo.user_prof.name_grp,
> > > > > dbo.user_prof.name_job_title, dbo.user_prof.nbr_ph,
> > > > dbo.user_prof.name_proj,
> > > > > dbo.user_prof.addr_email,
> > > > > dbo.user_prof.addr_strt, dbo.user_prof.cd_inpt_type,
> > > > > dbo.user_prof.flag_rslt_onli,
> > > > > dbo.user_prof.flag_rslt_ftp, dbo.user_prof.id_ftp_lgn,
> > > > > dbo.user_prof.text_ftp_pswrd,
> > > > > dbo.user_prof.text_ftp_ip_addr,
> dbo.user_prof.text_trgt_drctry,
> > > > > dbo.user_prof.Password FROM
> > > > > dbo.user_prof WHERE (dbo.user_prof.id_user = 'widmxpHVE')|
> > > > >
> > > > > However, I notice that the SQL generated second time is
> > > > including all the
> > > > > data
> > > > > fields and the join
> > > > > criteria is missing in this, which was present in the
> first SQL.
> > > > >
> > > > > Do we have to include the join condition also in the
> > > > dynamic criteria?
> > > > >
> > > > > Seshu
> > > > >
> > > > > Shamdasani Nimmi-ANS004 wrote:
> > > > >
> > > > > > Seshu,
> > > > > >
> > > > > > If the uid or pword are character fields your need to put
> > > > single quotes(')
> > > > > > around them in your SQL.
> > > > > >
> > > > > > -Nimmi
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: Seshu [mailto:[EMAIL PROTECTED]]
> > > > > > Sent: Thursday, January 27, 2000 3:24 PM
> > > > > > To:
> [EMAIL PROTECTED]
> > > > > > Subject: [ND] data object with dynamic criteria
> > > > > >
> > > > > > Hi All,
> > > > > > I am getting errors with the execution of data object. I
> > > > am adding a
> > > > > > dynamic criteria to the dataobject in the
> onBeforeExecuteEvent of
> > > > > > datobject. I have turned the all three options turned on
> > > > in command
> > > > > > center for the dubug. the error log is enclosed in the
> > > > attatchment.
> > > > > > Following is piece of code.
> > > > > >
> > > > > > //[[SPIDER_EVENT<this_onBeforeExecuteEvent>
> > > > > > public int
> this_onBeforeExecuteEvent(CSpDataObjectEvent event)
> > > > > > {
> > > > > > CSpString uid =
> > > > (CSpString)CSpider.getUserSessionObject("sesuserid");
> > > > > > CSpString pword =
> > > > > > (CSpString)CSpider.getUserSessionObject("sespassword");
> > > > > > String mySQL = new
> String("dbo.user_prof.id_user = "+uid+
> > > > > > " AND dbo.user_prof.Password ="+pword);
> > > > > > CSpSelect doVer =
> (CSpSelect)CSpider.getDataObject("doVerify");
> > > > > > doVer.clearDynamicCriteria();
> > > > > > doVer.addDynamicStrCriterion(mySQL);
> > > > > > return (PROCEED);
> > > > > > }
> > > > > > //]]SPIDER_EVENT<this_onBeforeExecuteEvent>
> > > > > >
> > > > > > Can anyone help?
> > > > > > Thanks in advance.
> > > > > > We are using sybase database with odbc driver , ND
> > > > 4.1.3.8 on NT and IIS
> > > > > > server.
> > > > > >
> > > > > > Seshu
> > > >
> > > > ______________________________________________________________
> > > > ___________
> > > >
> > > > For help in using, subscribing, and unsubscribing to
> the discussion
> > > > forums, please go to:
> > > > http://www.netdynamics.com/support/visitdevfor.> html
> > > >
> > > > For dire
> > > > need help, email: [EMAIL PROTECTED]
> > > >
> > >
> ______________________________________________________________
> ___________
> > >
> > > For help in using, subscribing, and unsubscribing to the
> discussion
> > > forums, please go to:
> http://www.netdynamics.com/support/visitdevfor.> html
> > >
> > >
> For dire need help, email: [EMAIL PROTECTED]
> >
>
> >
> ______________________________________________________________
> ___________
> >
> > For help in using, subscribing, and unsubscribing to the discussion
> > forums, please go to:
> http://www.netdynamics.com/support/visitdevfor.> html
> >
> > For
> dire need help, email: [EMAIL PROTECTED]
>
>
> ______________________________________________________________
> ___________
>
> For help in using, subscribing, and unsubscribing to the discussion
> forums, please go to:
> http://www.netdynamics.com/support/visitdevfor.> html
>
> For dire
> need help, email: [EMAIL PROTECTED]
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
