Hello Everyone;
I'm using an MS Access DB on a CFMX (CF 6) site...and updating records in a db
from a form ..the CFM for code looks like :
<cfquery name="ProjectTable" datasource="caproject">
UPDATE CAprojectDB
SET CaClientNum = '#Form.CaClientNum#',
DateAdded = '#Form.DateAdded#',
CaJobNum = #Form.CaJobNum#,
QntyOrdered = #Form.QntyOrdered#,
DieCut = '#Form.diecut#',
OnHold = '#Form.OnHold#',
ProjDueDate = '#Form.ProjDueDate#',
UpdateDate = '#Form.UpdateDate#',
notes = '#Form.notes#',
Size = '#Form.Size#',
ArtIntoCp = '#Form.ArtIntoCp#'
WHERE ProjectID = #Form.ID#
</cfquery>
However, when the form is submitted and some of the fields are emtpy I get a
"Data type mismatch in criteria expression. " error. I've tried adding ...
Bookmarks