On 9/2/05, Milton <[EMAIL PROTECTED]> wrote: > Is it possible to do the following using the DB API or would I be > better off running a manual sql query? from the docs it appears you can > only do AND queries? > > select * from table where col='value' or col='value2' > > It's a simplified example. My goal is to be able to do keyword matching > using "contains" across currently active stories in the database.
There is a way to do "or" searches, but it's not elegant enough, so we haven't documented it (on purpose). But there's been a patch submitted for elegant OR support in the API, and I've been meaning to integrate that. Check it out here: http://code.djangoproject.com/ticket/251 Adrian -- Adrian Holovaty holovaty.com | djangoproject.com | chicagocrime.org
