Type Mismatch

[Ray]

I'm at my wits end here. I am getting type mismatch error
in a ASP page when I try to multiply decimals*integers.
This shouldn't be this difficult. I have tried the
conversion functions, changed the datatypes in the
pages..Help!!!!

[Curt_C [MVP]]

show the exact code, and the numbers once....
--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
...Offering free scripts & code snippits for everyone...
---------------------------------------------------------

"Ray" <rl*****@quantumresources.net> wrote in message
news:05****************************@phx.gbl...

I'm at my wits end here. I am getting type mismatch error
in a ASP page when I try to multiply decimals*integers.
This shouldn't be this difficult. I have tried the
conversion functions, changed the datatypes in the
pages..Help!!!!

[Ray Little]

Is this what you meant?

salaryexpense=(assignlength)*(avghours)*(st)

assignlength, avghours and st are read from the table.

table definitions
assignlength INT
avghours INT
st decimal
current values

assignlength = 52
avghours = 40
st = 10.00

if i response.write each value they come out like they should, but as
soon as i try to multiply them..mismatch error. Driving me nuts..

Thanks

Ray

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Curt_C [MVP]]

salaryexpense=CInt(assignlength)*CInt(avghours)*CI nt(st)

Does that work?
Are you sure there are no NULL values?

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
...Offering free scripts & code snippits for everyone...
---------------------------------------------------------

"Ray Little" <rl*****@quantumresources.net> wrote in message
news:Ok*************@TK2MSFTNGP12.phx.gbl...

Is this what you meant?

salaryexpense=(assignlength)*(avghours)*(st)

assignlength, avghours and st are read from the table.

table definitions
assignlength INT
avghours INT
st decimal
current values

assignlength = 52
avghours = 40
st = 10.00

if i response.write each value they come out like they should, but as
soon as i try to multiply them..mismatch error. Driving me nuts..

Thanks

Ray

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Curt_C [MVP]]

Cdbl() perhaps?

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
...Offering free scripts & code snippits for everyone...
---------------------------------------------------------

"Ray Little" <rl*****@quantumresources.net> wrote in message
news:ub*************@tk2msftngp13.phx.gbl...

not sure the first response went through..but...

if i change all of those to CInt i have been able to get that to work.
The issue is with the ST which is decimal. The value of say 32.50 will
change to 32 throwing the calculation off.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bob Barrows]

Ray Little wrote:

not sure the first response went through..but...

if i change all of those to CInt i have been able to get that to work.
The issue is with the ST which is decimal. The value of say 32.50 will
change to 32 throwing the calculation off.

What is salaryexpense? Is that a variable?
We're really guessing here. We need to see some more code. If I run this
code in my test asp page:
<%
dim assignlength,avghours, st,salaryexpense
assignlength = cint(52)
avghours = cint(40)
st=10.00
salaryexpense = assignlength * avghours * st
Response.Write salaryexpense
Response.End
%>

I get this result in the browser window:
20800

So if you want help, you are going to have to show us how to reproduce your
error.

Bob Barrows

[Ray Little]

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!

[Shailesh Humbad]

Try to filter each of the three variables using something like this:

If IsNull(avghours) Or Not IsNumeric(avghours) Or avghours = "" Then
avghours = 0
Else
avghours = CDbl(avghours)
End If
Response.write avghours

Check your table structure and see if anything is returning a string or
Null.

Shailesh

Ray Little wrote:

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!