01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: public class UpdateTempTableContentNodeIdNodeId2 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 = "UPDATE WEBMAN_TEMP_2 SET NODE_ID = NULL WHERE CONTENT_NODE_ID IN (SELECT T.CONTENT_NODE_ID FROM WEBMAN_TEMP_2 T, CONTENT_TREE CT WHERE CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID AND CT.CONTENT_NODE_TYPE > 2)";
17:
18: public void initQuery(Connection con) {
19: super.initQuery(con, prepared, order, types, relevants,
20: sqlString);
21: }
22:
23: }
|