Our application sets a limit:
....
criteria.setLimit (25);
List results = CcsReservationPeer.doSelect(criteria);
logger.debug("Searching up to " + criteria.getLimit() +
" reservations: " + criteria.toString());
The debug shows the limit:
1827924 [tcpConnection-8080-3] DEBUG sql.SQLReservationManager -
Searching up to 25 reservations:
Criteria::
XXX_RESERVATION.STOP<=>(XXX_RESERVATION.STOP>='20060711023000' AND
XXX_RESERVATION.STOP<='20060711043000'):
XXX_RESERVATION.CLASS_ID<=>XXX_RESERVATION.CLASS_ID IN
(4,2,6,12,11,5,9,10,8,1,7,3):
Current Query SQL (may not be complete or applicable):
SELECT FROM XXX_RESERVATION WHERE
(XXX_RESERVATION.STOP>='20060711023000' AND
XXX_RESERVATION.STOP<='20060711043000') AND XXX_RESERVATION.CLASS_ID IN
(4,2,6,12,11,5,9,10,8,1,7,3) ORDER BY XXX_RESERVATION.START DESC LIMIT 25
But it does NOT show up in the mysql query log:
060711 2:35:45 1 Query SELECT 1
1 Query SET autocommit=1
1 Query SELECT
XXX_RESERVATION.RESERVATION_ID, XXX_RESERVATION.MEMBER_ID,
XXX_RESERVATION.ASSIGNMENT_ID, XXX_RESERVATION.SURVEY FROM
XXX_RESERVATION WHERE (XXX_RESERVATION.STOP>='20060711023000' AND
XXX_RESERVATION.STOP<='20060711043000') AND XXX_RESERVATION.CLASS_ID IN
(4,2,6,12,11,5,9,10,8,1,7,3) ORDER BY XXX_RESERVATION.START DESC
And, of course, it does not work. This is an older Torque, with a
modern mysql 4.1. Any ideas what I may be doing wrong?
--
----
Visit http://www.obviously.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
