home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / test_assigned.sql < prev    next >
Encoding:
Text File  |  2004-08-01  |  282 b   |  10 lines
  1. # test currently assigned 
  2. SELECT
  3.   count(*)
  4. FROM $PROJECT_trail trail   
  5. WHERE trail.entry_id=?
  6.   AND trail.responsible=?
  7.   AND trail.trail_id=(SELECT MAX(trail0.trail_id)
  8.                       FROM $PROJECT_trail trail0
  9.                       WHERE trail0.entry_id=trail.entry_id)
  10.