<%@ Language=VBScript%> <%Response.Buffer = True%> <% '*************************************************** 'Author: Bennett Giesler 'Date: 3-30-2006 ' 'Description: This asp program allows the administrator to select multiple committees and change their date value with one easy click ' ' * Displays all committees with a checkbox next to their name ' * To change the date the user needs to select all the committees they want to change ' * Then simply enter in a new Start Nom, End Nom, Vote Start, and Vote End Date ' * It also lists the committees with alternating table colors to make it easier to read. '*************************************************** %> NVS Admin - Mass Date Change <% Title = "Mass Date Change" %>
<% ' Lets list all of the committees. Dim strSQL Dim commname strSQL = "SELECT COMID, COMNAME, STARTNOM, ENDNOM, STARTVOTE, ENDVOTE" strSQL = strSQL + " FROM COMM1" strSQL = strSQL + " ORDER BY COMNAME" 'response.write strSQL dbNVS.Open set myRS = Server.CreateObject("ADODB.Recordset") myRS.ActiveConnection = dbNVS myRS.Open strSQL, dbNVS %>
<% 'Alternate the colors in the table so it's easier to read. dim celcolor celcolor = true While NOT myRS.EOF %> <% if celcolor = true then celcolor = false else celcolor = true End If myRS.MoveNext Wend %>
Name Start Nom End Nom Start Vote End Vote Change Dates
><%=myRS.Fields("COMNAME").Value%> ><%=myRS.Fields("STARTNOM").Value%> ><%=myRS.Fields("ENDNOM").Value%> ><%=myRS.Fields("STARTVOTE").Value%> ><%=myRS.Fields("ENDVOTE").Value%> >

">

 

Enter New Dates For Selected Committees.

Start Nomination

End Nomination

Start Vote

End Vote

 

<% set myRS = Nothing dbNVS.Close %>