DeveloperBarn Forums

DeveloperBarn

Programming & IT forum

Object Required?!?!?

This is a discussion on Object Required?!?!? within the ASP Development forums, part of the Programming & Scripting category; BLaaaarche gave me some code iin another post. The code is this: strSQL = "Select memberid, membername from members" Set ...

Go Back   DeveloperBarn Forums > Programming & Scripting > ASP Development

  #1  
Old March 20th, 2008, 12:41 PM
Barn Newbie
 
Join Date: Mar 2008
Posts: 3
Rep Power: 2
jarvelous is an unknown quantity at this point
Exclamation Object Required?!?!?

BLaaaarche gave me some code iin another post. The code is this:

strSQL = "Select memberid, membername from members"
Set objRS = siteConn.Execute(strSQL)

I am getting an error.

ASP Error occurred 3/20/2008 9:38:17 AM in Microsoft VBScript runtime
Error number: -2146827864 (0x800A01A8)
File: /test/Default.asp, line 3
Object required: 'siteConn'

Can anyone please explain to me what this is? I am new to ASP, please bare with me!!!!!!

Last edited by richyrich; May 6th, 2008 at 11:19 AM.
  #2  
Old March 20th, 2008, 12:43 PM
jmurrayhead's Avatar
The Barnfather
 
Join Date: Mar 2008
Real name: Jason
Location: Washington, D.C.
Posts: 1,964
Blog Entries: 8
Rep Power: 15
jmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud of
Default

You have to define what siteConn is:
Code:
Set siteConn = Server.CreateObject("ADODB.Connection")
strSQL = "Select memberid, membername from members"
Set objRS = siteConn.Execute(strSQL)

Comments on this post
jarvelous agrees:
__________________
jmurrayhead
If you agree with me... click the icon!
If my post solved your problem, click the button in the lower right-hand corner of the post.

If you like it here...throw us a few bones to help
support us.

Join our Folding team: DeveloperBarn Folding

  #3  
Old March 20th, 2008, 12:46 PM
Barn Newbie
 
Join Date: Mar 2008
Posts: 3
Rep Power: 2
jarvelous is an unknown quantity at this point
Default

got it thanks.
Closed Thread

  DeveloperBarn Forums > Programming & Scripting > ASP Development

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 11:18 PM.


Copyright ©2008-2010, DeveloperBarn

Content Relevant URLs by vBSEO 3.3.2