Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
woshixavi
Starting Member
2 Posts |
 Posted - 2006-05-23 : 05:34:38
|
| i having this problem, i want to check whether the slot in the database is null ,but it got error !Technical Information (for support personnel)Error Type:Microsoft VBScript runtime (0x800A01A8)Object required/clockingsystem/clockOut.asp, line 26Browser Type:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) Page:GET /clockingsystem/clockOut.asp the code is <% dim userId, time, rs, conn, sql,tod , clockIn, hi,clockOut userId = Session("userId") time = FormatDateTime(now(),vblongtime) tod = FormatDateTime(date(),vbgeneraldate) set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("staff.mdb")) set rs = Server.CreateObject("ADODB.recordset") rs.open "Select * from clock where userId= '" &userId&"' and today = '" &tod& "'" ,conn Response.Write sql if (rs.eof and rs.bof) then response.redirect("startpage.htm") session.abandon else if (rs("clockOut")) IS NOT NULL then sql ="UPDATE clock SET clockOut = '"&time&"' WHERE userId = '"&userId&"' And today ='"&tod&"';" conn.Execute sql else response.redirect("unpunched.asp") conn.Execute sql end if end if%> |
|
|
woshixavi
Starting Member
2 Posts |
Posted - 2006-05-23 : 06:29:10
|
| can anyone can help mi ? |
 |
|
|
|
|
|
|
|
Checking slot in Ms access whether is null