28,409
社区成员




sql = "SELECT * FROM tblImportantInfo WHERE NotificationID = '" & NotificationID & "'"
rsImportantInfo.Open sql,conn,1,1
Dim rsImportantInfo
Set rsImportantInfo = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM tblImportantInfo WHERE NotificationID = '" & NotificationID & "'"
'如果NotificationID字段类型是数字,应下面的SQL语句
'sql = "SELECT * FROM tblImportantInfo WHERE NotificationID="¬ificationID
response.write sql '把打印出的SQL语句拷贝到查询器走走,看什么问题
response.end
rsImportantInfo.Open sql,conn,1,1
<%
Dim rsImportantInfo
Set rsImportantInfo = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM tblImportantInfo WHERE NotificationID = '" & NotificationID & "'"
rsImportantInfo.Open sql,conn,1,1
%>
set rsImportantInfo = server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM tblImportantInfo WHERE NotificationID = '" & NotificationID & "'"
rsImportantInfo.Open sql,conn,1,1