Possibly. We used Oracle PL/SQL's dynamic SQL facility
to pass in dynamically defined parameters and return a
cursor. I am not familiar enough with TransactSQL (is
it still called that ?) to know if you can duplicate
the technique.
// Nicholas
--- "Potts, Douglas" <[EMAIL PROTECTED]> wrote:
> Hi,
> We're using SQL Server 7. Yes it can use Stored
> Procedures. Is that the
> solution then?
> Regards,
> Doug
>
> -----Original Message-----
> From: Nicholas Whitehead [mailto:[EMAIL PROTECTED]]
> Sent: 18 January 2001 14:46
> To: [EMAIL PROTECTED]
> Subject: Re: Complex Queries in Container Managed
> Persistence
>
>
> Douglas;
>
> I am not familiar with the Inprise CMP mechanism,
> but
> do you know if you canuse stored procedures ? ANd
> what
> database are you using ?
>
> //Nicholas
>
>
> --- "Potts, Douglas" <[EMAIL PROTECTED]> wrote:
> > Hi,
> > We're doing some entity beans using CMP. One of
> the
> > tables as about twenty
> > fields. The requirement is to be able to search on
> > any combination of those
> > fields. Does this mean we have to do a finder for
> > each of the possibilities
> > or s there another way of doing it.
> > We're using Inprise Application Server on Win NT4
> > with EJB 1.1
> > Regards and thanks,
> > Doug
> >
> >
>
============================================================================
> ==
> > The contents of this email are confidential to the
> > intended recipient at the email address to which
> it
> > has been addressed. It may not be disclosed to or
> > used by anyone other than this addressee, nor may
> it
> > be copied in any way. If received in error, please
> > contact DLA, a UK law firm, (http://www.dla.com/)
> on
> > +44 (0) 8700 111111 quoting the name of the sender
> > and the addressee and then delete it from your
> > system.
> >
> > Please note that neither DLA nor the sender
> accepts
> > any responsibility for viruses and it is your
> > responsibility to scan the email and attachments
> (if
> > any). No contracts may be concluded on behalf of
> > DLA by means of email communications.
> >
> > A list of the names of the partners of DLA (who
> are
> > either solicitors or registered foreign lawyers)
> and
> > their qualifications is available for inspection
> at
> > 3 Noble Street, London, EC2V 7EE, UK.
> >
> > Regulated by the Law Society of England and Wales;
> > authorised by the Society to conduct investment
> > business.
> >
> >
>
============================================================================
> ==
> >
> >
>
===========================================================================
> > To unsubscribe, send email to
> [EMAIL PROTECTED]
> > and include in the body
> > of the message "signoff EJB-INTEREST". For
> general
> > help, send email to
> > [EMAIL PROTECTED] and include in the body of
> the
> > message "help".
> >
>
>
> =====
> Nicholas Whitehead
> Home: (973) 377 9335
> Cell: (973) 615 9646
> [EMAIL PROTECTED]
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
>
>
===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED]
> and include in the body
> of the message "signoff EJB-INTEREST". For general
> help, send email to
> [EMAIL PROTECTED] and include in the body of the
> message "help".
>
>
>
==============================================================================
> The contents of this email are confidential to the
> intended recipient at the email address to which it
> has been addressed. It may not be disclosed to or
> used by anyone other than this addressee, nor may it
> be copied in any way. If received in error, please
> contact DLA, a UK law firm, (http://www.dla.com/) on
> +44 (0) 8700 111111 quoting the name of the sender
> and the addressee and then delete it from your
> system.
>
> Please note that neither DLA nor the sender accepts
> any responsibility for viruses and it is your
> responsibility to scan the email and attachments (if
> any). No contracts may be concluded on behalf of
> DLA by means of email communications.
>
> A list of the names of the partners of DLA (who are
> either solicitors or registered foreign lawyers) and
> their qualifications is available for inspection at
> 3 Noble Street, London, EC2V 7EE, UK.
>
> Regulated by the Law Society of England and Wales;
> authorised by the Society to conduct investment
> business.
>
>
==============================================================================
>
>
===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED]
> and include in the body
> of the message "signoff EJB-INTEREST". For general
> help, send email to
> [EMAIL PROTECTED] and include in the body of the
> message "help".
>
=====
Nicholas Whitehead
Home: (973) 377 9335
Cell: (973) 615 9646
[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
