Nevertheless it always turns Status=Bad
Did I miss something?
ODBC Query with right value, but false alert value
ODBC Query with right value, but false alert value
As you can see in the screenshot, the test return value =6 and the alert value is > 100.
Nevertheless it always turns Status=Bad
Did I miss something?
Nevertheless it always turns Status=Bad
Did I miss something?
integer 6 < integer 100
string "6" > string "100"
Are you checking My SQL database?
My SQL manual tells about integer type but in reality it returns varchar.
If server returns some non-numeric data and you need to compare such data as numbers, you may use Optional status processing options (Test properties dialog).
E.g.
- set Normal status if "%SuggestedReply%"<=100
- set Warning status if "%SuggestedReply%">100
Regards
Alex
string "6" > string "100"
Are you checking My SQL database?
My SQL manual tells about integer type but in reality it returns varchar.
If server returns some non-numeric data and you need to compare such data as numbers, you may use Optional status processing options (Test properties dialog).
E.g.
- set Normal status if "%SuggestedReply%"<=100
- set Warning status if "%SuggestedReply%">100
Regards
Alex