Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: shape...compute command


Message #1 by bmcelhany@h... on Wed, 7 Nov 2001 22:05:30
I'm going to drive people here crazy with all of my questions! Here's 
another one...I want to create an ASP page that displays both summary and 
aggregate data from a query (everything comes from one table). Something 
like:

   Name-------Application #-----Decision
   Person 1---123456------------approved
   Person 2---234567------------approved
   Person 3---345678------------approved
   Total approved apps:---------3
   Person 4---456789------------denied
   Person 5---567890------------denied
   Total denied apps:-----------2

I have been researching ADO's datashaping capabilites, specifically the 
shape...compute clause. It seems to make sense, but I am having problems 
figuring out how to actually implement in in an ASP page (how to actualy 
display the returned data). Any ideas?

Brian

  Return to Index