01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: public class InsertTempTableContentNodeIdNodeId extends TKPrepQuery {
07:
08: public final static boolean prepared = true;
09:
10: public final static String[] order = null;
11:
12: public final static Object[][] types = null;
13:
14: public final static boolean[] relevants = { true };
15:
16: public final static String sqlString = (new StringBuffer(
17: "INSERT INTO WEBMAN_TEMP_2 SELECT CONTENT_NODE_ID, CONTENT_NODE_ID FROM CONTENT_TREE ")
18: .append(
19: " WHERE CONTENT_NODE_PARENT IN ( SELECT CONTENT_NODE_ID FROM WEBMAN_TEMP ) ")
20: .append(" OR ")
21: .append(" CONTENT_NODE_ID IN ( SELECT CONTENT_NODE_ID FROM WEBMAN_TEMP ) "))
22: .toString();
23:
24: public void initQuery(Connection con) {
25: super.initQuery(con, prepared, order, types, relevants,
26: sqlString);
27: }
28:
29: }
|