1 package com.teamkonzept.webman.mainint.db.queries.field; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 6 public class SelectFromContentVersion extends TKPrepQuery 7 { 8 9 public final static boolean prepared = true; 10 11 public final static String [] order = 12 { 13 "VERS_ID", 14 "INST_ID" 15 }; 16 17 public final static Object [][] types = null; 18 19 public final static boolean[] relevants = { true }; 20 21 public final static String sqlString = "SELECT CV.*, CI.NAME FROM CONTENT_VERSION CV, CONTENT_INSTANCE CI WHERE CV.VERSION_ID = ? AND CI.INSTANCE_ID = ?"; 22 23 public void initQuery(Connection con) { 24 super.initQuery( 25 con, 26 prepared, 27 order, 28 types, 29 relevants, 30 sqlString ); 31 } 32 33 } | Popular Tags |