-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Have a look at
http://db.apache.org/torque/releases/torque-3.3/runtime/reference/read-from-db.html
Section "AND and OR operators"
Patrick
Oliver Bethge schrieb:
| Hello,
|
| I try to combine some Criteria with other operators than AND but it
seems not possible to me.
|
| Here an example of the SQL I nerly want but it shows the main problems:
|
| SELECT * FROM TABLE1 A, TABLE2 B WHERE A.KEY=B.KEY AND ((B.ORT='ORT1'
AND B.PLZ IN (12345,12346)) OR (B.ORT='ORT2' AND B.PLZ IN (12347,12348))
AND NOT (B.OTHER='7' AND B.OTHER2=8)
|
| Combinig Criteria with "AND NOT" looks impossible to me because of
line 358ff in org.apache.torque.util.Query:
|
| if (!whereCriteria.isEmpty())
| {
| stmt.append(WHERE)
| .append(StringUtils.join(whereCriteria.iterator(), AND));
| }
|
| So all Criteria will be connected by " AND ".
|
| I tryed to use Criteria.CUSTOM but its also not possible to Connect
them with " AND NOT ".
|
| Sometimes it schould be possible to get an SQL like
|
| SELECT * FROM TABLE1 A, TABLE2 B WHERE A.KEY=B.KEY AND NOT
(B.OTHER='7' AND B.OTHER2=8)
|
| so it is not enougth to get some braces oround the whole WHERE-Clause.
|
| Thanks,
|
| Oliver Bethge
|
| ---------------------------------------------------------------------
| To unsubscribe, e-mail: [EMAIL PROTECTED]
| For additional commands, e-mail: [EMAIL PROTECTED]
|
- --
Patrick Carl
mailto:[EMAIL PROTECTED] http://carl.it
GnuPG-Fingerprint: 3599 02CF 0419 BCA6 6BAC 4B53 DB7C 1897 451C F498
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
iD8DBQFIFe1r23wYl0Uc9JgRAnmyAJ46izaiyVwfwCnlq4XJR3Pl0lp3ngCfXH9k
2rmB6Gtj3evFloLaJYkqLl8=
=A77S
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
