You have to use the Command Object and its Parameter Objects for this to work.
HTH, Tore. -----Original Message----- From: Steve Abaffy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 11:53 AM To: ActiveServerPages 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]
