Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

java.lang.IllegalArgumentException: Cannot bind argument at index 11 because the index is out of range. The statement has 0 parameters #110

Closed
itsmechlark opened this issue Nov 20, 2013 · 1 comment
Closed

java.lang.IllegalArgumentException: Cannot bind argument at index 11 because the index is out of range. The statement has 0 parameters #110

itsmechlark opened this issue Nov 20, 2013 · 1 comment

Comments

@itsmechlark
Copy link

Log:


11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295): java.lang.IllegalArgumentException: Cannot bind argument at index 11 because the index is out of range.  The statement has 0 parameters.
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteProgram.bind(SQLiteProgram.java:212)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteProgram.bindString(SQLiteProgram.java:166)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteProgram.bindAllArgsAsStrings(SQLiteProgram.java:200)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at de.greenrobot.dao.AbstractDao.queryRaw(AbstractDao.java:462)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler.getHistoryList(DaoDatabaseHandler.java:353)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler.getHistoryList(DaoDatabaseHandler.java:308)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler.getHistory(DaoDatabaseHandler.java:293)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler.updateHistory(DaoDatabaseHandler.java:473)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.fragments.DocViewFragment$Async_DOCtoWebView.doInBackground(DocViewFragment.java:846)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.fragments.DocViewFragment$Async_DOCtoWebView.doInBackground(DocViewFragment.java:1)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.os.AsyncTask$2.call(AsyncTask.java:287)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at java.util.concurrent.FutureTask.run(FutureTask.java:137)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:230)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1076)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:569)
11-20 09:22:24.171: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at java.lang.Thread.run(Thread.java:856)
11-20 09:22:24.179: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295): HISTORY: INVALID PARAMETERS.
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295): java.lang.IllegalArgumentException: Cannot bind argument at index 11 because the index is out of range.  The statement has 0 parameters.
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteProgram.bind(SQLiteProgram.java:212)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteProgram.bindString(SQLiteProgram.java:166)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteProgram.bindAllArgsAsStrings(SQLiteProgram.java:200)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at de.greenrobot.dao.AbstractDao.queryRaw(AbstractDao.java:462)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler.getHistoryList(DaoDatabaseHandler.java:353)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler.getHistoryList(DaoDatabaseHandler.java:308)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler.getHistoryCount(DaoDatabaseHandler.java:448)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler.addHistory(DaoDatabaseHandler.java:222)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.fragments.DocViewFragment$Async_DOCtoWebView.doInBackground(DocViewFragment.java:858)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at com.cdasia.cdasiaonline.fragments.DocViewFragment$Async_DOCtoWebView.doInBackground(DocViewFragment.java:1)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.os.AsyncTask$2.call(AsyncTask.java:287)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at java.util.concurrent.FutureTask.run(FutureTask.java:137)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:230)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1076)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:569)
11-20 09:22:24.187: E/com.cdasia.cdasiaonline.db.greendao.DaoDatabaseHandler(12295):    at java.lang.Thread.run(Thread.java:856)

Code:


public List getHistoryList(Property property, String val,
            int limit, int offset, DocType doc_type) {
        String condition = "WHERE "
                + property.columnName + " = '" + val + "'";
        if (doc_type != null){
            condition += " AND " + HistoryDao.Properties.Doc_type.columnName 
                    + "=" + doc_type.getIntValue();
        }
        condition += " ORDER BY " + HistoryDao.Properties.Date.columnName + " DESC";
        if(limit!=0 && offset!=0){
            condition +=  " LIMIT " + limit
                        + " OFFSET " + offset;
        }
        List historyList = new ArrayList();
        final HistoryDao dao = daoSession.getHistoryDao();
        try {
            dao.queryRaw(condition, dao.getAllColumns());
        } catch (Exception e) {
            historyList = null;
            Log.e(mContext, this.getClass().getName(), Log.getStackTrack(e));
        } 
        return historyList;
    }

History.java


// THIS CODE IS GENERATED BY greenDAO, DO NOT EDIT. Enable "keep" sections if you want to edit. 
/**
 * Entity mapped to table HISTORY.
 */
public class History {
    
    private String id;
    private String ponente;
    private String short_title;
    private String title;
    private String reference_number;
    private String syllabus;
    private String docdate;
    private String section_id;
    private Integer doc_type;
    private String date;
    private String viewed_count;
    
    public History() {
    }
    
