Seshu,
I stand corrected. I didn't notice before that you were NOT setting the join
criteria in your code which means that you had specified the join clause in
the dataobject. If that is true then you don't need to set the join clause
again in your code.
-Nimmi
-----Original Message-----
From: Seshu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 27, 2000 4: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]
