home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / get_default_query.sql < prev    next >
Encoding:
Text File  |  2004-09-23  |  223 b   |  14 lines
  1. # get the stored query based on the person_id and usage
  2. SELECT
  3.   query_id,
  4.   query_name,
  5.   show_columns,
  6.   show_numbers,
  7.   sort_column,
  8.   sort_order,
  9.   query_usage
  10. FROM $PROJECT_query
  11. WHERE person_id=?
  12.   AND query_usage=1
  13.  
  14.