    /**
     * History Database Constructor.
     * 
     * @param {@link History#id}
     * @param {@link History#ponente}
     * @param {@link History#short_title}
     * @param {@link History#title}
     * @param {@link History#reference_number}
     * @param {@link History#syllabus}
     * @param {@link History#doc_type}
     * @param {@link History#docdate}
     * @param {@link History#section_id}
     * @param {@link History#date}
     * @param {@link History#viewed_count}
     */
    public History(String id, String ponente, String short_title,
            String title, String reference_number, String syllabus,
            DocType doc_type, String docdate, String section_id, String date,
            String viewed_count) {
        setId(id);
        setPonente(ponente);
        setShort_title(short_title);
        setTitle(title);
        setReference_number(reference_number);
        setSyllabus(syllabus);
        setDoc_type(doc_type.getIntValue());
        setDocdate(docdate);
        setSection_id(section_id);
        setDate(date);
        setViewed_count(viewed_count);
    }

    /**
     * History Database Constructor.
     * 
     * @param {@link History#id}
     * @param {@link History#ponente}
     * @param {@link History#short_title}
     * @param {@link History#title}
     * @param {@link History#reference_number}
     * @param {@link History#syllabus}
     * @param {@link History#doc_type}
     * @param {@link History#docdate}
     */
    public History(String id, String ponente, String short_title,
            String title, String reference_number, String syllabus,
            DocType doc_type, String docdate) {
        setId(id);
        setPonente(ponente);
        setShort_title(short_title);
        setTitle(title);
        setReference_number(reference_number);
        setSyllabus(syllabus);
        setDoc_type(doc_type.getIntValue());
        setDocdate(docdate);
    }

    /**
     * History Database Constructor.
     * 
     * @param {@link History#id}
     * @param {@link History#ponente}
     * @param {@link History#short_title}
     * @param {@link History#title}
     * @param {@link History#reference_number}
     * @param {@link History#syllabus}
     * @param {@link History#doc_type}
     * @param {@link History#docdate}
     * @param {@link History#date}
     * @param {@link History#viewed_count}
     */
    public History(String id, String ponente, String short_title,
            String title, String reference_number, String syllabus,
            DocType doc_type, String docdate, String date, String viewed_count) {
        setId(id);
        setPonente(ponente);
        setShort_title(short_title);
        setTitle(title);
        setReference_number(reference_number);
        setSyllabus(syllabus);
        setDoc_type(doc_type.getIntValue());
        setDocdate(docdate);
        setDate(date);
        setViewed_count(viewed_count);
    }

    /**
     * History Database Constructor.
     * 
     * @param {@link History#id}
     * @param {@link History#short_title}
     * @param {@link History#title}
     * @param {@link History#reference_number}
     * @param {@link History#doc_type}
     * @param {@link History#docdate}
     * @param {@link History#section_id}
     */
    public History(String id, String short_title, String title,
            String reference_number, DocType doc_type, String docdate,
            String section_id) {
        setId(id);
        setShort_title(short_title);
        setTitle(title);
        setReference_number(reference_number);
        setDoc_type(doc_type.getIntValue());
        setDocdate(docdate);
        setSection_id(section_id);
    }

    /**
     * History Database Constructor.
     * 
     * @param {@link History#id}
     * @param {@link History#short_title}
     * @param {@link History#title}
     * @param {@link History#reference_number}
     * @param {@link History#doc_type}
     * @param {@link History#docdate}
     * @param {@link History#section_id}
     * @param {@link History#date}
     * @param {@link History#viewed_count}
     */
    public History(String id, String short_title, String title,
            String reference_number, DocType doc_type, String docdate,
            String section_id, String date, String viewed_count) {
        setId(id);
        setShort_title(short_title);
        setTitle(title);
        setReference_number(reference_number);
        setDoc_type(doc_type.getIntValue());
        setDocdate(docdate);
        setSection_id(section_id);
        setDate(date);
        setViewed_count(viewed_count);
    }
    
    public DocType getDoc_Type(){
        return DocType.mapIntToValue(getDoc_type());
    }
    
    public void setDoc_Type(DocType doc_type){
        setDoc_type(doc_type.getIntValue());
    }

