>
> can you try my test script with an MS-SQL database and see what you
> get ?
>
>
Works with no errors, column names quoted with square brackets.
Here's the echo output:
2008-03-26 15:11:41,342 INFO sqlalchemy.engine.base.Engine.0x..d4
CREATE TABLE [some table] (
[primary col] INTEGER NOT NULL IDENTITY(1,1),
[the data] VARCHAR(50),
PRIMARY KEY ([primary col])
)
2008-03-26 15:11:41,343 INFO sqlalchemy.engine.base.Engine.0x..d4 {}
2008-03-26 15:11:42,139 INFO sqlalchemy.engine.base.Engine.0x..d4 COMMIT
2008-03-26 15:11:42,397 INFO sqlalchemy.engine.base.Engine.0x..d4 BEGIN
2008-03-26 15:11:42,408 INFO sqlalchemy.engine.base.Engine.0x..d4 INSERT
INTO [some table] ([the data]) VALUES (%(data)s)
2008-03-26 15:11:42,408 INFO sqlalchemy.engine.base.Engine.0x..d4 {'data':
'some data'}
2008-03-26 15:11:42,459 INFO sqlalchemy.engine.base.Engine.0x..d4 COMMIT
2008-03-26 15:11:42,472 INFO sqlalchemy.engine.base.Engine.0x..d4 SELECT TOP
2 [some table].[primary col] AS [some table_primary col], [some table].[the
data] AS [some table_the data]
FROM [some table]
WHERE [some table].[primary col] = %(some table_primary col_1)s ORDER BY
[some table].[primary col]
2008-03-26 15:11:42,473 INFO sqlalchemy.engine.base.Engine.0x..d4 {'some
table_primary col_1': 1}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
