1 package com.teamkonzept.webman.mainint.db.queries.version; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 6 public class InsertTempTableContentVersion extends TKPrepQuery 7 { 8 9 public final static boolean PREPARED = true; 10 public final static String [] ORDER = {"CONTENT_ID","INSTANCE_ID"}; 11 public final static Object [][] TYPES = null; 12 public final static boolean[] RELEVANTS = { true }; 13 public final static String SQLSTRING = "INSERT INTO WEBMAN_TEMP_CONTENT_VERSION (CONTENT_ID) SELECT CONTENT_ID FROM CONTENT_VERSION WHERE CONTENT_ID < ? AND INSTANCE_ID = ?"; 14 15 public void initQuery(Connection con) { 16 super.initQuery( 17 con, 18 PREPARED, 19 ORDER, 20 TYPES, 21 RELEVANTS, 22 SQLSTRING ); 23 } 24 25 } 26 | Popular Tags |