参数错误为什么？

[wvtjplh]

			if not isnull(rs("photoName")) then
				dim topId,sqlPhoto
				set rs2=server.createobject("adodb.recordset")
				sql2="select top 1 SID from SALES order by SID desc "
				rs2.open sql2,conn,1,1
				topId=CLng(rs2("SID"))
				rs2.close
				set rs2=nothing
				sqlPhoto="insert into PHOTOLIST (SMALLPHOTO,BIGPHOTO,PHOTONAME,PHOTOSIZE,HASH,THEDAY,SID) values ("&rs("smallPhoto")&","&rs("orederImage")&",'"&rs("photoName")&"','0','0',"&Date()&","&topId&")"
				conn.Execute sqlPhoto
			end if

数据类型
SMALLPHOTO(image),BIGPHOTO(image),PHOTONAME(varchar(50)),PHOTOSIZE(varchar(50)),HASH(varchar(50)),THEDAY(datetime),SID(int)

为什么总是提示参数错误？

[gxq323]

你是不是没打开conn

[wvtjplh]

我说错了 是类型不匹配

[gxq323]

用rs.addnew这种方法插入数据，出错会报哪行吧