Hi,
> But why does the upper(companyName) ? if i give it then only
> it is working.
> Otherwise it is giving error saying that "error in finder method".
> Since that is a columnname it should work with out the upper operator
> applied to it also. Or am i missing any thing here?
I don't think so - I need the upper to allow me to do a case insensitive
search (obviously not using an index) - but it should be valid syntax
without it - are you sure you have the correct field names in your query?
> >
> > > > <enterprise-beans>
> > > >
> > > > <entity>
> > > > <ejb-name>CompanyBean</ejb-name>
> > > > <finder>
> > > > <name>findWithCompanyNameLike</name>
> > > > <query>upper(companyName) like
> '%'||upper({0})||'%'</query>
> > > > <order>companyName</order>
> > > > </finder>
> > > > </entity>
> > > >
> >
> > You have 3 parameters, so refer to them as {0}, {1} and
> {2}, as I have
> above
> > for my 1 parameter...
> >
> > For more info see..
> >
> > http://www.jboss.org/documentation/jawsxml_howto.html#finders
> >
Chris
================================================================================================
This electronic message (email) and any attachments to it are subject to copyright and
are sent for the personal attention of the addressee. Although you may be the named
recipient, it may become apparent that this email and its contents are not intended
for you and an addressing error has been made. This email may include information that
is legally privileged and exempt from disclosure. If you have received this email in
error, please advise us immediately and delete this email and any attachments from
your computer system.Rabobank International is the trading name of Coöperatieve
Centrale Raiffeisen-Boerenleenbank B.A. which is incorporated in the Netherlands.
Registered with the Registrar of Companies for England & Wales No. BR002630 and
regulated by the SFA for the conduct of investment business in the UK.
The presence of this footnote also confirms that this email has been automatically
checked by Rabobank International for the presence of computer viruses prior to it
being sent, however, no guarantee is given or implied that this email is virus free
upon delivery.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
