i'm using sql server and classic asp. I'd like to know if there is a way to apply a 10% discount or any other calculation on to my sql table that contains prices via asp on the front end??
can this be done via a asp function upon recordset retrievel? something like this?..
Expand|Select|Wrap|Line Numbers
- Response.Write "£" & ASPFUNCTION(objRS("Triple_Redleaf_Price")) & "
Expand|Select|Wrap|Line Numbers
- ID Date_Band Redleaf_Tour Goldleaf_Tour Double_Accomodation Triple_Accomodation Single_Accomodation Child_Accomodation Double_Redleaf_Price Double_Goldleaf_Price Triple_Redleaf_Price Triple_Goldleaf_Price Single_Redleaf_Price Single_Goldleaf_Price Child_Redleaf_Price Child_Goldleaf_Price
- 1 May<br />2011 Redleaf Goldleaf Double Triple Single Child(2-11 years) 489 989 479 979 539 1039 419 909
http://bytes.com/topic/sql-server/an...le#post3622154
please advise
thanks in advance
Omar.