Questions tagged [multiple-resultsets]
103 questions
2
votes
0 answers
Entity Framework with multiple result set from stored procedure
Is there any kind of limitation with entity framework for number of result set accepted that is returned by stored procedure?
I tried to get 3 result sets from stored procedure in enitity framework but everytime I get error of
The type parameter…
Dhwani
- 7,484
- 17
- 78
- 139
2
votes
1 answer
MYSQL + PDO nextRowSet Loops one too many times?
I am struggling with a MYSQL (5.5.35) stored procedure that returns multiple result sets, I wonder if anyone can explain what is going wrong. The SQL is as per the following
SELECT 't1' as tableName, tbl1.* FROM table1 tbl1;
SELECT 't2' as…
Zoidberg
- 21
- 3
1
vote
2 answers
Is it possible in Java to retrieve tables of unrelated data in a single SQL query and resultset?
We have multiple tables that contain "static" key/value pairs, which are currently pulled using multiple SQL (MSSQL) queries. Is it possible to pull all of this data in one SQL query, so that we can reference each column key and column value in a…
user4903
1
vote
2 answers
return multiple values (variables) with PHP
hello there i am working on a function which should return a database result set AND the time it took the query to retrieve the data. Works good but i don't know how to return the time and the result set and make them available in the view. Thanks…
user6221709
1
vote
1 answer
com.microsoft.sqlserver.jdbc.SQLServerException: This operation is not supported
I am using sql server for database connection . And i want to keep the result set open while running multiple result sets. I have used results = callableStatement.getMoreResults(Statement.KEEP_CURRENT_RESULT);
But i am getting the following error…
Shajitha Begum K
- 57
- 10
1
vote
1 answer
Multiple Spelling Results in a Dataframe
I have some data containing spelling errors. I'm correcting them and scoring how close the spelling is using the following code:
import pandas as pd
import difflib
Li_A = ["potato", "tomato", "squash", "apple", "pear"]
B = {'one' :…
R. Cox
- 819
- 8
- 25
1
vote
1 answer
Missing message text while looping PHPMailer
This is my code:
// $mail->addReplyTo('noreply@pbrx.co.id', 'No Reply');
$subjectTo = explode(';', $Addres);
//var_dump($Addres);
array($subjectTo);
// var_dump(array($subjectTo));
foreach ($subjectTo as $key => $value) {
// $mail->isSMTP(); …
Wolfzmus
- 463
- 1
- 10
- 23
1
vote
0 answers
How to Retrieve Multiple Result Sets from a Stored Procedure using MySQL Cpp connector?
Say, the following Stored Procedure returns multiple resultsets:
drop procedure if exists sample_stored_procedure;
delimiter //
create procedure sample_stored_procedure()
begin
select C1 from tab1;
select C1 from tab1 WHERE C1>2;
select…
Snehasish Sarkar
- 134
- 10
1
vote
3 answers
To write the value from resultset to text file (.txt file)
Please help me on the below code as i want to write the values from the resultset to a txt file
Code
while (rs.next()){
FileWriter fstream = new FileWriter(file);
BufferedWriter out = new BufferedWriter(fstream);
…
Neethu Shaji
- 120
- 3
- 4
- 13
1
vote
1 answer
Avoid MySQL multi-results from SP with Execute
i have an SP like
BEGIN
DECLARE ...
CREATE TEMPORARY TABLE tmptbl_found (...);
PREPARE find FROM" INSERT INTO tmptbl_found
(SELECT userid FROM
(
SELECT userid FROM Soul
WHERE
.?.?.
…
hhyhbpen
- 43
- 3
1
vote
2 answers
Receiving one out of few Result Sets in stored procedure
I have a stored procedure that works fine but it has inside it three "select"s.
The selects are not from an inner temporary table.
This is mainly the format of the procedure:
ALTER PROCEDURE [dbo].[STProce]
@param1 int,
@param2 int,
@param3…
Itzick Binder
- 175
- 1
- 4
- 18
1
vote
2 answers
sql stored procedure clear resultsets
Can I clear the multiple result sets that a stored procedure has already gathered so that the next result set that is created becomes the very first result set returned by the procedure?
DEH
- 1,647
- 3
- 25
- 45
1
vote
2 answers
T-SQL Return Multiple Result Sets
I'm hopeful that this isn't too awkward a question, but my searches so far haven't shed much light on things. My apologies if it's been asked before.
I need to write a stored proc to run a simple query along the lines of
SELECT foo
FROM sometable…
Tyr
- 782
- 8
- 19
1
vote
1 answer
LINQ to SQL stored procedures with multiple results in Visual Studio 2008
I'm using visual studio 2008 and I've created a stored procedure that selects back two different result sets. I drag the stored proc on to a linq to sql dbml datacontext class, causing visual studio to create the following code in the cs…
Jeremy
- 44,950
- 68
- 206
- 332
1
vote
1 answer
How do I join multiple result sets from a WHILE loop in a mySQL query?
This is the problem that I currently have.
I have 7 tables of trip data. What I am currently doing is selecting at random, a Card_ID from the third table, then searching through all 7 tables with that Card_ID and selecting all record made by that…
EJ Chua
- 11
- 2