How do I read a dataset so that I get only one value of one field, then read
the entire database. For instance, I'm doing a database of bakery products,
want to list all cakes. General query, Select * from tblProducts where
Category = 'Cakes"
So I read the first row so tht I can get a heading, then want to list all
items. But because I've already "read" the first row, the list of all items
do not contain the first item in my datareader. How do I fix this, do I
have to do 2 queries, one to get the heading, then the second query to get
the list of products under that heading. Seems to me that's going backwards
from using recordsets.
dr.Read
Response.Write(" <tr><td colspan=3><font size=+1><b>" &
dr("Category")</td></tr>")
while dr.read
Response.Write("<tr><td>" & dr("ProductName") & "</td><td>")
end while