Hello DN zone, just I'm using asp.net 1.1 VB with Dreamweaver 8 and SQL 2000. I have items with mutiple galleries. For the table with the item gallery information on the database I have these as columns, id, item code, image name, and gallery catagory. Each item has multiple images and multiple gallery catagories that are specific to that item. I use a drop down list to select the item gallery catagory and all teh images associated with that gallery show. The drop down list uses a dreamwear dataset with parameter query. The parameter is the item code, and the text of the drop down list is the gallery catagory. Everything works great except that in my drop down list the results are equal to every image with that item id and repeat item catagory. Exmaple Item code= "mufflers" and for this item code there are 3 gallery catagories "Corsa" , "Flowmaster", and "Borla". Each of these catagories have 3 images each of a total of nine images in for the item code. I have everything working properly except my Drop Down List to select the categories is repeating the categories for every image. So instead of the drop down list showing only the three catagories: “Corsa Flowmaster Borla” the Drop Down List shows: “Corsa Flowmaster Borla Corsa Flowmaster Borla Corsa Flowmaster Borla” because in total there are 9 images. The drop down list has to be dynamic as is because another Item code will have different categories. For Example the second item code may be “Tires” and the categories for it will be “Goodyear”, “Dunlop”, and “Michelin”. So everything in the application and page works great except the repeating of categories in the drop down list, any suggestions on how to solve this?
Hello DN zone, just I'm using asp.net 1.1 VB with Dreamweaver 8 and SQL 2000. I have items with mutiple galleries. For the table with the item gallery information on the database I have these as columns, id, item code, image name, and gallery catagory. Each item has multiple images and multiple gallery catagories that are specific to that item. I use a drop down list to select the item gallery catagory and all teh images associated with that gallery show. The drop down list uses a dreamwear dataset with parameter query. The parameter is the item code, and the text of the drop down list is the gallery catagory. Everything works great except that in my drop down list the results are equal to every image with that item id and repeat item catagory. Exmaple Item code= "mufflers" and for this item code there are 3 gallery catagories "Corsa" , "Flowmaster", and "Borla". Each of these catagories have 3 images each of a total of nine images in for the item code. I have everything working properly except my Drop Down List to select the categories is repeating the categories for every image. So instead of the drop down list showing only the three catagories: “Corsa Flowmaster Borla” the Drop Down List shows: “Corsa Flowmaster Borla Corsa Flowmaster Borla Corsa Flowmaster Borla” because in total there are 9 images. The drop down list has to be dynamic as is because another Item code will have different categories. For Example the second item code may be “Tires” and the categories for it will be “Goodyear”, “Dunlop”, and “Michelin”. So everything in the application and page works great except the repeating of categories in the drop down list, any suggestions on how to solve this?
Joined: 11 Jul 2006 Homepage: link Country: New Zealand Posts: 1
Posted: 21 Aug 2006 00:52:32
At the moment your SQL statement is probably just <b>SELECT <i>field</i> FROM <i> table</i></b> Change your SQL statement to <b>SELECT DISTINCT (field) FROM <i>table</i></b> By Selecting UNIQUE you don't get duplicates
Edited by - timb_nz on 21 Aug 2006 00:53:12
Edited by - timb_nz on 21 Aug 2006 07:58:32
At the moment your SQL statement is probably just <b>SELECT <i>field</i> FROM <i> table</i></b> Change your SQL statement to <b>SELECT DISTINCT (field) FROM <i>table</i></b> By Selecting UNIQUE you don't get duplicates
When a graph is drawn, the focus is kept on the actual underlying competing figures that constitute the graph. Sometimes it is difficult to make assumptions just by looking at these graphs. When looking at a geographical map of data you immediately see exactly where things are happening. This article presents a .NET geographical mapping solution that will illustrate a fairly simple way of implementing these maps.
Have you, as a web developer or designer ever been on sites where the site seems more of a puzzle then a tool to find the information you where looking for? Or are you looking to improve your web design skills? Then read on!
Design & Accessibility
This e-Book will teach you how to become a truly professional developer or designer. By taking usability and accessibility issues in account when designing your websites or applications you can make the difference and avoid a lot of (user) frustration.
Inside ASP.NET is a comprehensive guide to ASP.NET development using Microsoft's .NET development framework. This book presents information on the .NET framework that is of specific interest to Internet and intranet developers, and is split into the following sections: Introducing ASP.NET, Core ASP.NET, ASP.NET and Data Access, Advanced Technologies, Advanced Web Forms, and Putting It All Together
Each chapter tackles a specific area of ASP.NET development, first by giving a detailed overview, then presenting a series of code examples and walk-throughs that illustrate various applications of ASP.NET
Posted: 03 Jul 2006 08:51:21 
