B4J Question [RDC] Result Recordset handling

Cableguy

Expert
Licensed User
Longtime User
Hi MySQL gurus!

In the scenario where the recordset is expected to consist on only one (1) Row, is there an easier way to get a specific column value other than cycling the recordset rows??

I mean, is there a way to do something like this?

result.row(0).column.get("MyColumnName")
 
Sort by date Sort by votes

EnriqueGonzalez

Expert
Licensed User
Longtime User
In dbutils (somewhere in the forum you may find it) there is a function that converts a single resultset in a map where the keys are the columns.

The name of the function is executemap.
 
Upvote 0

Cableguy

Expert
Licensed User
Longtime User
Why does the obvious always seems to illude me?
 
Upvote 0

Harris

Expert
Licensed User
Longtime User
Cableguy said:
Why does the obvious always seems to illude me?
Click to expand...
Because you are human?!
Don't despair, You are NOT alone.
We members of this community (except bots) are afflicted with the same deficiency - well some of us anyway...
Often it seems that designing code interferes with design logic.
It is a trap purposely set by expert native Java developers.
Note: the preceding statement excludes registered users and owners this product / site.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
B4J Question One ResultSet in several loops
Replies
4
Views
1K
peacemaker
  • Question
B4J Question Cursor to Resultset
Replies
14
Views
2K
peacemaker
  • Question
B4J Question jrdc2 postgresql stored procedure call
Replies
7
Views
1K
hwatech
M
  • Question
B4J Question Serialize ResultSet
Replies
2
Views
794
micro
M
  • Question
B4J Question jSQL, ResultSet and (lack of) RowCount
Replies
2
Views
3K
tchart
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…