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]
