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]
