Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Basics
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 29th, 2004, 11:21 PM
Authorized User
 
Join Date: Jun 2003
Location: Melbourne, Victoria, Australia.
Posts: 90
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to tdaustin Send a message via Yahoo to tdaustin
Default Field Specific DISTINCT Statement

Hi Everyone,

Im having a problem with displaying distinct records.

I have a posters db which contains serveral fields with categories, and sizes.

The problem is they all have a size, but may belong to 1 or more categories. Which is fine sorting by category but when they are view the products by their sizes it produces duplicates.

Is it posible to Use the DISTINCT on a specific field. In this case by product_name because it does not work just using the DISTINCT

HERE IS MY SQL Statement

strSQL = "SELECT DISTINCT product_id, product_type, product_size, product_code, product_name, product_cat FROM products ORDER BY product_name"

Thanks Tim

TDA
__________________
TDA
Reply With Quote
  #2 (permalink)  
Old March 30th, 2004, 12:06 AM
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to qCapricorn
Default

Hi Tim,

Try using GROUP BY - you can "group by" more than one field if you need to...

Will a product with miltiple categories have different sizes or just the one size? If not, then I suggest you put product categories in a seperate table to save duplicating product details in products. (it will also solve this problem for you)

cheers,

Paul
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
using an IF statement with a recordset field melkin Classic ASP Components 3 March 20th, 2008 03:04 PM
Need to fetch distinct records on 2 field values LeoMathew XSLT 17 March 19th, 2008 07:45 AM
Updating a field using a SELECT statement? katie123 Access VBA 1 April 12th, 2006 10:23 AM
String Type Statement to convert field CORiverRat Access 5 December 15th, 2005 02:13 AM
IIF Statement is a Date field Corey Access 17 November 12th, 2005 06:50 PM



All times are GMT -4. The time now is 07:30 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.