Can anyone help??

Results 1 to 2 of 2

Thread: Can anyone help??

  1. #1
    Crazy Heather Guest

    Default Can anyone help??

    I am starting to go a little crazy!<BR><BR>Why does:<BR><BR>rsAdmin.Open "SELECT * FROM display WHERE recno = " & 1 & " ", objAdminConn, adOpenDynamic, adLockOptimistic<BR><BR>Give me this?<BR><BR>Microsoft VBScript runtime error &#039 800a01a8&#039 <BR><BR>Object required: &#039&#039 <BR><BR>applications/lookup/admin/index.asp, line 181 <BR><BR>RecNo is an Access 2000 autonumber.<BR><BR>I don&#039t have this trouble in other SQL statements. What am I doing wrong???????????????

  2. #2
    Join Date
    Dec 1969

    Default RE: Can anyone help??

    This may not help you but is the one 1 static? or does it represent a value of a variable?<BR>if it&#039s always going to be 1...<BR><BR>rsAdmin.Open "SELECT * FROM display WHERE recno = 1"<BR>or try replacing the " " with "" or getting rid of the & " " all together?<BR><BR>hope I helped haven&#039t worked with SQL in a while...

Posting Permissions

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