Hi,
Can someone please help me solve an issue? I am trying to add a custom drop down list using a snippet with values that are read from a table in the database. The error I get is:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/WorkOrderDays_view.asp, line 0
The code I am using is:
dim str, strSQL,rstmp
str = "<select id='mycontrol' value=''>Select status</option>"
strSQL = "SELECT Name from Owner"
set rstmp = CustomQuery(sql)
while not rstmp.eof
str = str & "<option value='" & rstmp("Name") & "'>'" & rstmp("Name") & "'</option>"
rstmp.movenext
wend
str = str & "</select>"
Response.Write str
Helpis greatly appreciated.
Thanks