    public History(String id, String ponente, String short_title, String title, String reference_number, String syllabus, String docdate, String section_id, Integer doc_type, String date, String viewed_count) {
        this.id = id;
        this.ponente = ponente;
        this.short_title = short_title;
        this.title = title;
        this.reference_number = reference_number;
        this.syllabus = syllabus;
        this.docdate = docdate;
        this.section_id = section_id;
        this.doc_type = doc_type;
        this.date = date;
        this.viewed_count = viewed_count;
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getPonente() {
        return ponente;
    }

    public void setPonente(String ponente) {
        this.ponente = ponente;
    }

    public String getShort_title() {
        return short_title;
    }

    public void setShort_title(String short_title) {
        this.short_title = short_title;
    }

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public String getReference_number() {
        return reference_number;
    }

    public void setReference_number(String reference_number) {
        this.reference_number = reference_number;
    }

    public String getSyllabus() {
        return syllabus;
    }

    public void setSyllabus(String syllabus) {
        this.syllabus = syllabus;
    }

    public String getDocdate() {
        return docdate;
    }

    public void setDocdate(String docdate) {
        this.docdate = docdate;
    }

    public String getSection_id() {
        return section_id;
    }

    public void setSection_id(String section_id) {
        this.section_id = section_id;
    }

    public Integer getDoc_type() {
        return doc_type;
    }

    public void setDoc_type(Integer doc_type) {
        this.doc_type = doc_type;
    }

    public String getDate() {
        return date;
    }

    public void setDate(String date) {
        this.date = date;
    }

    public String getViewed_count() {
        return viewed_count;
    }

    public void setViewed_count(String viewed_count) {
        this.viewed_count = viewed_count;
    }

}

HistoryDao.java


public class HistoryDao extends AbstractDao {

    public static final String TABLENAME = "HISTORY";

    /**
     * Properties of entity History.

     * Can be used for QueryBuilder and for referencing column names.
    */
    public static class Properties {
        public final static Property Id = new Property(0, String.class, "id", false, "ID");
        public final static Property Ponente = new Property(1, String.class, "ponente", false, "PONENTE");
        public final static Property Short_title = new Property(2, String.class, "short_title", false, "SHORT_TITLE");
        public final static Property Title = new Property(3, String.class, "title", false, "TITLE");
        public final static Property Reference_number = new Property(4, String.class, "reference_number", false, "REFERENCE_NUMBER");
        public final static Property Syllabus = new Property(5, String.class, "syllabus", false, "SYLLABUS");
        public final static Property Docdate = new Property(6, String.class, "docdate", false, "DOCDATE");
        public final static Property Section_id = new Property(7, String.class, "section_id", false, "SECTION_ID");
        public final static Property Doc_type = new Property(8, Integer.class, "doc_type", false, "DOC_TYPE");
        public final static Property Date = new Property(9, String.class, "date", false, "DATE");
        public final static Property Viewed_count = new Property(10, String.class, "viewed_count", false, "VIEWED_COUNT");
    };


    public HistoryDao(DaoConfig config) {
        super(config);
    }
    
    public HistoryDao(DaoConfig config, DaoSession daoSession) {
        super(config, daoSession);
    }

    /** Creates the underlying database table. */
    public static void createTable(SQLiteDatabase db, boolean ifNotExists) {
        String constraint = ifNotExists? "IF NOT EXISTS ": "";
        db.execSQL("CREATE TABLE " + constraint + "'HISTORY' (" + //
                "'ID' TEXT," + // 0: id
                "'PONENTE' TEXT," + // 1: ponente
                "'SHORT_TITLE' TEXT," + // 2: short_title
                "'TITLE' TEXT," + // 3: title
                "'REFERENCE_NUMBER' TEXT," + // 4: reference_number
                "'SYLLABUS' TEXT," + // 5: syllabus
                "'DOCDATE' TEXT," + // 6: docdate
                "'SECTION_ID' TEXT," + // 7: section_id
                "'DOC_TYPE' INTEGER," + // 8: doc_type
                "'DATE' TEXT," + // 9: date
                "'VIEWED_COUNT' TEXT);"); // 10: viewed_count
    }

    /** Drops the underlying database table. */
    public static void dropTable(SQLiteDatabase db, boolean ifExists) {
        String sql = "DROP TABLE " + (ifExists ? "IF EXISTS " : "") + "'HISTORY'";
        db.execSQL(sql);
    }

    /** @inheritdoc */
    @Override
    protected void bindValues(SQLiteStatement stmt, History entity) {
        stmt.clearBindings();
 
        String id = entity.getId();
        if (id != null) {
            stmt.bindString(1, id);
        }
 
        String ponente = entity.getPonente();
        if (ponente != null) {
            stmt.bindString(2, ponente);
        }
 
        String short_title = entity.getShort_title();
        if (short_title != null) {
            stmt.bindString(3, short_title);
        }
 
        String title = entity.getTitle();
        if (title != null) {
            stmt.bindString(4, title);
        }
 
        String reference_number = entity.getReference_number();
        if (reference_number != null) {
            stmt.bindString(5, reference_number);
        }
 
        String syllabus = entity.getSyllabus();
        if (syllabus != null) {
            stmt.bindString(6, syllabus);
        }
 
        String docdate = entity.getDocdate();
        if (docdate != null) {
            stmt.bindString(7, docdate);
        }
 
        String section_id = entity.getSection_id();
        if (section_id != null) {
            stmt.bindString(8, section_id);
        }
 
        Integer doc_type = entity.getDoc_type();
        if (doc_type != null) {
            stmt.bindLong(9, doc_type);
        }
 
        String date = entity.getDate();
        if (date != null) {
            stmt.bindString(10, date);
        }
 
        String viewed_count = entity.getViewed_count();
        if (viewed_count != null) {
            stmt.bindString(11, viewed_count);
        }
    }

