You'll want to use $1 in the finder method, and specify "%"+name+"%" in
the finder call. Hmm, that didn't sound right... let's try again.
String findByName_query = "people.name like '$1'";
..
List myList=person.findByName("%"+name+"%");
It could be that EQL will address this; I don't know.
On Thu, 8 Feb 2001, 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%'";
> .
> .
> .
> public java.util.Enumeration findByName(String value) throws
> java.rmi.RemoteException, javax.ejb.FinderException;
>
> but it doesn't work. Orion is able to deploy the cmp but when I try to use
> it I only get this
> error message:
>
> 500 Internal Server Error
> java.lang.NullPointerException
> at sun.jdbc.odbc.JdbcOdbcPreparedStatement.clearParameter(Unknown Source)
> at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setChar(Unknown Source)
> at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setString(Unknown Source)
> at com.evermind.sql.am.setString(JAX)
> at com.evermind.sql.am.setString(JAX)
> at
> PeopleHome_EntityHomeWrapper72.findByName(PeopleHome_EntityHomeWrapper72.jav
> a:1142)
> at Search.doGet(Search.java:46)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> at com.evermind.server.http.d1.si(JAX)
> at com.evermind.server.http.d1.forward(JAX)
> at com.evermind.server.http.ed.sp(JAX)
> at com.evermind.server.http.ed.so(JAX)
> at com.evermind.util.f.run(JAX)
>
>
> Does anybody know how i can make it work?
>
> Thanks in advance
>
>
>
>
>
-----------------------------------------------------------
Joseph B. Ottinger [EMAIL PROTECTED]
http://epesh.com/ IT Consultant