This definatly works. Have you looked at the SQL that is being generated? (Use Sql profilter - or log4net NHibernate.SQL).
j. On 10/26/06, Ed Wake <[EMAIL PROTECTED]> wrote: > 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 > ------------------------------------------------------------------------- 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
