% @language=VBScript %> <% OPTION Explicit Response.Expires=0 Function cTime(tmpTime) dim varLen if tmpTime < 12 then if ((tmpTime*10) mod 10) = 0 then CStr(tmpTime) tmpTime = tmpTime & ":00 AM" response.write (tmpTime) else CStr(tmpTime) varLen = len(tmpTime)-2 tmpTime = Left(tmpTime, varLen) tmpTime = tmpTime & ":30 AM" response.write (tmpTime) end if elseif tmpTime >= 13 then tmpTime = tmpTime - 12 if ((tmpTime*10) mod 10) = 0 then CStr(tmpTime) tmpTime = tmpTime & ":00 PM" response.write (tmpTime) else CStr(tmpTime) varLen = len(tmpTime)-2 tmpTime = Left(tmpTime, varLen) tmpTime = tmpTime & ":30 PM" response.write (tmpTime) end if else if ((tmpTime*10) mod 10) = 0 then CStr(tmpTime) tmpTime = tmpTime & ":00 PM" response.write (tmpTime) else CStr(tmpTime) varLen = len(tmpTime)-2 tmpTime = Left(tmpTime, varLen) tmpTime = tmpTime & ":30 PM" response.write (tmpTime) end if end if End Function dim objCN, objRS, strConn, strSQL, optionStr, ur_good dim compStr, chanStr, locStr, user_name, dropStr Set objCN=server.createobject("ADODB.Connection") if Application("LogonConnectString")<>"" then strConn = Application("LogonConnectString") else strConn="DSN=DigitalDB;UID=digitalit;PWD=digital00124;" end if objCN.open strConn set objRS = server.createobject("ADODB.recordset") strSQL = "Select * from events " strSQL = strSQL & "WHERE e_date > '"&DateAdd("d",-1,now) strSQL = strSQL & "' ORDER BY e_date" set objRS = objCN.execute(strSQL) %>