Archive for the ‘MySQL’ Category
cannot add a new record when scaffolding in cakephp 1.2 ?
Posted by: phpcurious on: January 18, 2008
If it happens to you that when you add a new record when scaffolding in cakephp 1.2 beta version, check if your mysql version is 5.1 or later, and check in my.ini of your mysql server and remove that “STRICT_TRANS_TABLES” setting, and then your cake scaffold will work just fine.
(source: http://groups.google.fr/group/cake-php/browse_thread/thread/a0b1a35c1909d5db )
Note: I think this [...]
comparing values of different column types in mssql and mysql
Posted by: filchiprogrammer on: September 27, 2007
I was debugging this SQL statement in MSSQL and it says
“Syntax error converting the varchar value ‘LDI ‘ to a column of data type int. “
I realized that this was due to the part where in the “Where” clause that compares the value of a char column with an integer, like for example,
[...]
Flickr Photos
|
Recent Comments