First, you have to close your recordset, then you should
be able to reference parm2, but it won't be as part of a recordset
like you mentioned.
My command object is always called spComm, so when I'm ready
to get its value, I do:
DIM myValue
myValue = spComm.Parameters("@parametername")
Response.Write myValue
Chris Tifer
----- Original Message -----
From: "Steve Abaffy" <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 8:53 AM
Subject: RE: Quick SQL Query Question
> Yes I tried that, but all I got back was the last select statement.
>
> I even tried
>
> create Procedure ProcedureName
> @parm1 int,
> @parm2 int output
>
> Processing here
>
> Select @parm2 = Count(*) from table
> Select * from table
> GO
>
> and in the ASP page
>
> Set RS = Conn.Execute("Execute ProdcureName @Parm1=1")
> Response.write RS("Parm2")
> I get the error "Can not find ordinal referenced in the line above"
>
>
> -----Original Message-----
> From: Chris Tifer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 09, 2002 1:35 PM
> To: ActiveServerPages
> Subject: Re: Quick SQL Query Question
>
>
> If I was using a stored procedure, I would probably just
> set up an output parameter with the count.
>
> SET NOCOUNT ON
> SELECT @myOutputVar = COUNT(*) FROM TABLE
> SELECT * FROM TABLE
> SET NOCOUNT OFF
>
> Unless there's a specific need for EACH row to also return
> the total in the table, but for the life of me I can't come up with
> a reason.
>
> Chris Tifer
>
> ----- Original Message -----
> From: "Steve Abaffy" <[EMAIL PROTECTED]>
> To: "ActiveServerPages" <[EMAIL PROTECTED]>
> Sent: Wednesday, October 09, 2002 7:42 AM
> Subject: OT: Quick SQL Query Question
>
>
> > Hello,
> >
> > How do I write a query that will return all the rows in a table with the
> > addition of the count of those rows?
> > Something like
> >
> > Select Count(*),* From table
> >
> > Thanks in Advandce
> >
> >
> >
> > ---
> > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
> > To unsubscribe send a blank email to
> %%email.unsub%%
> >
>
>
> ---
> You are currently subscribed to activeserverpages as:
[EMAIL PROTECTED]
> To unsubscribe send a blank email to
> %%email.unsub%%
>
>
>
>
> ---
> You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
