1 package com.teamkonzept.webman.mainint.db.queries.sitetree; 2 3 import java.sql.*; 4 5 import com.teamkonzept.db.*; 6 7 8 15 16 17 public class CsDelOnStSub extends TKPrepQuery { 18 19 public final static boolean isPrepared = 20 true; 21 22 public final static String [] paramOrder = 23 { 24 SITE_NODE_ID, SITE_NODE_ID 25 }; 26 27 public final static Object [][] paramTypes = 28 null; 29 30 public final static boolean[] setRelevants = 31 null; 32 33 public final static String sqlString = 34 35 36 37 " DELETE FROM CONTENT_SELECTION " 38 + " WHERE SELECTION_ID IN " 39 + " ( " 40 + " SELECT PG_SELECTION_ID " 41 + " FROM SITE_TREE " 42 + " WHERE " 43 + " LEFT_NR >= (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " 44 + " AND " 45 + " RIGHT_NR <= (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) " 46 + " ) " ; 47 48 public void initQuery(Connection con) { 49 super.initQuery( 50 con, 51 isPrepared, 52 paramOrder, 53 paramTypes, 54 setRelevants, 55 sqlString ); 56 } 57 58 } 59 60 61 62 | Popular Tags |