I downgraded the Cake install to version 1.1.16.5421 and the problem has vanished. So it looks more like it might be a bug in the newer version.
Regards, Langdon Langdon Stevenson wrote: > Hi > > I have just updated a project to the latest release of Cake 1.x > (1.1.17.5612 direct from SVN). I am now getting the following hideous > errors from any query attempts on models: > > > Warning: mssql_query(): Query failed in > c:\inetpub\wwwroot\cake\libs\model\dbo\dbo_mssql.php on line 163 > > Query: SELECT [User.[PID AS [User__0, [User.[Surname AS [User__1, > [User.[FName AS [User__2, [User.[ONames AS [User__3, [User.[DLNO AS > [User__4, [User.[EmpOrg AS [User__5, [User.[EmpOrgPhNo AS [User__6, > [User.[Mob AS [User__7, [User.[Email AS [User__8, [User.[Onsite Contact > AS [User__9, [User.[Pic AS [User__10, [User.[Status AS [User__11, > [User.[PID AS [User__12, [User.[PID AS [User__21 FROM [tblNames AS [User > WHERE 1 = 1 > > > It appears that the table and field names are not being bracketed > correctly, with the ] being left off. > > This is Cake 1.1.17.5612 running on Win2K and IIS with MS SQL Sever 2000 > > > 1. Has anyone else seen this error? I still don't know if it is > something weird with my test server, or a bug in Cake. I have had other > strange problems with the database connection breaking and requiring a > restart of IIS for no known reason today, so I am open to options > > 2. I have no idea how the SQL code is built up in this case, so if > anyone can point me to the right place to start digging to debug I would > be grateful > > > I will now try to downgrade Cake to an older version and see if the > problem goes away. > > Any input or assistance would really be appreciated. > > Regards, > Langdon > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
