Modify

Opened 8 years ago

Closed 8 years ago

#678 closed enhancement (fixed)

dynamic variable values with single quote

Reported by: ot Owned by: gotoh
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 8 years ago by gotoh

  • Resolution set to fixed
  • Status changed from new to closed

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

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.