I ran into an issue running the LOAD DATA INFILE command from a PHP script the other day. When I logged in as ROOT and executed the script on MySQL Query Browser it worked like a charm. However, when I executed the script from PHP as another use with only SELECT, INSERT, UPDATE and DELETE [...]
Tag Archives: SQL
MySQL 5 timestamp error in ColdFusion 8
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 [...]
