In trying to do some custom SQLto search for words (so "Three" but
not "Threesome")
... but because the call adds quotes.. I have had to do this...
for word in words:
sql = """select count(*) from myapp_product WHERE title
LIKE (%s)
AND title RLIKE %s """
word1 = '%%%s%%' % word
word2 = '[[:<:]]%s[[:>:]]'% word
cursor.execute(sql, [word1, word2])
So that the params get quoted up nicely with the necessary sql...
very ungainly...
It would be nice if there was a way to use custom sql without having
to pass params to it.
thanks
tom
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---
