Modify ↓
Opened 19 years ago
Closed 19 years ago
#678 closed enhancement (fixed)
dynamic variable values with single quote
| Reported by: | ot | Owned by: | Shun-ichi Goto |
|---|---|---|---|
| Priority: | normal | Component: | TicketBoxMacro |
| Severity: | normal | Keywords: | |
| Cc: | Trac Release: | 0.9 |
Description
to accept value with quote with sqlite like in
[[TicketBox([report:9?CustomerName=Tea'cl])]]
it will be nice to add the folowing line :
v = v.replace( "'","''" )
near line 92 :
# replace dynamic variables
for k, v in dv.iteritems():
v = v.replace( "'","''" )# Added line to support values with quote
sql = re.sub(r'\$%s\b' % k, v, sql)
Attachments (0)
Note: See
TracTickets for help on using
tickets.



(In [1306]) Quote single quote in dynamic variable name. Fix #678.