need advice on Objects

Results 1 to 2 of 2

Thread: need advice on Objects

  1. #1
    Join Date
    Dec 1969
    Posts
    294

    Default need advice on Objects

    I am writing this query and I keep getting an error saying object required. This is the query:<BR><BR>SQL="SELECT username, code FROM reseller_details WHERE username=" & username_ID<BR>DbObj.Execute = SQL<BR><BR>The error I keep getting is:<BR><BR>Microsoft VBScript runtime error &#039 800a01a8&#039 <BR><BR>Object required: &#039&#039 <BR><BR>As I am very new to ASP an any one give a pointer to what is going wrong here, and explain to me about objects?<BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: need advice on Objects

    I assume dbObj is a connection object. The .Execute method of a collection object takes a SQL statement as a parameter. It is a method, not a property, so you want to do:<BR><BR>DbObj.Execute SQL<BR><BR>Does this answer your question?<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •