Modify

Opened 18 years ago

Closed 18 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)

Change History (1)

comment:1 Changed 18 years ago by Shun-ichi Goto

Resolution: fixed
Status: newclosed

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Shun-ichi Goto.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.