Results 1 to 2 of 2

Thread: help

  1. #1
    yls Guest

    Default help

    SELECT * FROM diary WHERE agencyname = &#039;ylsagency&#039; and month(dte)= 1 and year(dte) = 2001 order by dte <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>/maidsearch/diary/diary.asp, line 117 <BR>

  2. #2
    Eddie Campbell Guest

    Default RE: help

    Should work fine. Check your fieldnames, and check that the field "dte" is a Date/Time field.

Posting Permissions

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