Classic ASP Discussion - How to get data from my DB on that way

Print Page | Close Window

How to get data from my DB on that way

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=8505
Printed Date: 01 April 2026 at 7:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: How to get data from my DB on that way

Posted By: aero
Subject: How to get data from my DB on that way
Date Posted: 02 January 2004 at 6:30pm

Hi.

I know how 2 get data from a DB to an aspsite

but if i want to get all records where KAT = dvd and order them by VNR, then i have 2 use this:

SQL = "SELECT * FROM software where KAT ='dvd' or KAT='DVD' ORDER BY VNR"
Set rs = Conn.Execute(SQL)

But how do my While Not rs.EOF, If rs.EOF Then an so on look like if I want to get alle records from my DB where KAT = DVD or KAT = dvd, and group BY PRONAME and ordre by VNR.

so I will get all records where KAT is dvd and just dvd and then group then after PRONAME and i PRONAME the records are ordre by VNR.

so i ville get something like this:

http://www.midtjyskwebdesign.dk/image.gif - http://www.midtjyskwebdesign.dk/image.gif

I know how to get the records where KAT is dvd and then ordre them by VNR so i will get something link this:

http://www.midtjyskwebdesign.dk/image2.gif - http://www.midtjyskwebdesign.dk/image2.gif

but i want to group the product names.

can someone help me and give me an exampel.

Replies:

Posted By: michael
Date Posted: 03 January 2004 at 1:05pm

SELECT Proname FROM software where KAT ='dvd' or KAT='DVD' GROUP BY Proname ORDER BY VNR
Is that what you are after?

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker