SQL Error

Results 1 to 3 of 3

Thread: SQL Error

  1. #1
    DarkCO Guest

    Default SQL Error

    How can<BR>strsql = "SELECT * FROM tourcur WHERE Round1 = &#039;win&#039;"<BR>rs.open strsql, conn, adOpenKeySet<BR><BR>conn is an active connection, adOpenKeySet is declared from the adovbs.inc file, rs is a recordset object.<BR><BR>return the error<BR><BR>Microsoft JET Database Engine error &#039;80040e10&#039; <BR><BR>No value given for one or more required parameters <BR><BR>/update/testpage/tourn.asp, line 92 <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Error

    looks like you&#039;ve spelled a field name wrong. double check your field names<BR><BR>j

  3. #3
    Join Date
    Dec 1969

    Default Also....

    Make sure that adovbs.inc has been properly included.

Posting Permissions

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