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
[email protected]
https://lists.sourceforge.net/lists/listinfo/castleproject-users
