hi, at my workplace, we are using MSSQL server. I have never used cakephp with MSSQL before and this the first time I am using. I am using CakePHP 1.2 on PHP 5.1. Although, I am able to connect to database, I am not able query the data. The search query created by the mssql_dbo.php looks funny and wrong..here is a sample search query
SELECT [Workspace].[id] AS [Workspace__id] AS [Workspace]__[id] AS [Workspace__id] AS [Workspace]__[id] AS [Workspace__id] AS [Workspace]__[id] AS [Workspace__id], [Workspace].[title] AS [Workspace__title] AS [Workspace]__[title] AS [Workspace__title] AS [Workspace]__[title] AS [Workspace__title] AS [Workspace]__[title] AS [Workspace__title], [UsersWorkspace].[role] AS [UsersWorkspace__role] AS [UsersWorkspace]__[role] AS [UsersWorkspace__role] AS [UsersWorkspace]__[role] AS [UsersWorkspace__role] AS [UsersWorkspace]__[role] AS [UsersWorkspace__role], [Workspace].[id] AS [Workspace__id] AS [Workspace]__[id] AS [Workspace__id], [Workspace].[id] AS [Workspace__id] FROM [srs_workspaces] AS [Workspace] WHERE [UsersWorkspace].[user_id] = '2' There are two problems 1. all the fields are getting repeated 2. Association is not working.. Is there other way to get MSSQL working with CakePHP --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
