How to grab results from recordset

[Roger]

Hi:
Is it possible to grab recordset even after SQL throws error, but also
returns data?

[Aaron [SQL Server MVP]]

Re: How to grab results from recordset

Can you show an example? Is it an error, or a warning message?

--

http://www.aspfaq.com/

(Reverse address to reply.)




"Roger" <someone@micros oft.com> wrote in message
news:ObcYWdTVEH A.3332@tk2msftn gp13.phx.gbl...[color=blue]
> Hi:
> Is it possible to grab recordset even after SQL throws error, but also
> returns data?
>
>[/color]

[Roger]

Re: How to grab results from recordset

Here's the deal, when I run the stored procedure in query analyzer, it
returns results, but also returns errors returned from a nested stored
procedure. When I call my stored procedure from ASP, I want to display the
resultset and email the error message. Is this possible?

Roger


"Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
news:uRs9CoTVEH A.2972@TK2MSFTN GP12.phx.gbl...[color=blue]
> Can you show an example? Is it an error, or a warning message?
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "Roger" <someone@micros oft.com> wrote in message
> news:ObcYWdTVEH A.3332@tk2msftn gp13.phx.gbl...[color=green]
> > Hi:
> > Is it possible to grab recordset even after SQL throws error, but also
> > returns data?
> >
> >[/color]
>
>[/color]

[Bob Barrows [MVP]]

Re: How to grab results from recordset

Roger wrote:[color=blue]
> Here's the deal, when I run the stored procedure in query analyzer, it
> returns results, but also returns errors returned from a nested stored
> procedure.[/color]

What do you mean by "returns errors"? Do you have code in your stored
procdedure to return these messages via output parameters or something? Or
are you referring to the errors displayed by QA?
[color=blue]
> When I call my stored procedure from ASP, I want to
> display the resultset and email the error message. Is this possible?
>[/color]

Yes. You'll need to clarify what you are talking about before we can get
specific.

Have you tried looking into the connection object's Errors collection?

Bob Barrows

--
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"