01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: public class SelectGroupContentChilds extends TKPrepQuery {
07:
08: public final static boolean PREPARED = true;
09:
10: public final static String[] ORDER = { "CONTENT_NODE_ID" };
11:
12: public final static Object[][] TYPES = null;
13:
14: public final static boolean[] RELEVANTS = { true };
15:
16: public final static String SQL_STRING = "SELECT CT.CONTENT_NODE_ID, CT.CONTENT_NODE_NAME, CT.CONTENT_NODE_SHORTNAME, "
17: + "CI.INSTANCE_ID "
18: + "FROM CONTENT_TREE CT, CONTENT_INSTANCE CI WHERE CT.CONTENT_NODE_PARENT = ? AND "
19: + "CI.CONTENT_NODE_ID = CT.CONTENT_NODE_ID";
20:
21: public void initQuery(Connection con) {
22: super.initQuery(con, PREPARED, ORDER, TYPES, RELEVANTS,
23: SQL_STRING);
24: }
25:
26: }
|