01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: /** löscht alles aus Contentattribut keine Valueid in Contentattributvalue eingetragen ist
07: * @author $Author: sebastian $
08: * @version $Revision: 1.1 $
09: */
10:
11: public class DeleteFromContentAttribute extends TKPrepQuery {
12:
13: public final static boolean PREPARED = true;
14:
15: public final static String[] ORDER = null;
16:
17: public final static Object[][] TYPES = null;
18:
19: public final static boolean[] RELEVANTS = { true };
20:
21: public final static String SQLSTRING = "DELETE FROM "
22: + " CONTENT_ATTRIBUTE " + "WHERE " + "NOT ( VALUE_ID "
23: + "IN ( " + "SELECT VALUE_ID "
24: + "FROM CONTENT_ATTRIBUTE_VALUE ) )";
25:
26: public void initQuery(Connection con) {
27: super.initQuery(con, PREPARED, ORDER, TYPES, RELEVANTS,
28: SQLSTRING);
29: }
30:
31: }
|