what does this error mean?

Results 1 to 2 of 2

Thread: what does this error mean?

  1. #1
    minni Guest

    Default what does this error mean?

    Response object error &#039ASP 0185 : 8002000e&#039 <BR><BR>Missing Default Property <BR><BR>? <BR><BR>A default property was not found for the object. <BR><BR>I have the following code<BR>Set RSContact = Conn.Execute("Select Customers.Customer_ID,Customer_Contacts.Title from Customers,Customer_Contacts where "_<BR> & " Customers.customer_ID =Customer_Contacts.Customer_ID AND Customer_Contacts.customer_ID = "&Request.QueryString("CustID")&"")<BR><BR>***Plea se help me!!

  2. #2
    Join Date
    Dec 1969

    Default RE: what does this error mean?

    Did you *really* cut and paste your code *directly* from the non-working page?<BR><BR>That error is often seen when you omit a needed "Set". If you had left off the Set in the line you are showing, that could be the bug.<BR><BR>Other than that....DEBUG.<BR><BR>Change to:<BR>************<BR>SQL = "Select Customers.Customer_ID,Customer_Contacts.Title " _<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& "FROM Customers,Customer_Contacts " _<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& "WHERE Customers.customer_ID =Customer_Contacts.Customer_ID " _<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& "AND Customer_Contacts.customer_ID = "&Request.QueryString("CustID") )<BR><BR>Response.Write "SQL is: " & SQL & "&LT;BR&#062;" & vbNewLine<BR><BR>Set RSContact = Conn.Execute(SQL)<BR>**************<BR><BR>At least then you will know if it is the Execute that is complaining or something in the way you build the SQL string.<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