1 package com.teamkonzept.webman.mainint.db.queries.content; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 6 public class InsertTempTableContentNodeIdNodeId extends TKPrepQuery 7 { 8 9 public final static boolean prepared = true; 10 11 public final static String [] order = null; 12 13 public final static Object [][] types = null; 14 15 public final static boolean[] relevants = { true }; 16 17 public final static String sqlString = (new StringBuffer ("INSERT INTO WEBMAN_TEMP_2 SELECT CONTENT_NODE_ID, CONTENT_NODE_ID FROM CONTENT_TREE ") 18 .append(" WHERE CONTENT_NODE_PARENT IN ( SELECT CONTENT_NODE_ID FROM WEBMAN_TEMP ) ") 19 .append(" OR ") 20 .append(" CONTENT_NODE_ID IN ( SELECT CONTENT_NODE_ID FROM WEBMAN_TEMP ) ")).toString(); 21 22 public void initQuery(Connection con) { 23 super.initQuery( 24 con, 25 prepared, 26 order, 27 types, 28 relevants, 29 sqlString ); 30 } 31 32 } | Popular Tags |