01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: /**
07: * @author
08: * @version
09: */
10: public class SelectSiteNodeId extends TKPrepQuery {
11:
12: /** prepariert ? */
13: public static final boolean PREPARED = true;
14: public static final String[] ORDER = {};
15: public static final Object[][] TYPES = null;
16: public static final boolean[] RELEVANTS = { true };
17:
18: /** die sql-query */
19: public static String SQLSTRING =
20:
21: "SELECT T2.SITE_NODE_ID AS ST_SITE_NODE_ID, T2.CONTENT_NODE_ID AS CT_CONTENT_NODE_ID, T2.CONTENT_NODE_SHORTNAME AS CT_CONTENT_NODE_NAME, T2.CONTENT_NODE_TYPE AS CT_CONTENT_NODE_TYPE, SD.SITE_NODE_ID AS SD_SITE_NODE_ID, SD.SITE_NODE_DOC_IDX AS SD_SITE_NODE_DOC_IDX, SD.DOCUMENT_NAME AS SD_DOCUMENT_NAME, SD.DOCUMENT_SHORTNAME AS SD_DOCUMENT_SHORTNAME FROM WEBMAN_TEMP2 T2, SITE_DOCUMENT SD WHERE T2.DC_SITE_NODE_ID = SD.SITE_NODE_ID (+) "
22: + " AND T2.DC_SITE_NODE_DOC_IDX = SD.SITE_NODE_DOC_IDX (+) ORDER BY "
23: + DBStringFactory.upper_order()
24: + " (T2.CONTENT_NODE_SHORTNAME) ";
25:
26: public void initQuery(Connection con) {
27: super.initQuery(con, PREPARED, ORDER, TYPES, RELEVANTS,
28: SQLSTRING);
29: }
30:
31: }
|