1–10…41–5051–6061–7071–75

Some CFML Stuffs Me Do

From: Peter (BOUGHTONP) 2 Jun 2011 15:47
To: Ken (SHIELDSIT) 67 of 75
38447.67 In reply to 38447.66
My chair did not attack me!

It would never do such a thing to me. :@
Reply
0/0
From: Ken (SHIELDSIT) 2 Jun 2011 15:48
To: Peter (BOUGHTONP) 68 of 75
38447.68 In reply to 38447.67
Well that was the only logical explanation!
Reply
0/0
From: Peter (BOUGHTONP) 2 Jun 2011 15:49
To: Ken (SHIELDSIT) 69 of 75
38447.69 In reply to 38447.65
And no, not used CF Report Builder, fortunately.

With CF8/9 Adobe did (attempt to) make it non-shit, but I've not had any reason to see if they succeeded.
Reply
0/0
From: Ken (SHIELDSIT) 2 Jun 2011 15:50
To: Peter (BOUGHTONP) 70 of 75
38447.70 In reply to 38447.69
I was going to try it, but I'm too dumb to make it work with Ralio.
Reply
0/0
From: Peter (BOUGHTONP) 2 Jun 2011 16:41
To: Ken (SHIELDSIT) 71 of 75
38447.71 In reply to 38447.70
I've no idea if it'll run against Railo or not - wouldn't be surprised if Adobe had deliberately made it incompatible in some way. :/
Reply
0/0
From: Drew (X3N0PH0N) 3 Jun 2011 02:15
To: Peter (BOUGHTONP) 72 of 75
38447.72 In reply to 38447.67
Reply
0/0
From: Ken (SHIELDSIT) 3 Jun 2011 03:03
To: Drew (X3N0PH0N) 73 of 75
38447.73 In reply to 38447.72
haha, I guess there's a comic for every situation!
Reply
0/0
From: Peter (BOUGHTONP) 3 Jun 2011 07:58
To: Drew (X3N0PH0N) 74 of 75
38447.74 In reply to 38447.72
I don't chew gum.
Reply
0/0
From: Ken (SHIELDSIT) 3 Jun 2011 17:33
To: Peter (BOUGHTONP) 75 of 75
38447.75 In reply to 38447.74
Peter do you have any idea why this isn't working or how I can make it work?

If you look at this query there is a ConsumedVol that sums everything that is 'consumed' and a ProducedVol that sums everything Produced.

I need to also do this for the ConsumedTotal and ProducedTotal. As the query is now I'm getting those numbers, but they are all lumped together. How can I do multiple sums in this query?

code:
SELECT
	ruhID,rudProductID,ruhDescrip,ruhDate,ruhLocationID,rudTotal AS ConsumedTotal,ConsumedVol=(SELECT SUM(ISNULL(rudVolume,0))
FROM
	ProductionDetail
WHERE
	rudID=ruhID
AND
	rudCategory='Consumed'),rudTotal AS ProducedTotal,ProducedVol=(SELECT SUM(ISNULL(rudVolume,0))
FROM
	ProductionDetail
WHERE
	rudID=ruhID
AND
	rudCategory='Produced')
FROM
	ProductionHeader
LEFT JOIN
	ProductionDetail
ON
	ruhID = rudID
WHERE
	ruhID
LIKE
	'%bg%'
AND
	ruhDate
BETWEEN
	'5/1/11'
AND
	'5/31/11'
GROUP BY
	ruhID,ruhDescrip,ruhDate,ruhLocationID,rudTotal,rudProductID
ORDER BY
	ruhDate DESC, ruhId ASC
Reply
0/0