Re: Anal not Analog, Analysis: DB Question

2006-10-05 Thread Tom Smith
On 4 Oct 2006, at 17:09, Andy Dustman wrote:On 10/4/06, Tom Smith <[EMAIL PROTECTED]> wrote: If I am looking for titles like "Anal Sex" or "Being Anal" then howdo I construct this, ahem, query... to not return "Analysis" or"Analog"? Two options: If your database supports it, try a full-text search:

Re: Anal not Analog, Analysis: DB Question

2006-10-05 Thread Tom Smith
Well funnily enough, not that ... :-)It's just a usability thing that if you search for "anal".. you will not have in mind any of these... A Towpath Walks in Oxford: The Canal and River Thames Between Wolvercote and the City El Ventanal / The Wide Window (Series Of Unfortunate Events (Spanish))    

Re: Anal not Analog, Analysis: DB Question

2006-10-04 Thread Andy Dustman
On 10/4/06, Tom Smith <[EMAIL PROTECTED]> wrote: > > If I am looking for titles like "Anal Sex" or "Being Anal" then how > do I construct this, ahem, query... to not return "Analysis" or > "Analog"? Two options: If your database supports it, try a full-text search: object_list = Products.objects

Re: Anal not Analog, Analysis: DB Question

2006-10-04 Thread John DeRosa
heh. so do we get to guess what your django-based site is about? Tom Smith wrote: > If I am looking for titles like "Anal Sex" or "Being Anal" then how > do I construct this, ahem, query... to not return "Analysis" or > "Analog"? > > I tried adding spaces to the end of the word but it doesn

Anal not Analog, Analysis: DB Question

2006-10-04 Thread Tom Smith
If I am looking for titles like "Anal Sex" or "Being Anal" then how do I construct this, ahem, query... to not return "Analysis" or "Analog"? I tried adding spaces to the end of the word but it doesn't seem to help... object_list = Product.objects.filter( Q(title__contains=word + " ")| Q