Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


dama
  •  dama
  • Paid support Topic Starter
2016-09-05T08:20:41Z
Hi,

For mysql you will need to escape special characters.
Would be great if this could be done with a function in visualcron instead of using the string(Replace) for each character.
So we can just do for example {String(Escape | SomeString)} and the variable will escaping correctly for the database.
See also some references for mysql escaping.

Ref: http://dev.mysql.com/doc.../en/string-literals.html 

Table 10.1 Special Character Escape Sequences

Escape Sequence Character Represented by Sequence
\0 An ASCII NUL (X'00') character
\' A single quote (“'”) character
\" A double quote (“"”) character
\b A backspace character
\n A newline (linefeed) character
\r A carriage return character
\t A tab character
\Z ASCII 26 (Control+Z); see note following the table
\\ A backslash (“\”) character
\% A “%” character; see note following the table
\_ A “_” character; see note following the table
Sponsor
Forum information
Scroll to Top