One of my colleagues has done this in vbscript. His code within the recordset is
- "SELECT DISTINCT (ProductNumber), Doors, Fuel, Type FROM view WHERE Height between 3.0 and 4.0"
How can he be calling the column Height when it is not declared as a selected column?
I am trying to do this in C#, and I can't - if it goes to the dataapater
it fails because it wants the column Height to be declared.
I have 2 tables in SQL. One has information about the Product, the other has the Heights. One productnumber can have many heights. An inner join joins them and I save this to a view. This means I may have mulitple parts with the same ProductNumber in the view. (EG, if ProductNumber abc123 has 3 heights, it will appear 3 times in the view).
My web page has a 'refine your search' option where it lists all available heights as hyperlinks and counts how many options there are. EG, it shows:
height 1 (5 availabe)
height 2 (3 available)
height 4 (3 availabe)
Underneath this, it shows the products in a datalist.
View Complete Post