I am currently working on a new asp page and would like to do a query on the database which would then display the result like this:
BRAND (user selected) PRODUCT TYPE (many different types, muliple entries) PRODUCT SUB-TYPE (if there is one)(many different sub types, multiple entries) SKU, BREIF DESCRIPTION, PRICE (This will be a loop using the above catagories to sort it)
BRAND and PRODUCT TYPE have their own individual tables which are referenced in a lookup column on the products table. There will always be a BRAND and PRODUCT TYPE listed for each product but only sometimes will there be a PRODUCT SUB-TYPE. Therefor I didn't give the PRODUCT SUB-TYPE its own table. Each BRAND will only be listed once follow by PRODUCT TYPE only listed once each. It would then list all the products with no PRODUCT SUB-TYPE. Then it would list any products under each PRODUCT SUB-TYPE respectively. I hope this explains it alright, tell me if you need more info. I'm just learning both ASP and data bases but feel I'm learning very fast. Any other help you can give me would be awesome. I'm sure the answer is quite easy but it just keeps passing me by.
If you look towads the middles of the samples on this page, there are several sample database actions, including queries and updates. They are very basic but can get your started with basic syntax and shell, the next step would be added a form with list boxes tied to the product and brand name lists. This can be accomplished very easily with an ASP-generator software like Visual Interdev. I hope this helps, sorry I can't be more sepcific.
Topic Locked
Posted - 27 April 2001 : 01:15:10
