classic asp function to utilize on the recordset

[omar999]

hi guys

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?..

Response.Write "£" & ASPFUNCTION(objRS("Triple_Redleaf_Price")) & "

sample data

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

I have been told it would be better to perform this function via asp front end rather than my sql statement

http://bytes.com/topic/sql-server/answers/885132-possible-run-cast-function-entire-table-possible#post3622154

please advise

thanks in advance
Omar.

[jhardman]

Yes, the function would be defined something like this:

function discount(listedValue)
   Discount = 0.9 * listedValue
End function

and the call would be just

response.write discount(objRS("red_leaf_price"))

Jared

[omar999]

hi jared

your above suggestion worked great.

is it however possible to apply this function to all recordset calls as a shortcut as opposed to adding the discount function to every applicable recordset call?

ideally a function that checks if rs is an integer then apply discount otherwise ignore?

thanks in advance
Omar.

[jhardman]

Yes, I assume you don't need advice on looping or setting up an if statement. To check the field type, try objRS("fieldNam e").type - this returns an integer value. I don't remember any of the individual values, but that's what I use to say "if it's a type x then do y"

Jared

[omar999]

I should be okay setting up an if loop statement.

im a bit confused as to what you mean though - do I add objRS("fieldNam e").type to the function?

is it not possible to avoid manually adding the function to all recordset calls and instead declaring the function once and it automatically filters through on all integer type data?

I am able to do this on the sql select statement using the cast function but it requires me to explicitly cast every applicable column. im looking for a more leaner way.

or is there an option to save the function as a stored proc and exec it from the db on to several tables?? just brainstorming here...

Omar.

[jhardman]

There have been several times that I have made a quick asp page to edit or add a record to a db. I typically make a form and loop through the fields putting one input in the form for each field in the db row. This usually looks like this:

for each x in objRS.fields
   Response.write "<input type=""text"" name=" & chr(34) & x.name &  chr(34) & " value=" & chr(34) & objRS(x) & chr(34) & ">"
Next

. With me so far? I often want a slightly different input for integer versus text fields. For example if I had a large text memo field I would want a textarea rather than a text input. In that case I put an if statement within the loop like this:

if x.type =4 then
   Response.write "<textarea " 'etc
Else
   Response.write "<input " 'etc
End if

does this make sense? This might not exactly answer your question, but this is how I would approach it.

Jared