Database drven function

[mark.shawe]

Hi,

I am a writing a website and have come accross an issue writing a function (which I am new to) using a database record, if anyone could show me the way it would be greatly appreciated.

here is the code that I have and it is creating a fault...

Set rsSummaryLabour = Server.CreateObject("ADODB.Recordset")
strSummaryLabour = "SELECT SUM (billingRate) as labour FROM jobsStaff WHERE job = " & request.QueryString("ID") & ""
rsSummaryLabour.Open strSummaryLabour, adoCon
	
Set rsSummaryLabourCost = Server.CreateObject("ADODB.Recordset")
strSummaryLabourCost = "SELECT SUM (payRate) as labourCost FROM jobsStaff WHERE job = " & request.QueryString("ID") & ""
rsSummaryLabourCost.Open strSummaryLabourCost, adoCon
	
function labourCost
	labourCost = (rsSummaryLabour("billingRate") - rsSummaryLabour("payRate"))
end function

thanks in advance for any pointers.

[gk53]

you do not need function. You should do that calculation in query

sql = "select (billingRate - payRate) as labourCost FROM jobsStaff WHERE job = " & request.QueryString("ID") & ""

[bigmike1212]

GK is correct. Do the calculation in the SQL.

To make your function work, your SQL selects sum of payrate but then calls it labourcost. The other statement selects sum of billingrate but then calls it labour. A function like:

labourCost = (rsSummaryLabour("labour") - rsSummaryLabour("labourcost"))

would move you more in the correct direction.

[mark.shawe]

Thanks people, I have used GK suggestion, sorry for the late reply and thanks been a busy day.
I appreciate the rapid response and if I could give you credit I would.
Thanks again.