Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 31st, 2005, 04:09 AM
Friend of Wrox
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default distinct problem

hello all
i have a page with dependent select menus.the child select menu has values that repeat and i don't want have them more thn once.i use distinct for my recordset but when i put istinct in my recordset the page dosen't show anything just the packground of page and nothing else.how should i have these values just once?please help me to fix this problem
thank you

Old September 6th, 2005, 02:47 PM
Registered User
Join Date: Aug 2004
Location: gandhinagar, gujarat, India.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to maulik Send a message via Yahoo to maulik


There could be one of the following reason why you see your page empty:

1. check the query result after using distinct in your select statement.
   (ex. select distinct menu_name from menuinfo)
2. if the query run perfect in query designer, you can check your webpage code and check whether the recordset is recivig the proper query result ? if not then there is prob in query and if yes then there may be some problem in your page code.

debugging the page is the great way to check

still you can give me more details of your code so i can solve it



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Distinct Smeghead SQL Server 2005 9 December 17th, 2007 11:10 AM
Distinct Eddywardo SQL Server 2005 1 September 2nd, 2006 07:41 AM
Count Distinct Jonas Access 2 August 14th, 2006 01:03 PM
DISTINCT trouble HockeyFan Classic ASP Databases 1 March 7th, 2006 01:07 PM
Distinct SELECT DISTINCT question... EndEffect Classic ASP Databases 4 August 18th, 2005 08:53 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.