在线等数值表单插入问题!?
sarm 2004-06-15 09:57:19 ‘定义变量
Dim sql,vname,vdepartment, vyear
’从表单接受数据
vname = Request("name")
vdepartment = Request("department")
vyear = Request("year")
连接数据库等等...
Set rsUser = Nothing
'在数据库里插入新用户
sql="INSERT INTO labour ( name,department,year)
VALUES('"& vname &"','"& vdepartment &"','"& vyear &"')(这里的vyear肯定是错的,可是具体该怎么做,我不知道?)
Conn.Execute(sql)
我的数据库是db2,year的建表类型是smallint,year在表单里该怎么表达,才能插入?thanks