[Trac-dev] Question regarding sql_escape_percent

Hi all,

I have a small issue with the use of the function sql_escape_percent
in db/util.py.

This kind of escaping percent signs prevents the use of SQL functions
that use custom format strings,
e.g. in MySQL

from_unixtime(m.due, '%d.%m.%Y')

as the percent signs are also replaced in the format string. Currently
I have a workaround using the get_format
function of MySQL, but this function doesn't allow custom format
strings.

My question is, why replace the percent signs at all ?

-- Max

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Development" group.
To post to this group, send email to trac-dev <at> googlegroups.com
To unsubscribe from this group, send email to trac-dev-unsubscribe <at> googlegroups.com
For more options, visit this group at http://groups.google.com/group/trac-dev?hl=en
-~----------~----~----~----~------~----~------~--~---