[manni]

Hallo,

have someone an example with bind variables like this:

Statement stmt = new Statement(db, "SELECT ms FROM tables WHERE foo = ?");
stmt.bind(1, "12345");
stmt.query(); ??
stmt.execute();

I didn't know how to fetch the results.

Manfred

[jpelcis]

Try using stmt.query() instead of stmt.execute() at the end of what you have. When you use the query function, you get back the results.

Replace the last line of your code with the following:

Result results = stmt.query();
Row oneRow results.fetchRow();
// or
Row[] allRows results.fetchAll();

At this point, it's probably best to look at the documentation, since there are several different ways to get information from the rows. If you need more help though, go ahead and ask.

[manni]

It run fine.
Thank you.

Manfred