删除数据库的数据遇到的麻烦

[zl4460072]

从表单项获得房间名为roomname1，再把room表里房间名为roomname1的empty改为1，entrydays和staydays都变成空的
<%
dim roomname1
roomname1=request.Form("roomname")
dim conn,sql,rs
set conn = server.CreateObject("adodb.connection")
conn.open "dsn=jiudian"
conn.execute("UPDATE [room] SET [empty] ='1', [entrydays] = '', [staydays] = ''
where roomname='"&roomname1&"'")
%>
提示错误 :
Microsoft VBScript 编译器错误 (0x800A0409)
未结束的字符串常量
/mysite/delet.asp, line 53, column 80
conn.execute("UPDATE [room] SET [empty] ='1', [entrydays] = '', [staydays] = ''

[chjpeng]

conn.execute("UPDATE [room] SET [empty] ='1', [entrydays] = '', [staydays] = ''
where roomname='"&roomname1&"'")

没有放到一行上吧？

--
sqlstr = "UPDATE [room] SET [empty] ='1', [entrydays] = '', [staydays] = '' where roomname='"&roomname1&"'"
conn.execute(sqlstr)


还要注意entrydays，staydays的数据类型，如果是数值型的，还会出问题