1 package com.teamkonzept.webman.mainint.db.queries; 2 3 import java.sql.*; 4 5 import com.teamkonzept.db.*; 6 7 16 17 public class TKDBStructContGetFreeForm extends TKPrepQuery{ 18 19 20 public final static boolean ISPREPARED = 21 true; 22 23 public final static String [] PARAMORDER = 24 {"SITE_NODE_ID"}; 25 26 public final static Object [][] PARAMTYPES = 27 null; 28 29 public final static boolean[] SETRELEVANTS = 30 { true }; 31 32 public final static String SQLSTRING = 33 "SELECT " + 34 " FI.FORM_ID, FI.FIELD_SHOW_NAME AS FORM_DESCRIPTION " + 35 "FROM " + 36 " FORM FO, FIELD FI " + 37 "WHERE " + 38 " FO.FORM_ID = FI.FORM_ID " + 39 "AND " + 40 " FI.FIELD_ID = 0 " + 41 "AND " + 42 " FO.FORM_TYPE = " + TKQuery.DBSTRUC_IDENT + " " + 43 "AND " + 44 " FO.FORM_ID NOT IN ( " + 45 "SELECT " + 46 " FORM_ID " + 47 "FROM " + 48 " STRUCTURED_CONTENT " + 49 "WHERE " + 50 " SITE_NODE_ID = ? " + 51 ") " + 52 " ORDER BY " + DBStringFactory.upper_order() + "(FI.FIELD_SHOW_NAME)"; 53 54 55 public void initQuery(Connection con) { 56 super.initQuery( 57 con, 58 ISPREPARED, 59 PARAMORDER, 60 PARAMTYPES, 61 SETRELEVANTS, 62 SQLSTRING ); 63 } 64 } 65 66 | Popular Tags |