Hello Everybody!

I'm developing a routine that will control the information about scheduled
events and it will avoid that some events override others and prevent that
it cannot happen. I made a query on mysql where that works fine and gives
the results that I need. For example I have an event that begins at 05
november and ends at 22 november, it must lock the agenda to prevent another
event in this date range, so if I try to insert a new event that will hapens
on 09 november and ends at 14 november, the system will return a message
reporting that this operation cannot be done due the collision with another
event previously scheduled.

My goal is translate this query to ORM Django: select * from my_table  where
('2010-11-09' between start_date AND ends_date) or ('2010-11-14' between
start_date AND ends_date )

I've tried with range atribute but I was'n happy on this way

Someone can help?

Thanks so much!

Rogério Carrasqueira

---
e-mail: [email protected]
skype: rgcarrasqueira
MSN: [email protected]
ICQ: 50525616
Tel.: (11) 7805-0074

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

Reply via email to