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?..
sample data 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/an...le#post3622154

please advise

thanks in advance
Omar.

Nov 8 '10 #1

jhardman

Yes, the function would be defined something like this: and the call would be just Jared

Nov 8 '10 #2

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.

Nov 8 '10 #3

jhardman

Yes, I assume you don't need advice on looping or setting up an if statement. To check the field type, try objRS("fieldName").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

Nov 9 '10 #4

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("fieldName").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.

Nov 9 '10 #5

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: . 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: does this make sense? This might not exactly answer your question, but this is how I would approach it.

Jared

Nov 9 '10 #6