Technote Details :: Column type mismatch
Issue
When trying to submit data in a form, I get an error message saying "Data type mismatch in criteria expression."
Products: All InterAKT extensions that use database transactions.
Operating System: All.
Server Models: ASP VbScript.
Dreamweaver version: any.
Reason
This happens because some of the values used in the transaction do not match the type specified for the database columns they are inserted into.
Solution
If you want to prevent this from happening you must use client-side validation, by applying a validation rule on each field involved in the database transaction. If the value entered in the form is correct for the purpose of the database column, use the database software and change the column type.
