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 -~----------~----~----~----~------~----~------~--~---
