On Wed, Feb 11, 2009 at 8:01 AM, Bobby Roberts <tchend...@gmail.com> wrote:
> > there shouldn't be really. The client has a search form and due to > the way they want the search done there are about 40 option checkboxes > for filtering in about 5 categories. It would have been easier if a > filter with IN could have been used but the way the search logic is > setup that is not an option. An example of the sql query being used > is like this: > > > Select * from table_name where field1 like '%,BC,%' and field2='AR' > and field3 like '%,CM,%' order by date_received desc" > > > %s is not used in this statement. > > > I believe that you need to escape the % by doing %%. Alex -- "I disapprove of what you say, but I will defend to the death your right to say it." --Voltaire "The people's good is the highest law."--Cicero --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
