1 package com.teamkonzept.field.db.queries; 2 3 import java.sql.*; 4 import com.teamkonzept.db.*; 5 6 11 public class TKDBGetAllFormIds extends TKPrepQuery{ 12 13 14 public final static boolean ISPREPARED = 15 true; 16 17 18 public final static String [] PARAMORDER = 19 null; 20 21 22 public final static Object [][] PARAMTYPES = 23 null; 24 25 26 public final static boolean[] SETRELEVANTS = 27 { true }; 28 29 30 public final static String SQLSTRING = 31 "SELECT " + 32 " FO.FORM_ID, FI.FIELD_SHOW_NAME " + 33 "FROM " + 34 " FORM FO, FIELD FI "+ 35 "WHERE " + 36 " FO.FORM_ID = FI.FORM_ID "+ 37 "AND " + 38 " FI.FIELD_ID = 0 "+ 39 "AND " + 40 " FO.FORM_TYPE = 67 ORDER BY " + DBStringFactory.upper_order() + " (FI.FIELD_SHOW_NAME)"; 41 42 43 public void initQuery(Connection con) { 44 super.initQuery( 45 con, 46 ISPREPARED, 47 PARAMORDER, 48 PARAMTYPES, 49 SETRELEVANTS, 50 SQLSTRING ); 51 } 52 } 53 54 | Popular Tags |