Android Sqlite query

Question

My requirement is when I pass some paramenter query need to send object. not list.

I have written the code :

 public RDExecutive getExecutiveObject(String executivename){
     DBAdapter dbAdapter = DBAdapter.getDBAdapterInstance(this);
     dbAdapter.openDataBase();
     System.out.println( " ---- executivename --- " + executivename);
     String query="SELECT * FROM RDExecutive WHERE ExecutiveName = ?';";
     String[]d = new String[]{executivename};
     ArrayList stringList = dbAdapter.selectRecordsFromDBList(query, d);

     dbAdapter.close();

     ArrayList<Object> rdExecutiveObject = new ArrayList<Object>();
     RDExecutive rdExecutive = new RDExecutive();
     System.out.println( " -- stringList.size() -- " + stringList.size());

     for (int i = 0; i < stringList.size(); i++) {
        ArrayList<Object> arrayList2 = (ArrayList<Object>) stringList.get(i);
        ArrayList<Object> arrayList = arrayList2;
        ArrayList<Object> list = arrayList;

        try {
            rdExecutive.setBusinessUnit((String) list.get(0));
            rdExecutive.setExecutiveCode((String) list.get(1));
            rdExecutive.setExecutiveName((String) list.get(2));
            rdExecutive.setTerritoryCode((String) list.get(10));

        } catch (Exception e) {
            Log.i("***" + SalesRouteActivity.class.toString(), e.getMessage());
        }
        rdExecutiveObject.add(rdExecutive);
    }
    return rdExecutive;
}

This method is return RDExecutive object.

When I run this part , I got error

java.lang.RuntimeException: Unable to start activity ComponentInfo{com.xont.controller/com.xont.controller.DownlaodTableActivity}: 

android.database.sqlite.SQLiteException: unrecognized token: "';": , while compiling: 
SELECT * FROM RDExecutive WHERE ExecutiveName = ?';

How do we want to pass parameter to query.

Sathyajith Bhat · Accepted Answer · 2011-07-29 05:32:08Z

1

You don't need the semicolong (";")

String query="SELECT * FROM RDExecutive WHERE ExecutiveName = ?'";

Should be fine

answered Jul 29, 2011 at 5:32

Sathyajith Bhat

22k22 gold badges102 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stephen Quan · Accepted Answer · 2012-01-16 02:22:10Z

0

You have a SQL syntax error. You need to remove a single quote, i.e.

 // This line has the error:
 String query="SELECT * FROM RDExecutive WHERE ExecutiveName = ?';";

 // This is the same line with the error fixed:
 String query="SELECT * FROM RDExecutive WHERE ExecutiveName = ?;";

answered Jan 16, 2012 at 2:22

Stephen Quan

28k4 gold badges102 silver badges94 bronze badges

Collectives™ on Stack Overflow

Android Sqlite query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related