求看看问题在哪?签到之前查询签到表里的备注=sql,总显示已签到
vbscript吧
全部回复
仅看楼主
level 1
<%
Dim Recordset1__MMColParamSession
Recordset1__MMColParam = "1"
If (Session("MM_Username") <> "") Then
Recordset1__MMColParam = Session("MM_Username")
End If
dim sql
sql="select sign_note FROM dbo.sign WHERE employee_id=" + Replace(Recordset1__MMColParam, "'", "''") + "AND DateDiff(dd,sign_in,getDate())=0"
if sql<>"" then
Response.Write "<script>alert('你已经签到过了!');location.href='jr_qd.asp';</script>"
else
end if
%>
2013年05月23日 07点05分 1
1