I’m using an ASP to search data from MS Access 2000 and another ASP to display results.

When searching a get this error.

Syntax error in date in query expression ‘dtDate Between #1# and #1#’

Any ideas??

Here’s the SQL in the results page.

<%

Dim Recordset1__MMColParam

Recordset1__MMColParam = "1"

If (Request.QueryString("FromField") <> "") Then

  Recordset1__MMColParam = Request.QueryString("FromField")

End If

%>

<%

Dim Recordset1__MMColParam2

Recordset1__MMColParam2 = "1"

If (Request.QueryString("ToField") <> "") Then

  Recordset1__MMColParam2 = Request.QueryString("ToField")

End If

%>

<%

Dim Recordset1

Dim Recordset1_numRows



Set Recordset1 = Server.CreateObject("ADODB.Recordset")

Recordset1.ActiveConnection = MM_Comments_STRING

Recordset1.Source = "SELECT dtDate, dtTime, Comments FROM tblComments WHERE dtDate Between #" + Replace(Recordset1__MMColParam, "#", "##") + "# and #" + Replace(Recordset1__MMColParam2, "#", "##") + "# ORDER BY dtTime ASC"

Recordset1.CursorType = 0

Recordset1.CursorLocation = 2

Recordset1.LockType = 1

Recordset1.Open()



Recordset1_numRows = 0

%>



Thanks,

Hi

..because Dreamweaver set of default value 1 always ! but 1 is not date !!

Recordset1__MMColParam = "02/01/2006"


Recordset1__MMColParam2 = "02/12/2006"

When searching a get this error if you don't pass parameter !.


Steweb




I don’t Speak English very well, excuse me !

www.steweb.net

The end user will enter the start and end dates on a search page. I can't just put the dates in the code. The code should pull the dates from the search fields on the search page. If the default value for the date cannot be 1 then what should I use?

Thanks,:)

If you can't put the dates you must condition your code !

  search only if user pass parameter !

If request.querystring("submit")<> "" Then

Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.QueryString("FromField") <> "") Then
..
..
ecc

end if

Steweb





I don’t Speak English very well, excuse me !

www.steweb.net

Thanks.