[TYPO3-dev] DBAL, ADODB and MSSQL

[Karsten Dambekalns]

Hi.

Martin Kutschker wrote:
> Stefan Bothner | [m]zentrale schrieb:
>> WHERE "be_sessions"."ses_id" = 'a31b361e7ce34709eda773c98c0113e3' AND
>> "be_sessions"."ses_name" = 'be_typo_user'
>> you see, all table-cols ar set into quotes. i dont know why, if i take 
>> that
>> query directly on my MSSQL-Server i got no errors, the DBAL-Debug throws
>> errors by errors.
>>
>> Where is the problem, at T3 or at the config of the MSSQL-DB?
> 
> This is ANSI style quoting, but MSSQL only supports this when you enable 
> it. It's somewhere in the server settings (of the instance).

And I even hint on this in the DBAL manual. If people only would read 
documentation from time to time.

> Don't ask me why DBAL/ADOdb doesn't use the native suqare brackets.

There is a reason I don't remember off the top of my head.

Regards,
Karsten
-- 
Karsten Dambekalns
Gimme Five!
http://typo3.org/gimmefive