sybrenUSE at YOURthirdtower.com.imagination
Mon Sep 25 11:10:21 CEST 2006
Lawrence D'Oliveiro enlightened us with:
>> Wouldn't this be a whole lot better?
>> "select * from details where person_name like ?",
>> '%' + name + '%'
> No. Can you figure out why?
Ok, should have tested it better. This works fine on my machine,
"select * from details where person_name like ?",
('%' + name + '%', )
Including all sorts of quotes, newlines, backslashes etc. in the name.
StÃ¼vel IT - http://www.stuvel.eu/
More information about the Python-list