[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>
rs("ProductName").MoveNext
wend
loop
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