|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Selecting distinct records after Recordset "SELECT * " statement |
|
From: |
Harry |
|
Date: |
10/27/2000 11:41:57 AM |
|
IP: |
207.35.185.34 |
My select statement involves a table with rates.
type and rate1 ,rate2, rate3, rate4, rate5 are the variables that are blanket selected using the SELECT * in the recordset
statement.
The problem is that there about 15 different types (type) of items
that all need to be distinctly listed on 1 html page in seperate areas...so I cant just response.write them out in a loop.
The types also have different rate tiers....(eg. type1 would have a 3
rate tier----type2 would have a 5 rate tier----etc.)
Just using regular SQL will import all of the info (SELECT * FROM
table) but I then need to further select each type and rate and I need to put them in specific places "<tds>" within tables.
Do I predefine them...or...do a define and then select them from the recordset after the initial select...?? :0(
Any ideas, tutorial references, or am I just missing something obvious....
(Specs: IIS4 -- SQL 6.5 database)
Thanks in advance.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
