Question
Database Timestamp Conversion Error
Hello,
I am trying to apply a simple timestamp on a form submit to the DB which is then returned as a part of the post ... pretty common, eh? 😃 However, It will not work because of the following Error:
Error Executing Database Query.
Cannot convert value '0000-00-00 00:00:00' from column 2 to TIMESTAMP
I am a:
-Novice CF User
-Newbie MySql User
The ver of MySql:
# Server version: 4.1.22-max-log
# MySQL client version: 5.0.27
# Protocol version: 10
# Server: (XVXVXVXV) via TCP/IP
All of my other queries function flawlessly, so the DSN from the CFML to the MySql DB is accurate.
It is a simple connection through a commercial hosting provider.
I have no clue how to even begin a more complex manual Java connection.
Any help is appreciated.
Thanks!
I am trying to apply a simple timestamp on a form submit to the DB which is then returned as a part of the post ... pretty common, eh? 😃 However, It will not work because of the following Error:
Error Executing Database Query.
Cannot convert value '0000-00-00 00:00:00' from column 2 to TIMESTAMP
I am a:
-Novice CF User
-Newbie MySql User
The ver of MySql:
# Server version: 4.1.22-max-log
# MySQL client version: 5.0.27
# Protocol version: 10
# Server: (XVXVXVXV) via TCP/IP
All of my other queries function flawlessly, so the DSN from the CFML to the MySql DB is accurate.
It is a simple connection through a commercial hosting provider.
I have no clue how to even begin a more complex manual Java connection.
Any help is appreciated.
Thanks!
AdChoices