Daniel Donath
|
Posted: 03/12/2003, 10:44 AM |
|
Hi there,
Im trying to pass a date type data to another form, and the browser returns
the following error:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/Common.asp, line 34
The common.asp file contains:
'-------------------------------
' Convert value for use with SQL statament
'-------------------------------
Function ToSQL(Value, sType)
Dim Param : Param = Value
if Param = "" then
ToSQL = "Null"
else
if sType = "Number" then
ToSQL = replace(CDbl(Param), ",", ".")
else
ToSQL = "'" & Replace(Param, "'", "''") & "'"
end if
end if
end function
Any ideas how the "date" type should be set? Or the error is somewhere else?
Thanks.
|
|
|
|