|
View previous topic :: View next topic |
Author |
Message |
_corebusiness_
Joined: 21 May 2003 Posts: 5 Location: Denmark
|
Posted: Thu May 22, 2003 3:05 am Post subject: |
|
|
OS: windows 2000 sp3
HM: version 3.68
I was setting up logging to a SQL database, and i have created an appropriate table etc, everything is fine, but:
The macro variables:
%AliveRatio% %DeadRatio% and %UnknownRatio%
returns a value wich is seperated by commas (ie. 91,00 or 0,00 or 20,00 etc). This gives me a problem when i try to store the value for one of the 3 macro variables as a number (either float, int etc.)
Lets say I want to store 3 values, the variables used in my sql query would actually return 6 values seperated by commas : 91,00, 00,00, 20,00 instead of 91.00, 00.00, 20.00 (3 values).
I have changed my regional settings and made sure that all seperators used by the systes are "." and not ","
Is it possible to either get a rouded value from %AliveRatio% %DeadRatio% and %UnknownRatio% or get a value seperated by something else than a comma ?
If not, well then i would have to store the values as text, or strip the last 3 chars before storing.
Any suggestions?
Best regards
Rasmus Jensen, CORE Business. |
|
Back to top |
|
|
Marcus
Joined: 18 Nov 2002 Posts: 367
|
Posted: Thu May 22, 2003 6:02 am Post subject: |
|
|
Surround the macro's with "" |
|
Back to top |
|
|
_corebusiness_
Joined: 21 May 2003 Posts: 5 Location: Denmark
|
Posted: Thu May 22, 2003 6:23 am Post subject: |
|
|
that would still return a value containing comma, where the regional setting of the sql server would have expected a value seperated by a dot ?
so the value returned would not fit as "int" or "float" field ?
|
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12801 Location: USA
|
Posted: Thu May 22, 2003 2:09 pm Post subject: |
|
|
>I have changed my regional settings and made sure that all seperators used by the systes are "." and not ","
After this you should restart HostMonitor. And problem will be solved.
Regards
Alex |
|
Back to top |
|
|
_corebusiness_
Joined: 21 May 2003 Posts: 5 Location: Denmark
|
Posted: Fri May 23, 2003 1:48 am Post subject: |
|
|
It works,
As usual fast and clear responses, thank you!
|
|
Back to top |
|
|
|
|
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
|