I am using sqlite as my development server, and as my production
server. On both I am running the
0.97-pre-SVN-7409 version of Django. I have a query that works in
development, but not on production.
The query is:
words=Word.objects.filter(title__iregex=r'^[xyz]$+').order_by('-
length', 'title')
In development, it returns a list of words that are made up only of
the letters z, y, or x and sorts them by length then by title
If I switch the query to
words=Word.objects.filter(title='zzz'').order_by('-length', 'title')
it returns a list of words. Well, two words, both being zzz.
On production, anytime I try to use iregex, or regex, I get the
following error:
Exception Type: OperationalError
Exception Value: user-defined function raised exception
Also, when I test it on the development server, meaning I go into
python shell using manage.py shell and import my function, it returns
the list of words like it's supposed to.
I have no idea what I'm missing. If you can point me in the right
direction, I'd greatly appreciate it.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" 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/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---