I cannot seem to get a date to properly insert and update into the database.
I am using a the createODBCDate( ) function. It works fine if I put in a
date but will not work if there is no date entered. It will not work
without the createODBCDate( ) function either. How do I get around this?
CODE
<CFQUERY DATASOURCE="#DSN#">
UPDATE contacts
SET
packageDate = #CreateODBCDate(Form.packageDate)#,
WHERE
contactID = #Form.ContactID#
</CFQUERY>
ERROR
An error occurred while evaluating the expression:
#CreateODBCDate(Form.packageDate)#
Error near line 24, column 17.
----------------------------------------------------------------------------
----
Parameter 1 of function CreateODBCDate which is now "" must be a date/time
value
Thanks,
Rob
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "Rob Matlow" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
