1 package de.webman.generator.db.queries.sybase; 2 3 import com.teamkonzept.db.*; 4 import java.sql.*; 5 6 7 8 16 public class GenContNodeConts_Part_2 extends TKPrepQuery { 17 18 public static boolean isPrepared = 19 true; 20 21 public static String [] paramOrder = 22 null; 23 24 public static Object [][] paramTypes = 25 null; 26 27 public static boolean[] setRelevants = 28 { true }; 29 30 public static String sqlString = 31 32 33 "SELECT DISTINCT " + 34 " CONTENT_NODE_ID " + 35 "INTO " + 36 " #temp " + 37 "FROM " + 38 " DOCUMENT_CONTENT " + 39 "WHERE " + 40 " CONTENT_NODE_ID " + DBStringFactory.notEqualsNull() + 41 "UNION " + 42 "SELECT DISTINCT " + 43 " PG_CONTENT_NODE " + 44 "FROM " + 45 " SITE_TREE " + 46 "WHERE " + 47 " PG_CONTENT_NODE " + DBStringFactory.notEqualsNull() + 48 49 61 "SELECT CV.*, CI.NAME, CT.CONTENT_NODE_ID, CT.CONTENT_NODE_TYPE, CT.CONTENT_NODE_NAME, CT.CONTENT_FORM, " + 62 " CT.CONTENT_NODE_SHORTNAME, CT2.CONTENT_NODE_TYPE AS PARENT_TYPE, CT.CONTENT_NODE_PARENT, T.CONTENT_NODE_ID AS REF_NODE_ID " + 63 " FROM CONTENT_TREE CT, CONTENT_TREE CT2, CONTENT_INSTANCE CI, #temp T, CONTENT_VERSION CV " + 64 "WHERE " + 65 66 " ( CT.CONTENT_NODE_PARENT = T.CONTENT_NODE_ID OR " + 67 " CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID " + 68 " ) AND " + 69 70 " CT.CONTENT_NODE_ID = CI.CONTENT_NODE_ID AND " + 71 " CI.INSTANCE_ID = CV.INSTANCE_ID AND" + 72 " CT2.CONTENT_NODE_ID = CT.CONTENT_NODE_PARENT " + 73 74 "ORDER BY T.CONTENT_NODE_ID, CV.INSTANCE_ID, CV.CONTENT_ID, CV.VERSION_ID " + 75 76 "DROP TABLE #temp "; 77 78 79 public void initQuery(Connection con) { 80 super.initQuery( 81 con, 82 isPrepared, 83 paramOrder, 84 paramTypes, 85 setRelevants, 86 sqlString ); 87 } 88 } 89 | Popular Tags |