I think Django is fabulous for the admin-interface, a simple text
search and template inheritance. I will use Django for all of those.
What I'm not getting an answer to and cannot find an example of is a
complex search, where I have to retrieve data from multiple tables,
combine the data, remove the duplicates, etc between a web page and
the database. The code that started this thread is only a small piece
of the complex data retrieval I need to do. PHP is great for writing
complex SQL queries right in the HTML template and I know exactly what
it is doing.
First of all, mixing technologies without need is most of the times a
bad idea - so if it is really the case that you can't solve all of your
issues in django, you shouldn't use it at all, but solve them in PHP.
But to be honest - I doubt that django isn't capable of solving your
problem.
See
http://docs.djangoproject.com/en/dev/topics/db/queries/#topics-db-queries
for a introduction to the multitude of query-options. I doubt that your
rather simple m:n-relationship is covered there.
I myself use SQLAlchemy, and that can for sure query and filter those
relationships.
Diez
--
http://mail.python.org/mailman/listinfo/python-list
