Simple DB query
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=26588
Printed Date: 29 March 2026 at 7:40pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Simple DB query
Posted By: freakdaddy
Subject: Simple DB query
Date Posted: 26 November 2008 at 9:19pm
|
Going nuts here, and can't figure out why I keep getting: Microsoft VBScript runtime error '800a01a8' Object required: '' From this pretty straight forward query: strSQL = "SELECT " & strDbTable & "Configuration.Cam " & _ "FROM " & strDbTable & "Configuration" & strDBNoLock & " " & _ "WHERE " & strDbTable & "Configuration.ID = 1;" 'Query the database rsCommon.Open strSQL, adoCon The table exists. Is there something else I'm missing that could be the problem? Thanks much for the help. |
Replies:
Posted By: MadDog
Date Posted: 27 November 2008 at 4:54am
|
Your trying to use rsCommon and/or adoCon when they recordset/connection has been closed.
------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: freakdaddy
Date Posted: 28 November 2008 at 7:42am
| Thanks for your help. |