I'm using Django 1.0 with django-pyodbc SVN and MS SQL Server.
I have a model with a field of type TextField. When I try searching
(on a different field) for items of this model in the admin, I get the
following error:
ProgrammingError at /admin/llreg/propertycontact/
('42000', '[42000] [FreeTDS][SQL Server]The text, ntext, or image data
type cannot be selected as DISTINCT. (8163) (SQLPrepare)')
Changing the type to CharField makes it work (likewise, so does
changing the type in the DB from ntext to nvarchar). Furthermore,
using sqlite works.
Maybe it should be noted that the aforementioned field is not one of
the ones listed in the admin, and thus probably doesn't need to be in
the SQL query at all.
Thanks for any help.
--
Michael J. Korman
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
