hi. I need help with this simple setup. i need to get a list of
announcements where active =1 and the discontinueDate is either null OR
less than NOW. There are two issues:
1) the filter doesn't work
2) numannouncements always equals 1 even when nothing is returned....
any ideas?
*
model:*
active_choices=(
(1,"Yes"),
(0,"No"),
)
class Announcement (models.Model):
Id = models.AutoField (primary_key=True)
adminTag = models.CharField (max_length=50, blank=False,
db_index=True,help_text=_("Shows in Admin for quick reference."))
active = models.IntegerField(blank=False, choices=active_choices)
synopsis = models.TextField (blank=False,
max_length=2000,help_text=_("Appears on sermon audio page."))
announcementDate = models.DateField(blank=False)
discontinueDate = models.DateField(blank=True)
class AnnouncementAdmin(admin.ModelAdmin):
list_display =
('adminTag','announcementDate','discontinueDate','active')
search_fields = ['adminTag','synopsis']
admin.site.register(Announcement,AnnouncementAdmin)
*view:*
def getAnnouncements (request):
dateNow = datetime.datetime.now().strftime("%Y-%m-%d")
try:
tms =
Announcement.objects.filter(active__exact=1).filter(discontinueDate__lt=dateNow).order_by('announcementDate')
numannouncements = Announcement.objects.count()
except:
tms = ''
numannouncements = 0
assert False, tms.active
return render_to_response('announcements/listpage.html',{'tms':
tms,'numannouncements':numannouncements},
context_instance=RequestContext(request))
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.
