----- Original Message -----
From: "Peter Donald" <[EMAIL PROTECTED]>
> >The reason is that on line 173 the WHERE clause is set by:
> > MRUser.setWhere("UserName = *");
> >
> >for Oracle (and I would have thought for other SQL92 implementations)
this
> >requires to be
> > MRUser.setWhere("UserName like '%'"); // i.e. UserName LIKE '%'
>
> Worse some DBs require " instead of '. Others have other "issues" - you
> should consider having a look at turbine as it solved this a while back.
> Last time I used turbine it worked for all DBS I wanted but YMMV ;)
I'm not sure of the point of the WHERE clause in the first place. I don't
understand why you couldn't just remove the offending line 173, as it seems
everything would work fine.
Serge Knystautas
Loki Technologies
http://www.lokitech.com/
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives: <http://www.mail-archive.com/james%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