    /** @inheritdoc */
    @Override
    public Void readKey(Cursor cursor, int offset) {
        return null;
    }    

    /** @inheritdoc */
    @Override
    public History readEntity(Cursor cursor, int offset) {
        History entity = new History( //
            cursor.isNull(offset + 0) ? null : cursor.getString(offset + 0), // id
            cursor.isNull(offset + 1) ? null : cursor.getString(offset + 1), // ponente
            cursor.isNull(offset + 2) ? null : cursor.getString(offset + 2), // short_title
            cursor.isNull(offset + 3) ? null : cursor.getString(offset + 3), // title
            cursor.isNull(offset + 4) ? null : cursor.getString(offset + 4), // reference_number
            cursor.isNull(offset + 5) ? null : cursor.getString(offset + 5), // syllabus
            cursor.isNull(offset + 6) ? null : cursor.getString(offset + 6), // docdate
            cursor.isNull(offset + 7) ? null : cursor.getString(offset + 7), // section_id
            cursor.isNull(offset + 8) ? null : cursor.getInt(offset + 8), // doc_type
            cursor.isNull(offset + 9) ? null : cursor.getString(offset + 9), // date
            cursor.isNull(offset + 10) ? null : cursor.getString(offset + 10) // viewed_count
        );
        return entity;
    }
     
    /** @inheritdoc */
    @Override
    public void readEntity(Cursor cursor, History entity, int offset) {
        entity.setId(cursor.isNull(offset + 0) ? null : cursor.getString(offset + 0));
        entity.setPonente(cursor.isNull(offset + 1) ? null : cursor.getString(offset + 1));
        entity.setShort_title(cursor.isNull(offset + 2) ? null : cursor.getString(offset + 2));
        entity.setTitle(cursor.isNull(offset + 3) ? null : cursor.getString(offset + 3));
        entity.setReference_number(cursor.isNull(offset + 4) ? null : cursor.getString(offset + 4));
        entity.setSyllabus(cursor.isNull(offset + 5) ? null : cursor.getString(offset + 5));
        entity.setDocdate(cursor.isNull(offset + 6) ? null : cursor.getString(offset + 6));
        entity.setSection_id(cursor.isNull(offset + 7) ? null : cursor.getString(offset + 7));
        entity.setDoc_type(cursor.isNull(offset + 8) ? null : cursor.getInt(offset + 8));
        entity.setDate(cursor.isNull(offset + 9) ? null : cursor.getString(offset + 9));
        entity.setViewed_count(cursor.isNull(offset + 10) ? null : cursor.getString(offset + 10));
     }
    
    /** @inheritdoc */
    @Override
    protected Void updateKeyAfterInsert(History entity, long rowId) {
        // Unsupported or missing PK type
        return null;
    }
    
    /** @inheritdoc */
    @Override
    public Void getKey(History entity) {
        return null;
    }

    /** @inheritdoc */
    @Override    
    protected boolean isEntityUpdateable() {
        return true;
    }
    
}
@itsmechlark
Copy link
Author

New Code:


public List getHistoryList(Property property, String val,
            int limit, int offset, DocType doc_type) {
        String condition = "WHERE "
                + property.columnName + " = '" + val + "'";
        if (doc_type != null){
            condition += " AND " + HistoryDao.Properties.Doc_type.columnName 
                    + "=" + doc_type.getIntValue();
        }
        condition += " ORDER BY " + HistoryDao.Properties.Date.columnName + " DESC";
        if(limit!=0 && offset!=0){
            condition +=  " LIMIT " + limit
                        + " OFFSET " + offset;
        }
        List historyList = new ArrayList();
        final HistoryDao dao = daoSession.getHistoryDao();
        try {
            dao.queryRaw(condition);
        } catch (Exception e) {
            historyList = null;
            Log.e(mContext, this.getClass().getName(), Log.getStackTrack(e));
        } 
        return historyList;
    }

And I added this in the library:


/** A raw-style query where you can pass any WHERE clause and arguments. */
    public List queryRaw(String where, String... selectionArg) {
        Cursor cursor = db.rawQuery(statements.getSelectAll() + where, selectionArg);
        return loadAllAndCloseCursor(cursor);
    }

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@itsmechlark