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 .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from gotoh. Next status will be '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.