asp 类型不匹配 sql2000

sql2000字段类型 decimal（18，2）

将一个在这个范围的数字字符串存入出现类型不匹配，应该用哪个函数转换

---

cint()或者clng()

---

类型不匹配: 'clng'

---

VBScript code:
loginid = trim(request.cookies("CRM")("LoginName"))
yeare = trim(request.Form("yeare"))
quarter = trim(request.form("quarter"))
uname = trim(request.form("uname"))

set rs=server.createobject("adodb.recordset")
rs.open"PA_TG_MARK",conn, 1, 3
rs.addnew

Dim tableobj, i
Set tableobj = Request.Form("table_no")
For i = 1 To tableobj.Count
str = trim(request.Form("mark"&tableobj(i)))
rs.addnew
rs("mark_id")=tableobj(i)
rs("mark") = trim(request.Form("mark"&tableobj(i))) //这一行类型不匹配
rs("mark_done")=loginid
rs("mark_year")=yeare
rs("mark_quarter")=quarter
rs.update
Next
Set tableobj = Nothing
rs.close
set rs = nothing
conn.close
set conn = nothing

---

trim(request.Form("mark"&tableobj(i))) 这个有可能是个空值 跟这个没关系吧

---

response.write trim(request.Form("mark"&tableobj(i))) 

看看打印出来的是什么值

---

cint也不行么
HTML code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.Code