Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > RESULTSET PROBLEM

Reply
Thread Tools

RESULTSET PROBLEM

 
 
Savas Ates
Guest
Posts: n/a
 
      06-03-2005
I have a stored procedure below.. When I run it with a well parameter in
query analyser 3 of select statements return me. (i named select statements
1,2,3)
But in asp page when i call this procedure same as query analyser it returns
me 2 select statements value? what is the problem ?


CREATE PROCEDURE ST_25INDIRIM
@sesid BIGINT
AS


IF EXISTS (SELECT 1 FROM sepet WHERE (adet=2 AND sesid=@sesid ) )
BEGIN
-1- SELECT * FROM sepet WHERE (adet=2 AND sesid=@sesid)
END
ELSE
/*URUN SAYISI IKI TANE OLAN YOK VE ADETI BIR TANE OLAN EN AZ 2 URUN OLUP
OLMADIGI KONTROLU*/
BEGIN



-2- SELECT * FROM sepet WHERE (adet =1 AND sesid=@sesid) ORDER BY id ASC


IF (@@rowcount>=2 )
BEGIN

-3- SELECT TOP 1 * FROM sepet WHERE id IN (SELECT TOP 2 id FROM sepet
WHERE (adet =1 AND sesid=@sesid) ORDER BY id ASC ) ORDER BY id DESC

END



END
GO


 
Reply With Quote
 
 
 
 
Bob Barrows [MVP]
Guest
Posts: n/a
 
      06-03-2005
Savas Ates wrote:
> I have a stored procedure below.. When I run it with a well parameter
> in query analyser 3 of select statements return me. (i named select
> statements 1,2,3)
> But in asp page when i call this procedure same as query analyser it
> returns me 2 select statements value? what is the problem ?
>



I don't understand why you think you should be getting 3 resultsets.
Depending on the result of the first IF statement, you should be receiving
either resultset 1 OR resultset 2. If you get resultset 2, then, if the last
if statement is true, you will get resultset 3 as well. In other words, you
will get one of these possibilities:

resultset 1 only
resultset 2 only
resultset 2 and resultset 3 *

I think you need to provide a create table statement and insert statements
to provide sample data to help us to understand what your problem really is.

Bob Barrows

* In asp, you will need to use NextRecordset to get both resultsets - you
should make it a habit to start your stored procedures with "SET NOCOUNT ON"
to avoid getting extra resultsets containing informational messages
returned:
create someprocedure as
set nocount on
etc.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


 
Reply With Quote
 
 
 
 
Gert-Jan Strik
Guest
Posts: n/a
 
      06-03-2005
Maybe you have different ANSI_NULL settings, and you are calling the SP
with @sesid IS NULL ?

Gert-Jan


Savas Ates wrote:
>
> I have a stored procedure below.. When I run it with a well parameter in
> query analyser 3 of select statements return me. (i named select statements
> 1,2,3)
> But in asp page when i call this procedure same as query analyser it returns
> me 2 select statements value? what is the problem ?
>
> CREATE PROCEDURE ST_25INDIRIM
> @sesid BIGINT
> AS
>
> IF EXISTS (SELECT 1 FROM sepet WHERE (adet=2 AND sesid=@sesid ) )
> BEGIN
> -1- SELECT * FROM sepet WHERE (adet=2 AND sesid=@sesid)
> END
> ELSE
> /*URUN SAYISI IKI TANE OLAN YOK VE ADETI BIR TANE OLAN EN AZ 2 URUN OLUP
> OLMADIGI KONTROLU*/
> BEGIN
>
> -2- SELECT * FROM sepet WHERE (adet =1 AND sesid=@sesid) ORDER BY id ASC
>
> IF (@@rowcount>=2 )
> BEGIN
>
> -3- SELECT TOP 1 * FROM sepet WHERE id IN (SELECT TOP 2 id FROM sepet
> WHERE (adet =1 AND sesid=@sesid) ORDER BY id ASC ) ORDER BY id DESC
>
> END
>
> END
> GO

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Select Statements in resultset Joe via DotNetMonster.com ASP .Net 3 03-27-2005 12:43 AM
Web Treeview loaded from resultset example =?Utf-8?B?VGltX2s=?= ASP .Net 0 06-18-2004 04:52 AM
Web Treeview loaded from resultset example =?Utf-8?B?VGltX2s=?= ASP .Net 0 06-18-2004 04:51 AM
How i know the size of "resultset"? matrix ASP .Net 0 04-03-2004 07:30 AM
How i set this resultset size for call oracle package? Matrix ASP .Net 0 04-01-2004 06:38 AM



Advertisments