|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
