Geert,
I am aware of the classes and methods; what I can't seem to figure out
is a syntax for doing a "where foo like %baz%" type query;
say i have an instance of Select or RestoreQuery as follows:
GenericQueryManager<Relation> manager =
GenericQueryManagerFactory.getInstance(getDatasource(), Relation.class);
RestoreQuery query = manager.getRestoreQuery();
I know I can add constraints to the query, like
query.whereAnd("foo", "=", "baz"); // This I understand
Now if you look at the following:
query.whereAnd("foo", "like", "%baz%")
I don't think it works, but I am sure you understand what I am trying
to do; is there some syntax that achieves it?
Thanks,
Emmanuel
On 11/22/05, Geert Bevin <[EMAIL PROTECTED]> wrote:
> Hi Emmanuel,
>
> you probably accidently looked over it:
> http://rifers.org/docs/api/com/uwyn/rife/database/queries/Select.html
> http://rifers.org/docs/api/com/uwyn/rife/database/
> DbQueryManager.html#executeFetchAll
> (com.uwyn.rife.database.queries.ReadQuery,%
> 20com.uwyn.rife.database.DbRowProcessor)
> (and a bunch of other methods)
> http://rifers.org/docs/api/com/uwyn/rife/database/querymanagers/
> generic/GenericQueryManager.html#restore()
>
> Best regards,
>
> Geert
>
> On 22-nov-05, at 17:56, Emmanuel Okyere wrote:
>
> > Geert,
> >
> > I can't seem to trace a way to do a "Select like" query? any pointers?
> >
> > Thanks,
> > Emmanuel
> > _______________________________________________
> > Rife-users mailing list
> > [email protected]
> > http://www.uwyn.com/mailman/listinfo/rife-users
> >
>
> --
> Geert Bevin Uwyn bvba
> "Use what you need" Avenue de Scailmont 34
> http://www.uwyn.com 7170 Manage, Belgium
> gbevin[remove] at uwyn dot com Tel +32 64 84 80 03
>
> PGP Fingerprint : 4E21 6399 CD9E A384 6619 719A C8F4 D40D 309F D6A9
> Public PGP key : available at servers pgp.mit.edu, wwwkeys.pgp.net
>
>
> _______________________________________________
> Rife-users mailing list
> [email protected]
> http://www.uwyn.com/mailman/listinfo/rife-users
>
_______________________________________________
Rife-users mailing list
[email protected]
http://www.uwyn.com/mailman/listinfo/rife-users
