That created the columns but it didn't combine the rows. I got results like this: > DATE LOC AP PL WB > -------- --- --- --- --- > 20050706 NS 14 0 0 > 20050706 NS 0 1 0 > 20050706 NS 0 0 21 > 20050706 SM 104 0 0 > 20050706 SM 0 39 0 > 20050706 SM 0 0 291
Not the desired two rows with three values each: > DATE LOC AP PL WB > -------- --- --- --- --- > 20050706 NS 14 1 21 > 20050706 SM 104 39 291 -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215252 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
