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

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-us/ado270/htm/mdmthrstopen.asp
http://msdn.microsoft.com/library/en-us/ado270/htm/mdcstcursortypeenum.asp
http://msdn.microsoft.com/library/en-us/ado270/htm/mdcstcursorlocationenum.asp
http://msdn.microsoft.com/library/en-us/ado270/htm/mdprorecordcount.asp

Razvan

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

[quoted text, click to view]

Eugene Anthony (solomon_13000@yahoo.com) writes:
[quoted text, click to view]

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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at