Search results for query: *

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...

Hi tm88gt, I'd sure to get your email address too. Sounds like a great perl script. Rudy.

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...