Just as with a regular JDBC result set, you need to call next() before
using a row from the result set.
HTH,
Geert
On 06 Apr 2009, at 09:18, Rahul wrote:
>
> I am trying to execute a select query
>
> Select select =new Select(getDatasource());
> select.field("user_id").from(TABLE_NAME_USER).where("username = \'"
> +user.getUsername() + "\'");
> String result = (String)manager.executeQuery(select, new
> DbResultSetHandler() {
> public Object concludeResults(DbResultSet resultset)
> throws SQLException
> {
> return resultset.getString("user_id");
> }
> });
>
>
> While executing this I am getting the error
>
> com.uwyn.rife.database.exceptions.DatabaseException:
> java.sql.SQLException: Before start of result set
>
> not sure why?
>
> CAn anyone help me out with this?
> >
--
Geert Bevin
Terracotta - http://www.terracotta.org
Uwyn "Use what you need" - http://uwyn.com
RIFE Java application framework - http://rifers.org
Flytecase Band - http://flytecase.be
Music and words - http://gbevin.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"rife-users" group.
To post to this group, send email to rife-users@googlegroups.com
To unsubscribe from this group, send email to
rife-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rife-users?hl=en
-~----------~----~----~----~------~----~------~--~---
