We use MSSQL when working with CakePHP 1.2 here, and I've never seen
Cake output any SQL like that. Can you send some details about your
model(s), etc?
We run PHP 5.1 on Linux and connect to MSSQL using ODBTP-overrided PHP
mssql extension functions, so our database setup looks like this:
var $default = array('driver' => 'mssql',
'connect' => 'mssql_connect',
'host' => 'server',
'login' => 'user',
'password' => 'password',
'database' => 'db',
'prefix' => '');
bingo wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
