Re: Torque using Tomcat

2004-12-22 Thread M. Sean Gilligan
Hi Henning, Thanks again for your help. (I got sidetracked for a few days.) >"M. Sean Gilligan" <[EMAIL PROTECTED]> writes: > >>>"M. Sean Gilligan" <[EMAIL PROTECTED]> writes: >>> I'm using Torque 3.1.1 with Tomcat 5.0.28 and MySQL. In a Tomcat context.xml file I've defined a JNDI Data

Re: is this really the way to combine several orÂs ?

2004-12-22 Thread T E Schmitz
Hello Alex, Alex Hepp wrote: thanks all, but that can become a quite difficult thing, when i want to produce an efficient and correct statement... is the following example statement possible with torque then? : Yes, both examples are possible to configure with Torque. Just as you did it using Cr

Re: is this really the way to combine several orÂs ?

2004-12-22 Thread Alex Hepp
thanks all, but that can become a quite difficult thing, when i want to produce an efficient and correct statement... is the following example statement possible with torque then? : SELECT * FROM my_users where (LAST_NAME="Hepp" AND FIRST_NAME="Alex") or LOGIN_NAME="heppa"; or this: SELECT * FR

Re: is this really the way to combine several orÂs ?

2004-12-22 Thread T E Schmitz
Hallo Alex, Alex Hepp wrote: what i want now is this: SELECT * FROM movii_user where (FIRST_NAME LIKE "%hello%" or LAST_NAME LIKE "%hello%" OR EMAIL LIKE "%hello%" or LOGIN_NAME="%hello%") AND IS_DELETED=0; **CODE Criteria crit = new Criteria();

Re: is this really the way to combine several or ´s ?

2004-12-22 Thread Thomas Fischer
Hi, Alex Hepp <[EMAIL PROTECTED]> schrieb am 22.12.2004 16:42:30: > Hi List! > > I tried several hours now, to get a simple or to work... I must say, that i > really would appreciate a bit of documentation on that. > contributions to the docs are always welcome ;-) . But yes, documentation i

is this really the way to combine several orÂs ?

2004-12-22 Thread Alex Hepp
Hi List! I tried several hours now, to get a simple or to work... I must say, that i really would appreciate a bit of documentation on that. what i want now is this: SELECT * FROM movii_user where (FIRST_NAME LIKE "%hello%" or LAST_NAME LIKE "%hello%" OR EMAIL LIKE "%hello%" or LOGIN_NAME="%hell

Re: Prepared Statement with bind variables

2004-12-22 Thread Howard Lin
This has been discussed long time ago. You can search the archive. Basically use BasePeer.doPSSelect instead of BasePeer.doSelect in all generated Base*Peer.java files. Howard On Tue, 21 Dec 2004 17:52:17 +0100, Mattia Tortorelli <[EMAIL PROTECTED]> wrote: > Hi, > > I would like to know if it's