Here is what it looks like in the sql inspection box in UD:

<i>SELECT *
FROM tt_tasks
WHERE uu_user_id = 'MMColParam' and tt_task_type = 'MMColParam2' and tt_task_completed = 'MMColParam3'

---------------------------------------------
MMColParam1 1 Session("MM_userName"
MMColParam2 Personal Request("MM_EmptyValue"
MMColParam3 Yes Request("MM_EmptyValue"</i>





In the access database "tt_task_completed" (MMColParam3) is a Yes/No (with yes/no as it's format).


However When trying to view a page with that particular SQl statement on it I get the following:

<i>Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/dd/tasks/tasks_archived.asp, line 40
</i>

If I remove the reference to "tt_task_completed" from the SQL statement the error no longer exists. So, I am assuming it's to do with how I am testing wether or not this value is true/false.

Any help would be greatly appreciated.