We're running informix 7.31 on hpux10.20 as a database backend to a solarus 8.0 server running Remedy Help Desk ARS 4.x. The solarus box queries the informix box. We are having consistent performance problems--long delays.
Any good way to isolate whether the problem is on the Informix box...
Oops, told you I was a newbie. I should have written:
"select sum(duration) where month(date)=1"
if sum<>"" then Janduration=sum
else Janduration=0
end if
close.rs
open.rs
"select sum(duration) where month(date)=2", etc, etc
I know my syntax has errors, but I'll just slog thru it till it...
Folks,
Thanks for your replies. I am a bit of a newbie and thought this was an easy one. I'll just write 12
"select sum(duration) where month(date)=1"
if month(date)<>"" then Janduration=sum
else Janduration=0
end if
close.rs
open.rs
"select sum(duration) where month(date)=2", etc, etc
I...
Golom,
It would be just 2 incident types.
Dhookom,
If there is no data for a particular month, like any other chart I'd just show "0". I'd probably just write some asp code to do this.
I'm still wondering how to put monthly sums into a variable for the month so the chart will show it...
Hi,
I have a table:
itemNum, mmddyy, duration(hours), incidentType(string)
01, 2/1/04, 4, fault
02 3/4/04, 3.5, process
I need an ms sql query to sum duration and # of "types"
for each month, even when the month has no data. This is for a fusioncharts...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.