Scenario: Query grabs user data from MySQL 5 database using the built in MySQL 4/5 driver in ColdFusion 8 on a Windows 2003 Server. Problem: Cannot convert value ’0000-00-00 00:00:00′ from column 10 to TIMESTAMP error returned on execution. Analysis: After a quick search on Google, it appears that the default behaviour for [...]
Categories
- General (30)
- Talking (10)
- Thinking (66)
- Apple (2)
- Browsers (5)
- Business (19)
- Databases (6)
- MySQL (3)
- SQL Server (1)
- Design (3)
- E-commerce (4)
- Marketing (3)
- Mobile (2)
- Networking (2)
- Programming (32)
- ColdFusion (26)
- Java (1)
- Javascript (6)
- PHP (6)
- Ruby (1)
- Web 2.0 (4)
- Web Servers (4)
- Windows (12)
- Walking (1)
Archives
- March 2012 (3)
- January 2012 (1)
- July 2011 (1)
- May 2011 (1)
- April 2011 (3)
- September 2010 (2)
- July 2010 (1)
- June 2010 (1)
- March 2010 (1)
- February 2010 (1)
- January 2010 (13)
- December 2009 (3)
- July 2009 (2)
- June 2009 (1)
- May 2009 (1)
- April 2009 (8)
- March 2009 (6)
- February 2009 (15)
- January 2009 (4)
- December 2008 (3)
- November 2008 (2)
- September 2008 (2)
- August 2008 (2)
- November 2007 (2)
- September 2007 (1)
- April 2007 (5)