1 package com.teamkonzept.webman.mainint.db.queries; 2 3 import java.sql.*; 4 5 import com.teamkonzept.db.*; 6 7 12 public class TKDBFormGetAll67 extends TKPrepQuery{ 13 14 15 public static final boolean ISPREPARED = true; 16 public static final String [] PARAMORDER = null; 17 public static final Object [][] PARAMTYPES = null; 18 public static final boolean[] SETRELEVANTS = { true }; 19 20 public static final String SQLSTRING = 21 "SELECT FO.FORM_ID, FI.FIELD_SHOW_NAME AS FORM_NAME " + 22 "FROM FORM FO, FIELD FI " + 23 "WHERE FO.FORM_ID = FI.FORM_ID" + 24 " AND FI.FIELD_ID = 0 " + 25 " AND FO.FORM_TYPE = " + TKQuery.DBFRAGMENT_IDENT + 26 " ORDER BY " + DBStringFactory.upper_order() + " (FI.FIELD_SHOW_NAME) "; 27 28 29 public void initQuery(Connection con) { 30 super.initQuery( 31 con, 32 ISPREPARED, 33 PARAMORDER, 34 PARAMTYPES, 35 SETRELEVANTS, 36 SQLSTRING ); 37 } 38 } 39 40 41 | Popular Tags |