More data type mismatch in criteria expression
In querying by date range I was having the old familiar dtmice errors popping up and ran across the fix here. Here's the finished code:


<cfquery name="Recordset2" datasource="Database">
SELECT *
FROM Query_DOGInjectorsDetail
WHERE TodayDate BETWEEN #createODBCDate(form.startdate)# AND #createODBCDate(form.enddate)#
</cfquery>

and here's a query of this query:

<cfquery name ="Recordset1" dbtype="query">
SELECT *
FROM Recordset2
WHERE Injector = '#Form.injector#'</cfquery>

Archives