greatly appreciate the help..
yes..its just a variable..here is the code all the way down to that
variable. Here are the results of the response.write before it errors
out...
52 pp 40 pp 10
Coded as follows:
pmodelid=request.querystring("id")
SQL = "SELECT * FROM xxxx WHERE pmodel_id = " & pmodelid & ";"
Set rs = conn.execute(SQL)
conn.execute(SQL)
while not rs.eof
company = rs("client_name")
employee = rs("empl_name")
assignlength = rs("assign_length")
vacations = (rs("vacation"))
holidays = (rs("holidays"))
dateplaced = rs("date_placed")
avghours = rs("hours")
compcode = rs("work_code")
state = rs("work_state")
st = rs("st_rate")
otf = (rs("ot_factor"))
perdiem = (rs("perdiem"))
hw = (rs("hardware"))
sw = (rs("software"))
other = rs("insurance")
oth = (rs("onetime"))
branchst = (rs("burden_rate"))
commission = (rs("com_rate"))
dlc1 = (rs("st_dlcmkup"))
dlc2 = (rs("ot_dlcmkup"))
brlocation=rs("branch")
moneycost=rs("money_days")
moneyrate=(rs("money_rate"))
pricingadminid=rs("sales_id")
projpositions=cint(rs("positions"))
statusflag=rs("statusflag")
statusdate=rs("statusdate")
rs.movenext
wend
rs.close
SQL = "SELECT * FROM xxxxxxx WHERE id = '" & compcode & "';"
Set rs = conn.execute(SQL)
conn.execute(SQL)
while not rs.eof
wrkcrate=rs("rate")
workcdesc=rs("ratedesc")
rs.movenext
wend
rs.Close
wcdesc=wccode&" "&workcdesc
SQL = "SELECT * FROM xxxxxxxx WHERE id = 'MEDICR';"
Set rs = conn.execute(SQL)
conn.execute(SQL)
while not rs.eof
medicarate=rs("rate")
rs.movenext
wend
rs.Close
SQL = "SELECT * FROM xxxxxxxxx WHERE id = 'FUTA';"
Set rs = conn.execute(SQL)
conn.execute(SQL)
while not rs.eof
futarate=rs("rate")
futalimit=rs("wage")
rs.movenext
wend
rs.Close
SQL = "SELECT * FROM xxxxxxxx WHERE id = 'UCC-"&state&"';"
Set rs = conn.execute(SQL)
conn.execute(SQL)
while not rs.eof
uccrate=rs("rate")
ucclimit=rs("wage")
rs.movenext
wend
rs.Close
SQL = "Select userid from xxxxxxx where user_num = " & pricingadminid
Set rs = conn.execute(SQL)
conn.execute(SQL)
while not rs.eof
pricingadminname=rs("userid")
rs.movenext
wend
rs.Close
'formula variables
response.write assignlength&" pp "&(avghours)&" pp "&st
salaryexpense=(assignlength)*(avghours)*(st)
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!