Rajesh D,

That would be much simpler,  but this is a pre-existing database of
call records. thanks

On Jun 30, 9:35 am, Rajesh Dhawan <[EMAIL PROTECTED]> wrote:
> Hi Mike,
>
> >    I am working on a django that querys long distance numbers from a
> > mysql database. I am currently using the django API, that goes
> > something like this.
>
> > long_distance =
> > Call.objects.filter(dest_num__startswith='1').filter(dest_num__gt=6).exclud­e(dest_num__startswith='18').exclude(dest_num__startswith='1281').exclude(d­est_num__startswith='1832').exclude(dest_num__startswith='1713')
>
> > I was hoping to consolidate all of my .filter excludes into one regex.
> > is this possible and would it be more efficient? Basically any number
> > that doesnt start with 281,713,832 or 1281,1713,or 1832 is long
> > distance any help would be appreciated.
>
> If you have the ability to change your Call model, you should consider
> adding a new BooleanField called "is_long_distance" to Call. Then, you
> only have to compute it (in Call.save()) when you save or change a
> number. That will make your query very simple and efficient.
>
> -Rajesh D
--~--~---------~--~----~------------~-------~--~----~
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