[thelist] ASP/SQL Question

J. Blanchard jay.blanchard at thermon.com
Fri Sep 14 07:52:23 CDT 2001

Let me first say that I don't want to (nor will I) create a page with 72 queries in it. I just did that as an exercize to prove to the "powers that be" it is a far from ideal thing to do, but it does illustrate my problem.

Second, both sets of data are in the same table....

ProductID     ProductType     ProductName
1             shirt           large
2             shirt           small
3             ties            red
4             ties            gnu

It seem to me that the code for getting the output I want would be something similar to (with one recordset (SELECT ProductID, ProductType, ProductName FROM Product))pseudocode (syntactically incorrect) below;

do while not rs("ProductType").EOF
   write rs("ProductType")<br>
      while not rs("ProductName").EOF
      write rs("ProductName")<br>
end if

Of course a lot of code has been left out, like checking the ProductType and doing an increment. I do see that code like this would be helpful for lots of applications, like listing offices by state, etc. Am I on the right path here?

As an aside, Rudy, why is data shaping evil?
Visit http://www.visto.com.
Find out  how companies are linking mobile users to the 
enterprise with Visto.

More information about the thelist mailing list