[TYPO3-dev] DBAL, ADODB and MSSQL

[Martin Kutschker]

Stefan Bothner | [m]zentrale schrieb:
> Hi folks,
> 
> iam using DBAL and MSSQL and have following Problem. All my Query's look
> like this, for example (at Backendlogin), ist the output of my DBAL debug:
> 
> DELETE FROM "be_sessions"
> WHERE
> "ses_id" = 'a31b361e7ce34709eda773c98c0113e3' AND "ses_name" =
> 'be_typo_user'
> 
> Or like this
> 
> 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).

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

Masi