This topic is locked

Asprunner 9.1 : error ADODB.Recordset error '800a0bb9'

1/4/2016 12:18:24 AM
ASPRunnerPro General questions
H
hlgarza author

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

admin 1/4/2016

Your code looks correct. It's a bit strange though as this code is designed to work on the List page while you getting error message on the view page.
Anyway, to troubleshoot something like this we need to have access to the source code. You can publish your application to Demo Account and open a ticket sending us the URL of your application on Demo Account server where we can see and troubleshoot this issue. 'Demo Account' button can be found on the last screen in the software, the one you see after the build.
We would also need instructions on reproducing this issue on Demo Account i.e. how to logon, where to go after that etc.