home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / get_file_trail.sql < prev    next >
Encoding:
Text File  |  2004-01-29  |  198 b   |  7 lines
  1. # get all trail ids where there are file attachments based on entry_id
  2. SELECT 
  3.   f.trail_id
  4. FROM $PROJECT_file f, $PROJECT_trail trail 
  5. WHERE trail.entry_id IN ($ID)
  6.   AND f.trail_id=trail.trail_id
  7.