01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/content/ContentTreeID.java,v 1.1 2001/01/31 16:23:13 marwan Exp $
03: *
04: */
05: package com.teamkonzept.webman.mainint.db.queries.content;
06:
07: import java.sql.*;
08:
09: import com.teamkonzept.db.*;
10:
11: public class ContentTreeID extends TKPrepQuery {
12:
13: public final static boolean isPrepared = true;
14:
15: public final static String[] paramOrder = { CONTENT_ID };
16:
17: public final static Object[][] paramTypes = null;
18:
19: public final static boolean[] setRelevants = { true };
20:
21: public final static String sqlString =
22:
23: " SELECT DISTINCT C_I.CONTENT_NODE_ID "
24: + " FROM CONTENT_INSTANCE C_I, CONTENT_VERSION C_V "
25: + " WHERE C_I.INSTANCE_ID = C_V.INSTANCE_ID " + " AND "
26: + " C_V.CONTENT_ID = ? ";
27:
28: public void initQuery(Connection con) {
29: super.initQuery(con, isPrepared, paramOrder, paramTypes,
30: setRelevants, sqlString);
31: }
32: }
|