A little help please :)
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=9159
Printed Date: 29 March 2026 at 6:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: A little help please :)
Posted By: worldwide1504
Subject: A little help please :)
Date Posted: 22 January 2004 at 8:10pm
|
Ok, here is the deal. First, the problem is on http://a.1asphost.com/worldwide1504/select.asp - this page . In the drop down box I have all of the categories that I have my icons under in the DB. but out of 83 icons I have it shows every icons category. So the question is, how do I get rid of all of the multiples? |
Replies:
Posted By: KCWebMonkey
Date Posted: 22 January 2004 at 8:12pm
| How is the list created? If you get it from a database with a sql query, then use DISTINCT in your query. |
Posted By: worldwide1504
Date Posted: 22 January 2004 at 8:33pm
|
Holy crap, I got it to work. Thanks so much. |
Posted By: jimidy
Date Posted: 22 January 2004 at 10:19pm
|
have a look at this mate.. http://cms-stu-iis.gre.ac.uk/wn008/junk/SnowdonASPGuide.doc - http://cms-stu-iis.gre.ac.uk/wn008/junk/SnowdonASPGuide.doc its the ASP guide we use at uni, it covers distinct and other basics.. ------------- www.srp.me.uk |
