I've been grinding away with ACL on a project, and I'm running into what appears to be a bug with the ACL code and dbo_mssql.php. Basically inserting new aco records fail due to cake generating incorrect SQL code (it puts single quotes around a NULL, thus inserting the string "NULL", not NULL itself). I found this ticket (https://trac.cakephp.org/ticket/6024) in the trac which is basically exactly what's happening to me as well. It appears this hasn't been fixed in the latest nightly though, and I was wondering if anyone had an idea on how to apply a fix until the bug has been resolved. I also found an older reported bug that appears to be the same thing (https:// trac.cakephp.org/ticket/5381).
I've been digging in libs/model/datasources/dbo/dbo_mssql.php, and libs/model/db_acl.php, but haven't been able to see where the quotes are being applied to the NULL value. My guess is there just needs to be an extra conditional to check for a null value and not apply quotes in that case. If anyone knows where this can be resolved, that would be awesome. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---