KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

ODBC Query with right value, but false alert value

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting
View previous topic :: View next topic  
Author Message
morphil



Joined: 17 Sep 2012
Posts: 5
Location: Österreich

PostPosted: Mon Nov 09, 2020 4:05 am    Post subject: ODBC Query with right value, but false alert value Reply with quote

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?
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12791
Location: USA

PostPosted: Mon Nov 09, 2020 8:04 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
morphil



Joined: 17 Sep 2012
Posts: 5
Location: Österreich

PostPosted: Mon Nov 09, 2020 9:00 am    Post subject: Reply with quote

perfect, this works, thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index