Hi
I need to run an sql query and i have defined a sensu check for it.
But In the sql query I need to pass Double Quotes, but sensu is not allowing to pass the Double Quotes in command
SELECT COUNT(*) FROM xxxxxxx WHERE STATUS IN ("‘D’","‘N’","‘S’","‘I’")
My above query requries double quotes and a single quote as follows by sensu command is not allowing these quotes.("‘D’","‘N’","‘S’","‘I’")
How to overcome the issue.
Can some one help me to figureout the issue.
Have you tried escaping the quotes by putting a \ before them?
On Tuesday, 16 August 2016 11:13:40 UTC+1, IMRAN SHAIK wrote:
Hi
I need to run an sql query and i have defined a sensu check for it.
But In the sql query I need to pass Double Quotes, but sensu is not allowing to pass the Double Quotes in command
SELECT COUNT(*) FROM xxxxxxx WHERE STATUS IN (“‘D’”,“‘N’”,“‘S’”,“‘I’”)
My above query requries double quotes and a single quote as follows by sensu command is not allowing these quotes.(“‘D’”,“‘N’”,“‘S’”,“‘I’”)
How to overcome the issue.
Can some one help me to figureout the issue.