var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Data type mismatch in criteria expresioin
Hi again, I'm having problems with an insert record page to insert records into a msaccess database via sql and dreamweaver mx.asp pages.
There are four date fields that can be entered (all not required), but it keep getting the
ERROR;Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
from my documentation there seems to be a known problem with msaccess and update/insert server behaviours.....
Has anyone managed to overcome this issue, and if so, how ??
thanks for your help....
Re: Data type mismatch in criteria expresioin
That may be because of the Date format on the access database.
Try to insert the date in this format:
thanks heaps...I actually got it sorted about 20 minutes before I read your reply...and you were right....I had the msaccess date formats set to an input mask that I don't think dreamweaver took a liking to...