1 package com.teamkonzept.webman.mainint.db.queries.content; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 6 public class InsertTempTable4InstanceId extends TKPrepQuery 7 { 8 9 public final static boolean prepared = true; 10 11 public final static String [] order = 12 { 13 "LEFT_ID", "RIGHT_ID" 14 }; 15 16 public final static Object [][] types = null; 17 18 public final static boolean[] relevants = { true }; 19 20 public final static String sqlString = "INSERT INTO WEBMAN_TEMP_4 (INSTANCE_ID) SELECT CI.INSTANCE_ID FROM CONTENT_TREE CT, CONTENT_INSTANCE CI WHERE CT.CONTENT_NODE_ID = CI.CONTENT_NODE_ID AND CT.LEFT_NR >= ? AND CT.RIGHT_NR <= ?"; 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 |