On Dec 3, 11:13 am, oscar widjaya <[email protected]> wrote: > It's for mysql > it still does not work. I tried it with the following sql statement > "SELECT * FROM project_project WHERE start_date LIKE '%s'" % '2010%%'
Well, I assume that the double % at the end of your query is unintentional, as I don't think it should be there, but I'm not an sql guru. I just know that when I was having to craft some custom sql a couple of months ago (using Postgres) I had to toy with the formatting a bit to get it working. I also had to make sure I passed everything as a str, and not unicode. Maybe someone else how knows sql better will come along. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. 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.
