Thanks! That did it. I was trying to add it to the query instead of the
value
----- Original Message -----
From: "Mickael Guessant" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 12:35 PM
Subject: Re: [castor-dev] help performing a like query
> > Gray Jones a �crit :
> >
> > couldn't create oql query: SELECT a from com.xtriahc.user.User a
> > WHERE a.firstName like %$1
> > An invalid character was found in the query at position 61
>
> Just add the percent sign to your value (not your query) :
> oqlQuery = db.getOQLQuery("SELECT a from com.xtriahc.user.User a WHERE
> a.firstName like $1");
> oqlQuery.bind("%test");
>
>
> --
> Mickael Guessant
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
