Hi all, here are a discussion on this thread with finally a SOLUTION:

http://www.tek-tips.com/viewthread.cfm?qid=1070419&page=1

Hope this help to all who face the same situation.

Regards,

Orlando Otero

Ok guys, finally the problem was solved.

Attempting to access the output parameter without having closed the RecordSet probably through an Exception that due to the fact that some included file...

Hi guys,

I included "connTest.asp" which includes "adovb.asp" which includes all ADO constants definition, as mentioned earlier, if the adSomeLiteral=SomeValue constants didn't load the correct value I would get a RUNTIME...

I found NO WAY to make it works.

And now Short Circuit evaluations in ASP's IF statements doesn't work too.

If rs.State=0 Or rs.EOF ... gave me error at this line when...

I'm using OLEDB provider for ODBC. Does this could be the problem?

OO

Here is how I tested the stored proc:

Declare @Regs1 INT, @Regs2 INT

exec @Regs1=spGetAds_OO '', '', NULL, '=', NULL, NULL, NULL, 25, 1, @Regs2 OUTPUT

Print @Regs1

Print @Regs2

//Store proc here

CREATE PROCEDURE spGetAds_OO

 ...

I set up a Connection, Command and RecordSet Objects in a file that is included in all .asp that calls store proc. That file includes too "adovbs.asp" file, which contains all...

Thanks all,

I did this way:

Declare @TotalRegs INT

...

  SET @Query=N'SELECT @Total=COUNT('+@PrimaryKey+N') FROM '+@TableName

...

  exec sp_executesql @Query, N'@Total INT OUTPUT', @Total=@TotalRegs OUTPUT

RETURN @TotalRegs

Regards,

Orlando Otero