01: package com.teamkonzept.webman.mainint.db.queries;
02:
03: import java.sql.*;
04:
05: import com.teamkonzept.db.*;
06:
07: /**
08: *
09: * @author
10: * @version
11: */
12: public class TKDBFormGetAll69 extends TKPrepQuery {
13:
14: /** prepariert ? */
15: public static final boolean IS_PREPARED = true;
16: public static final String[] PARAM_ORDER = null;
17: public static final Object[][] PARAM_TYPES = null;
18: public static final boolean[] SET_RELEVANTS = { true };
19:
20: /** die Query */
21: public static final String SQL_STRING = "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 AND FO.FORM_TYPE = "
25: + TKQuery.DBFORM_IDENT
26: + " ORDER BY "
27: + DBStringFactory.upper_order() + " (FI.FIELD_SHOW_NAME) ";
28:
29: /** init query */
30: public void initQuery(Connection con) {
31: super.initQuery(con, IS_PREPARED, PARAM_ORDER, PARAM_TYPES,
32: SET_RELEVANTS, SQL_STRING);
33: }
34: }
|