It's really strange I can't get either to work. I have test data with all fields as 'Test'. When I search for 'Test' I get results, but when I search for 'Te' I get nothing. I've tried using both ways described below.
Cheers Ed -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fábio Batista Sent: 25 October 2006 19:01 To: castleproject-users@lists.sourceforge.net Subject: Re: [Castle-users] Castle and HQL Like On 10/25/06, josh robb <[EMAIL PROTECTED]> wrote: > I normally just append the %'s to the variable. > > e.g. > > sFirstName = '%' + sFirstName + '%'; > SimpleQuery q = new SimpleQuery(typeof(nCustomer), "from nCustomer c > where c.FirstNames like ? order by c.Surname", sFirstName); That's the correct approach. But, for simple cases as that, you might want to use: return (nCustomer[]) FindAll( typeof(nCustomer), Expression.Like("FirstNames", sFirstName, MatchMode.Anywhere) ); -- Fábio David Batista [EMAIL PROTECTED] http://nerd-o-matic.blogspot.com ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ CastleProject-users mailing list CastleProject-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/castleproject-users ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ CastleProject-users mailing list CastleProject-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/castleproject-users
