populate dropdown from sproc
am 24.07.2007 15:25:15 von Mike P
I am trying to populate a dropdown from a stored procedure, but I am
getting the error 'Object doesn't support this property or method:
'Next' :
<%
set objConn = server.createobject("adodb.connection")
objConn.open strConnection
%>
Can anybody help?
*** Sent via Developersdex http://www.developersdex.com ***
Re: populate dropdown from sproc
am 24.07.2007 16:15:54 von reb01501
Mike P wrote:
> I am trying to populate a dropdown from a stored procedure, but I am
> getting the error 'Object doesn't support this property or method:
> 'Next' :
Please don't multipost. This question was answered in the vbscrpt group you
posted to.
There is no method called Next. It's "MoveNext"
Your code would probably be more efficient if you used Getrows to move the
data into an array, allowing you to close your recordset and database
connection much sooner.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Re: populate dropdown from sproc
am 31.07.2007 07:12:07 von Adrienne Boswell
Gazing into my crystal ball I observed Mike P
writing in news:O#wBTYfzHHA.5092@TK2MSFTNGP04.phx.gbl:
> I am trying to populate a dropdown from a stored procedure, but I am
> getting the error 'Object doesn't support this property or method:
> 'Next' :
>
>
>
>
><%
>
> set objConn = server.createobject("adodb.connection")
> objConn.open strConnection
>
> %>
>