Questions tagged [multiple-resultsets]
103 questions
0
votes
1 answer
How to Avoid Running a Formula From a Common Spreadsheet Under Certain Conditions
I am trying to run multiple scenarios in a financial model that all originate from one common set of formulas in a singular sheet. Simultaneously, I would like the results for all non-active scenarios (i.e. if the governing condition is not met) to…
DSP
- 1
0
votes
3 answers
Trouble with ResultSet using executeUpdate
I am new to programming and have run into a problem while using executeUpdate with the resultSet next() method.
It iterates once only through the result set then the execute update closes the result set. I get error: ResultSet not open. Operation…
Chris R
- 39
- 1
- 7
0
votes
1 answer
MySQL - Set maximum number of result sets per query
When running a large stored procedure mysql script, I am getting the following error
The maximum number of result sets per query is reached (100).
After looking around I have found a few articles that say I can change that limit specifically in…
Nathaniel Rogers
- 249
- 4
- 10
0
votes
1 answer
php quiz having questions and answers in two different resultset
I am making a quiz which have questions and its options. Both questions and options are coming from database in resultsets. I am facing problems in loops and resultsets.
1 - I am not able to choose option out of each question. Whenever, I am…
Avi
- 1
- 2
0
votes
1 answer
Combining multiple SQL's into a single SQL
Hi have the following queries
(SELECT COUNT(DISTINCT KUNDNR) CHECKED_CUSTOMER from CLNT0001.TCM_CHECK_SUMMARY
where '20170322000000000' <= HISTVON and HISTVON < '20170323000000000' and INSTITUTSNR='0001')
and
SELECT…
kumarD
- 574
- 2
- 9
- 23
0
votes
1 answer
object which contains List of some items cant expose rest data with single query
During creating some services i face some issue with performance, for example:
to call service and get response(for one object Recipe which contains list of RecipeComponents - it took almost 2000ms), what looks like this:
{
"recipe_id": 55,
…
ColeS
- 35
- 1
- 2
- 7
0
votes
1 answer
How to use Multiple resultsets with POSTGRES JDBC?
I am using JDBC on a PostgreSQL database.
When I query for an entity in a resultset, it returns 5 rows.
Related to that entity is another entity, for which I query while i am using a row in the above resultset.
When I execute this query, the above…
manishKungwani
- 925
- 1
- 12
- 44
0
votes
2 answers
Call to undefined method mysqli_stmt::next_result()
I'm trying to loop through a stored procedure, called via prepared statement, in PHP. Hopefully it's not impossible. Here's my PHP code:
$database = new mysqli($server, $user, $pass, $db);
$stmt = $database->prepare("CALL…
B.T.
- 41
- 7
0
votes
1 answer
populating multiple attribute values in java objects using multiple SQL resultsets
I have a set of java classes, and they have certain number of attributes,
these attributes are being assigned values through SQL Queries which is run against a database, in certain classes all the attributes are not being fetched by a single SQL…
kumarD
- 574
- 2
- 9
- 23
0
votes
2 answers
How to create json from mysqli_multi_query resultsets?
I'm trying to display data to bootstrap datatable (4 columns) using php and ajax from mysqli_multi_query().
I could not get the 2nd query working with UNION or INNER JOIN.
I'm no programmer and managed to, almost, get the correct result, but for…
whismerhill
- 3
- 1
- 5
0
votes
1 answer
Call multiple stored procedures from Codeigniter last result contains the previous
I'm using this library in Codeigniter to retrieve multiple result sets from stored procedures :
class Multi_Results
{
private $CI, $Data, $mysqli, $ResultSet;
/**
* The constructor
*/
function __construct()
{
$this->CI =&…
dujmovicv
- 65
- 12
0
votes
1 answer
Stored Procedure Syntax Error at Recompile Time is Trapped by Catch AND Returns Empty Resultset
I am trying to isolate an issue (that resembles the topic in stackoverflow.com/q/483787/537284). The issue involves a stored procedure and occurs "randomly" once a week. To try and reproduce the issue, I created different procedure versions to mimic…
杜興怡
- 135
- 1
- 7
0
votes
1 answer
How to fetch multiple result sets with Poco::Data?
I read the Poco::Data User Manual and there is mentioned that the library has support for multiple result sets. There is example for this support in Multiple Data Sets section of the manual.
typedef Tuple…
bobeff
- 3,543
- 3
- 34
- 62
0
votes
1 answer
ASP.NET MVC 2: Calling Stored Procedure, Getting Multiple ResultSets
How on earch can I access the second, third, fourth result sets?
Controller:
var dataContext = new DealDataContext();
XElement xmlString = new XElement("asd");
var deals = dataContext.spSearchDeals(xmlString);
return View(deals);
View:
<% foreach…
dcolumbus
- 9,596
- 26
- 100
- 165
0
votes
1 answer
How To Populate Jtable Using rs2xml jar library
Dear friends i would like to know how to display the result set to jtable using rs2xml i know jtablename.setmodel(dbutils.setresultsettotable(rs)); but i would like to know that how to retriev all records and show them in jtablle my code is
private…
Love Poet
- 19
- 1
- 1
- 7