2009/10/27 Markus Törnqvist <[email protected]>:
> Hi!
Well, you can inore my previous email :)
> Creating cursor 501
> Creating cursor 5
> adonet2dbapi: executing 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
> WHERE TABLE_TYPE = 'BASE TABLE' UNION SELECT TABLE_NAME FROM
> INFORMATION_SCHEMA.VIEWS' with '()'
> Creating cursor 303
> adonet2dbapi: executing 'SELECT [django_content_type].[id],
> [django_content_type].[name], [django_content_type].[app_label],
> [django_content_type].[model] FROM [django_content_type] WHERE
> ([django_content_type].[model] = %s AND [django_content_type].[app_label] =
> %s ) ORDER BY [django_content_type].[name] ASC' with '('permission', 'auth')'
>
> Environment Error: System.Data.SqlClient.SqlException: Incorrect syntax near
> 's'.
It's the %s parameter markers that Django uses; they need to be
converted to whatever SQL Server uses (Vernon would probably know
better then me). The easiest way is query % params; building the
params tuple is the hard part. It's been a while since I looked at the
mssql.py code, so I don't remember the details.
- Jeff
_______________________________________________
Users mailing list
[email protected]
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
