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 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to