Variables:
Expand|Select|Wrap|Line Numbers
- <%
- dim dbPH
- dim rsCur
- dim sdate
- sdate = request.Form("input_sdate")
- dim edate
- edate = request.Form("input_edate")
- dim psql
- dim icbrian
- set dbPH=Server.CreateObject("ADODB.Connection")
- set rsCur = Server.CreateObject("ADODB.recordset")
- dbPH.open "DSN=db;uid=id;"
- rsCur.ActiveConnection = dbPH
- %>
Expand|Select|Wrap|Line Numbers
- <td>
- Brian
- <%
- psql = "SELECT COUNT(*) FROM CallLog WHERE (ToFirstName = 'Incoming') AND (StartTime BETWEEN CONVERT(DATETIME, '2007-06-10 00:00:00', 102) AND CONVERT(DATETIME, '2007-06-16 23:59:59', 102)) AND (AnsweredByFirstName = 'Brian')"
- set rsCur = dbph.execute(psql)
- icbrian = rsCur
- %>
- </td>
- <td align="right">
- <%=icbrian%>
- </td>