- changed status to resolved
multiple query from procedure
Issue #43
resolved
Hello. I have procedure witch result is like:
select name, user, type;
select surname, office, type;
select login, city, type;
I’l make
zdb::ResultSet QueryResult = prep.executeQuery();
and when I get result by
while (QueryResult.next())
i get only first select (name, user, type), please help, how to get multiple query? I don’t find any information about it.
Comments (4)
-
repo owner -
reporter Thanks for answer, union is not good idea - row name is different
-
reporter - changed status to open
-
repo owner - changed status to resolved
This is not really a libzdb issue. Please investigate SQL to find a solution! F.ex. explicate name columns in the select statement, or write SQL directly in executeQuery
- Log in to comment
Only one Result Set can be returned and handled by executeQuery (see documentation). Use the union operator to combine the selects