Re: Hebrew in Raw Query Like Clause

On Friday, July 8, 2016 at 8:34:00 AM UTC-5, Michal Petrucha wrote:

I may be wrong, but it seems to me that you're using wrong quoting in
that raw query; I think it should be::

    select sortkey, book, chapter, verse, hebrew_text
    from bible_bible
    where hebrew_text like '%%' || %s || '%%'

The DBAPI will already take care of the proper quoting for the string
argument, you just need to properly concatenate it with percent signs
on both sides.

Michal,

You're a genius! That did it. Thank you.

    -- Art Z. 

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/1c749501-45a6-4884-8859-2e2a62515695%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.