>> Depending on the checkbox selection it might produce a sql string
>> like:
>> SELECT user_id FROM Bio WHERE (race='A' OR race='W' OR race='H') AND
>> (eye_color='B' OR eye_color='G' OR eye_color='H') AND (hair_color='W'
>> OR hair_color='B')
Though my solution would be logically about the same as this, the
resulting query would look something like
SELECT * FROM Bio WHERE race IN ('A', 'W', 'H') AND eye_color
IN ('B', 'G', 'H') AND hair_color IN ('W', 'B')
It returns the full records, not just the user_id field, though
you can use the .values() method on a recordset to pull back just
the fields you need/want. However, it may be helpful to have the
results as full-fledged Bio-model objects.
Just so you're not thrown off by the absence of OR's in my
answer. This could also be done in a more convoluted fashion
using Q() objects and operator.or_'ing them together, but that's
not quite as elegant.
-tim
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
