编译器输出:
05-09 10:35:04.919: E/AndroidRuntime(6277): android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x327248
05-09 10:35:04.919: E/AndroidRuntime(6277): at com.swift.ma.ui.SignAll$1.onMenuItemClick(SignAlljava:90)
问题代码
String[] deletedEms = new String[toDeletedEms.size()];
for (int i = 0; i< toDeletedEms.size(); i++) {
deletedEms[i]=toDeletedEms.get(i);
}
ContentResolver cr= SignAll.this.getContentResolver();
int rowsID= cr.delete(CONTENT_URI, "employeeName =?", deletedEms);
修正:
String selection="employeeName = ?";
String[] deletedEms = new String[toDeletedEms.size()];
for (int i = 0; i< toDeletedEms.size(); i++) {
deletedEms[i]=toDeletedEms.get(i);
if(i>0){
selection += "or employeeName = ?";
}
}
ContentResolver cr= SignAll.this.getContentResolver();
int rowsID= cr.delete(CONTENT_URI, selection, deletedEms);
String[] deletedEms = new String[toDeletedEms.size()];
for (int i = 0; i< toDeletedEms.size(); i++) {
deletedEms[i]=toDeletedEms.get(i);
if(i>0){
selection += "or employeeName = ?";
}
}
ContentResolver cr= SignAll.this.getContentResolver();
int rowsID= cr.delete(CONTENT_URI, selection, deletedEms);