Error with Database, HELP!

Results 1 to 3 of 3

Thread: Error with Database, HELP!

  1. #1
    Marianne Guest

    Default Error with Database, HELP!

    I got an error when I try running my asp. Here is the error.<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e10&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. <BR><BR>/AddBook1.asp, line 22 <BR><BR>I am using Access. This is what I have on my page.<BR>-------------<BR>Dim rsBook <BR> <BR>strSQL = "SELECT * FROM Court WHERE ddate = #" & FormatDateTime(bookdate,2) & "#; " <BR><BR>Set rsBook = Server.CreateObject("ADODB.Recordset") <BR><BR>rsBook.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic, adCmdText<BR><BR>--------<BR>What is wrong? Pls help!!!

  2. #2
    Join Date
    Dec 1969

    Default check field names ..

    the error means, that there is a field name misspelt, or non-existant. check field names. and might as well check, date delimiters. in access single quote will do. &#039" & mDate & "&#039

  3. #3
    Marianne Guest

    Default Pls HELP AGAIN!

    I thought Access uses # sign? can u see what is wrong with this query statement? i can&#039t seems to get the row where the date exist. Pls help!!!<BR><BR>strSQL = "SELECT * FROM Court WHERE ddate = #" & firstDate & "#;" <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