Thanks Rajesh, that worked great. I see what the problem is, which isn't related to the SQL at all. It appears that "icontains" is not behaving as expected. It's supposed to be case-insensitive, but it's doing the opposite.
Example, if I search for a WorkCategory using "print" it will return 0 results. If I use "Print" it will return all of the WorkSamples with the category of "Print" Thoughts? Brandon On Apr 9, 11:51 am, Rajesh Dhawan <[EMAIL PROTECTED]> wrote: > On Apr 9, 12:44 pm, Brandon Taylor <[EMAIL PROTECTED]> wrote: > > > Sorry, I have no idea how to make Django execute: > > > from django.db.models import Q > > from django.shortcuts import render_to_response > > from btaylor_design_v2.portfolio.models import WorkSample > > > qset = ( > > Q(title__icontains='whatever') | > > Q(client__name__icontains='whatever') > > ) > > > results = WorkSample.objects.select_related().filter(qset).distinct() > > > from the shell > > Remember that python manage.py shell drops you into a Python > interpreter shell. All valid Python syntax can be typed into such a > shell. So, in short, just type in the above lines followed by the > line: > > results > > That will print out your query set results to the screen. Then do the > following to see what SQL was actually executed by Django: > > from django.db import connection > connection.queries > > That will print out the said SQL. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
