problem with recordset (i think)

Results 1 to 3 of 3

Thread: problem with recordset (i think)

  1. #1
    adr Guest

    Default problem with recordset (i think)

    Hi,<BR><BR>I&#039;m getting this error below. I&#039;m testing out a dependant list script from<BR><BR>ADODB.Recordset error &#039;800a0bb9&#039; <BR>The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. <BR>/cars3.asp, line 8 <BR><BR>Heres a small snippet of my code.<BR> Set rsX = Server.CreateObject("ADODB.Recordset")<BR> sQuery = "SELECT Manufacturers.Name, Cars.Model, " & _<BR> "Manufacturers.ID AS ManuID, Cars.ID AS ModelID " & _<BR> "FROM Cars INNER JOIN Manufacturers " & _<BR> "ON Cars.Manufacturer = Manufacturers.ID " & _<BR> "ORDER BY Manufacturers.Name, Cars.Model"<BR> rsX.Open sQuery, objConn, adOpenForwardOnly, _<BR> adLockReadOnly, adCmdText<BR><BR>The problem is with the last line.<BR>any ides?<BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: problem with recordset (i think)

    check if you have declared and opened objConn on that page

  3. #3
    Join Date
    Dec 1969

    Default RE: problem with recordset (i think)

    Did you remember to include

Posting Permissions

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