01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/SdNextIdx.java,v 1.5 2036/02/08 19:17:04 markus Exp $
03: *
04: */
05: package com.teamkonzept.webman.mainint.db.queries.sitetree;
06:
07: import java.sql.*;
08:
09: import com.teamkonzept.db.*;
10:
11: /**
12: *
13: * @author
14: * @version
15: */
16: public class SdNextIdx extends TKPrepQuery {
17:
18: public final static boolean ISPREPARED = true;
19: public final static String[] PARAMORDER = { "SITE_NODE_ID" };
20: public final static Object[][] PARAMTYPES = null;
21: public final static boolean[] SETRELEVANTS = { true };
22:
23: public final static String SQLSTRING =
24:
25: " SELECT "
26: + DBStringFactory.nvl()
27: + "(MAX(SITE_NODE_DOC_IDX) + 1,0) AS SITE_NODE_DOC_IDX FROM SITE_DOCUMENT WHERE SITE_NODE_ID = ? ";
28:
29: public void initQuery(Connection con) {
30: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
31: SETRELEVANTS, SQLSTRING);
32: }
33: }
|