1 package com.teamkonzept.webman.mainint.db.queries.content; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 import org.apache.log4j.Category; 6 7 12 public class SelectFromContentTreeContentInstanceTempTable extends TKPrepQuery 13 { 14 15 public final static boolean PREPARED = true; 16 public final static String [] ORDER = null; 17 public final static Object [][] TYPES = null; 18 public final static boolean[] RELEVANTS = { true }; 19 20 21 22 public final static String SQLSTRING = (new StringBuffer ("SELECT CT.CONTENT_NODE_ID, CI.INSTANCE_ID, CI.NAME, CT.CONTENT_NODE_NAME, ") 23 .append(" CT.CONTENT_NODE_SHORTNAME, CT.CONTENT_NODE_TYPE, CT.LEFT_NR, CT.RIGHT_NR, ") 24 .append(" CT.CONTENT_FORM, CT.CONTENT_NODE_PARENT, T.NODE_ID ") 25 .append(" FROM CONTENT_INSTANCE CI, CONTENT_TREE CT, WEBMAN_TEMP_2 T ") 26 .append(" WHERE ") 29 .append(" CI.CONTENT_NODE_ID (+) = CT.CONTENT_NODE_ID AND ") 30 .append(" CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID ") 31 .append(" ORDER BY CT.LEFT_NR ")).toString(); 32 33 public void initQuery(Connection con) { 34 super.initQuery( 35 con, 36 PREPARED, 37 ORDER, 38 TYPES, 39 RELEVANTS, 40 SQLSTRING ); 41 } 42 43 } 44 | Popular Tags |