Re: how to exclude DateTime that are None

[Brian Neal]

On Nov 2, 3:44 pm, Felipe Reyes  wrote:
> Hi everybody,
>
> I'm using django 0.96, one of my models has a DateTimeField, I'm
> trying to exclude the from the queryset the rows that have null in the
> datetimefield, I'm using something like this:
>
> MyObject.objects.exclude(somedatecol=None)

I think you want the isnull field lookup:
http://docs.djangoproject.com/en/dev/ref/models/querysets/#isnull

Best,
BN
--~--~-~--~~~---~--~~
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 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---

how to exclude DateTime that are None

[Felipe Reyes]

Hi everybody,

I'm using django 0.96, one of my models has a DateTimeField, I'm
trying to exclude the from the queryset the rows that have null in the
datetimefield, I'm using something like this:

MyObject.objects.exclude(somedatecol=None)

that line gave me the following error

DataError: invalid input syntax for type timestamp with time zone: "None"


does somebody have some clue?

the database engine is a postgresql 8.3 using psycopg2 connector

thanks in advance

regards,

--~--~-~--~~~---~--~~
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 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---