• 0

ASP Type Mismatch


Question

I'm having an issue when updating a date/time field in a MS Access Database. I've tried everything I could find on google, but I keep getting a Type Mismatch error. The date being posted is already in shortdate, ex. 05/16/2012 and the field in the database is also set to short date. I'm not sure how I can fix it.


Set RSEVENTS = Server.CreateObject("ADODB.Recordset")
RSEVENTS.Open "Announcements", Conn, 2, 2
RSEVENTS.Find "ID='" & request("postid") & "'"

RSEVENTS("Expiration") = "#" & request.form("Expiration") & "#"

RSEVENTS.update
RSEVENTS.close
set RSEVENTS = nothing
[/CODE]

[/size][/font][/color]

Link to comment
https://www.neowin.net/forum/topic/1077775-asp-type-mismatch/
Share on other sites

1 answer to this question

Recommended Posts

  • 0

You'd have to give a bit more infos about this. Type mismatch error might mean that one of your request.form requests return NULL. Could also be that the Access record you are attempting to update is the wrong type.

This topic is now closed to further replies.