call user defined sql function via classic asp

[omar999]

hi guys

I have a user defined sql function in my sql server db called TenPercentDisco unt but not sure how to call it via classic asp?

iv tried both
objRS(TenPercen tDiscount("Doub le_Redleaf_Pric e"))
TenPercentDisco unt(objRS("Doub le_Redleaf_Pric e"))

but not having any joy? Double_Redleaf_ Price is an integer value and my function code is

CREATE FUNCTION TenPercentDiscount 
(@InputVals int)
RETURNS int
AS
BEGIN
declare @convertedVal varchar(30)
set @convertedVal =  Cast(@InputVals  * 0.9 as int)
return  @convertedVal 
end

please adivse
omar

[jhardman]

You can't call it from the asp, you need to use it IN your sql query.

select tenpercentdiscount(redleafprice) as newprice from mytable

Jared

[omar999]

hi Jared - thanks for clarifying.

I shall post this question in the sql section then..

thanks again
Omar.