Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 19th, 2006, 10:07 AM
Registered User
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Object Required Error when using MoveNext

Hello To All,

I am experiencing a problem when using the movenext command to populate a drop down. I receive the following error:

Microsoft VBScript runtime error '800a01a8'
Object required: ''

The error occurs at the movenext command. Here is my code:

Response.Write "<td><select size='1' name='ServiceTagID'><option></option>"
While Not rstServiceTag.EOF
Response.Write "<option value=" & rstServiceTag("ServiceTag") & ">" & rstServiceTag("ServiceTag") & "</option>"
rstEmployee.MoveNext
WEnd
Response.Write "</select></td>"

Now I read on the internet that if your current record is your last record the movenext command will give you an error. In my case, most times this drop down will only have one option (making the current record the last record). The reason I use a drop down is because on occasion depending on the previous input there may be more than one service tag.

Any suggestions on how I can fix this?

Thanks.




 
Old July 19th, 2006, 10:56 AM
Registered User
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ok, stupid mistake... I used rstEmployee in the movenext instead of rstServiceTag.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Object Required Error JeffGirard Access 5 October 2nd, 2009 08:09 AM
Object Required error voyeur Javascript 9 January 25th, 2008 11:50 AM
Object required: 'rs' error hastikeyvan Classic ASP Basics 3 March 14th, 2006 07:34 AM
Object required error ?? hman SQL Server ASP 11 June 21st, 2004 10:59 AM
error....Object required: '' sassenach Classic ASP Databases 2 August 4th, 2003 03:27 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.