Recordset

[Eugene Anthony]

This asp code displayes records in a combo box:
<%
openDB()

call updateDB("usp_retrieveOptions",rs)

if not rs.eof then

%>
<tr>
<td width="66">Options</td>
<td width="137">
<select name="select1" class="TextField1">
<%
i = 0

do while not rs.eof

if rs(0) <> Arr(i) then
response.write "<option value=" & rs(0) & ">" & rs(1)
i = i + 1
end if

rs.movenext

loop
%>
</select>
</td>
</tr>
<tr>
<td colspan="2" width="206">
<center>
<table width="71" border="0" cellspacing="3" cellpadding="0"
height="33">
<tr>
<td width="9" height="30">
<input type="submit" name="Assign" value="Assign"></td>
</tr>
</table>
</center>
</td>
</tr>
<%
end if

closeRS()
closeDB()
%>

The call updateDB("usp_retrieveOptions",rs) invokes

sub updateDB(SQL,rs)

set rs = objConn.Execute(SQL)

end sub
and my usp_retrieveOptions stored procedure:

create procedure usp_retrieveOptions
AS SET NOCOUNT ON

SELECT OptionID, Description FROM Options

Return
GO
now in my asp code when I try response.write rs.RecordCount I am getting
-1 all the time. How do I solve the problem. Your help is kindly
appreciated.

Eugene Anthony

*** Sent via Developersdex http://www.developersdex.com ***

[Razvan Socol]

Hi, Eugene

For some answers to your question, see:
http://www.aspfaq.com/show.asp?id=2193

Also, you can try to specify different options for CursorType (e.g.
adOpenStatic=3) or CursorLocation (e.g. adUseClient=3).
For more informations, see:
http://msdn.microsoft.com/library/en...mthrstopen.asp
http://msdn.microsoft.com/library/en...ortypeenum.asp
http://msdn.microsoft.com/library/en...cationenum.asp
http://msdn.microsoft.com/library/en...ecordcount.asp

Razvan

[Eugene Anthony]

I did this:
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Exec usp_retrieveOptions",objConn,1,1
response.write rs.RecordCount

and im still getting -1
Eugene Anthony

*** Sent via Developersdex http://www.developersdex.com ***

[Trevor Best]

Eugene Anthony wrote:

I did this:
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Exec usp_retrieveOptions",objConn,1,1
response.write rs.RecordCount

and im still getting -1
Eugene Anthony

*** Sent via Developersdex http://www.developersdex.com ***

http://msdn.microsoft.com/library/de...ecordcount.asp

[Erland Sommarskog]

Eugene Anthony (so***********@yahoo.com) writes:

I did this:
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Exec usp_retrieveOptions",objConn,1,1
response.write rs.RecordCount

and im still getting -1

Do you set the cursor location anywhere? The .CursorLocation is a
property on the connection object. Set it to adUseClient.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx