Hi! there
SELECT * FROM peopleWHERE name LIKE '%name%' I think!!
fresnaULL wrote:
> Hi all,
>
> I'm trying to define this finder method in a cmp:
>
> SELECT * FROM people
> WHERE people.name LIKE '%name%'
>
> which is correct in SQL SERVER 7.0
>
> I put the following in the people home interface:
>
> String findByName_query = "people.name like '%$1%'";
--
*********************************************************************************************************************
The information contained in this message (including any attachments) is
confidential and may be legally privileged.
If you are not the intended recipient, please delete it from your system
immediately - any disclosure, copying or distribution thereof or any
action taken or omitted to be taken in reliance thereon is prohibited
and may be unlawful.AITPL makes no warranty as to the accuracy or
completeness of any information contained in this message and hereby
excludes any liability of any kind for the information contained herein
or for the transmission, reception, storage or use of such information
in any way whatsoever. Any opinions expressed in this message are those
of the author and do not necessarily reflect the opinions of AITPL.
*********************************************************************************************************************
