populate dropdown from sproc

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

%>




























Client BDD Status Meeting
Date
Brief
Received
Response
Submitted
Site Visit Decision
Due
Sign Off
Status
Sign Off
Month
Go Live Activity
Type
Description Number of
Seats
Commercials Duration Comments


BDD


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
>
> %>
>


>

This is OT, but a table, this is bad HTML. The only element that can come
after a table element is CAPTION, THEAD, COL, COLGROUP or TR. The proper
way is FORM then TABLE.

>
>

Save yourself some time, use the right tools for the job:
- th is natively bold and centered.
and in the CSS:
th {background-color:#CCC; white-space: nobreak}

>
> align="center">Client Field Title