Hi, I have the problem that the doSelect(Criteria) method of my Peer classes does behave different when using different databases.
For example: suppose I have a simple table (TEST) where the primary key column (ID) is of type INTEGER. If I create this Criteria: Criteria crit = new Criteria(); crit.add(TestPeer.ID, "123"); TestPeer.doSelect(crit); everything works fine. But if I execute this query: Criteria crit = new Criteria(); crit.add(TestPeer.ID, "abc"); TestPeer.doSelect(crit); it goes wrong: - MySQL is returning an empty list on this query - Oracle is throwing a TorqueException (saying something like: given value is not a valid number) I don't know which behaviour is preferrable, as long as they both either return an empty list or throw an Exception, it's fine for me. Does anyone know how I can accomplish this? I'm using Torque b2. thanks, Maarten -- Maarten Coene Katholieke Universiteit Leuven Dept. Computerwetenschappen Tel: ++32 (0)16/32 78 25 Celestijnenlaan 200A B-3001 Heverlee -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
