01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: public class UpdateTempTableContentNodeIdNodeId 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: "UPDATE WEBMAN_TEMP_2 SET NODE_ID = ")
18: .append(
19: " (SELECT CT.CONTENT_NODE_PARENT FROM CONTENT_TREE CT, WEBMAN_TEMP T ")
20: .append(
21: " WHERE CT.CONTENT_NODE_ID = WEBMAN_TEMP_2.CONTENT_NODE_ID ")
22: .append(" AND CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID)")
23: .append(" WHERE CONTENT_NODE_ID IN (SELECT CONTENT_NODE_ID FROM WEBMAN_TEMP)"))
24: .toString();
25:
26: public void initQuery(Connection con) {
27: super.initQuery(con, PREPARED, ORDER, TYPES, RELEVANTS,
28: SQLSTRING);
29: }
30:
31: }
|