Okay, I am simply trying to add an aro at this point using the command: $aro->create(8, null, '[EMAIL PROTECTED]');
and I get the following error: Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'MAX(rght) as rght'. (severity 16) in C:\apache\cake\cake\libs \model\dbo\dbo_mssql.php on line 171 Warning: mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server. (severity 5) in C:\apache \cake\cake\libs\model\dbo\dbo_mssql.php on line 171 Warning: mssql_query() [function.mssql-query]: Query failed in C: \apache\cake\cake\libs\model\dbo\dbo_mssql.php on line 171 Notice: Undefined offset: 0 in C:\apache\cake\cake\libs\controller \components\dbacl\models\aclnode.php on line 76 Upon doing some simple traces I found that it's a problem with the following SQL query: SELECT TOP 1 [Aro].[MAX(rght) as rght] AS [Aro__0] FROM [aros] AS [Aro] WHERE 1 = 1 which should be (I think) SELECT TOP 1 MAX([Aro].[rght]) AS [Aro__0] FROM [aros] AS [Aro] WHERE 1 = 1 How would I go about fixing this? Thanks all! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
