[Sguil-devel] SguildPadsLib.tcl errors when 'application' contains single quote

[John Curry]

All,

I've added the following lines to SguildPadsLib.tcl (near line 34)
to 'escape' the single quote character (using SQL syntax.).

set app [lindex $dataList 11]
set intTime [lindex $dataList 12]
+ set searchPat '
+ set replacePat `'
+ set inString $app
+ regsub -nocase -- $searchPat $inString $replacePat app

Another option could be to remove the single quote.

-John Curry

[John Curry]

I'm still seeing errors with this fix. The resulting escaped quote (`') does
not appear to work with mysql as I expected. I've settled on replacing any
single-quote with a period.

set app [lindex $dataList 11]
set intTime [lindex $dataList 12]
+ set searchPat '
+ set replacePat .
+ set inString $app
+ regsub -nocase -- $searchPat $inString $replacePat app

-John Curry

Post by John Curry
All,
I've added the following lines to SguildPadsLib.tcl (near line 34)
to 'escape' the single quote character (using SQL syntax.).
set app [lindex $dataList 11]
set intTime [lindex $dataList 12]
+ set searchPat '
+ set replacePat `'
+ set inString $app
+ regsub -nocase -- $searchPat $inString $replacePat app
Another option could be to remove the single quote.
-John Curry
---------------------------------------------------------------------------
--- Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Sguil-devel mailing list
https://lists.sourceforge.net/lists/listinfo/sguil-devel