Justice of the Peace Pct. #4
<%
tempinfo=""
tempHoliday=""
set objconn = server.CreateObject("ADODB.Connection")
objConn.ConnectionTimeout = 15
objConn.CommandTimeout = 10
'objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("/fpdb/New_t_Dept.mdb")
objConn.open "DRIVER={SQL Server};SERVER=SQL3;DATABASE=PublicDB;UID=PublicDBuser;PWD=PublicDBuser"
Set objRS = Server.CreateObject("ADODB.Recordset")
'Open the recordset getting a list of all items
strSQL="Select * from t_Holiday"
objRS.Open strSQL , ObjConn, adOpenDynamic, ,adCmdText
if not objRS.EOF then
tempInfo=objRS("Holiday") & "
"
end if
objRS.Close
'strSQL="Select H_Description from t_Holiday_List Where H_Date<='" & Date()+10 & "' and H_Date>='" & Date() & "'"
strSQL="Select H_Description from t_Holiday_List Where End_Post_Date>=getDate() and Start_PostDate<=getDate()"
'response.write strSQL
objRS.Open strSQL , ObjConn, adOpenDynamic, ,adCmdText
do while not objRS.eof
tempHoliday = tempHoliday & objRS("H_Description") & "
"
objRS.moveNext()
loop
objRS.Close
objConn.Close
set objRS=Nothing
set objConn=Nothing
%>
 Judge JW Hand |
The
Honorable JW Hand, Justice of the Peace Precinct 4
|
|
| Building: | Roanoke Government Center | |
| Address: | 816 North Hwy. 377 Roanoke, Texas 76262-6175 |
|
| Phone : | (972) 434-3910 | |
| Fax : | (972) 434-3911 | |
| Hours |
OFFICE HOURS
Monday - Friday 8:00am - 12:00pm and 12:30pm - 4:00pm The Court will be closed from 11:30 am until 1:30 pm on Friday, August 6, 2010, for a staff meeting. |
|
WARNING
Do not attempt to
contact a judge - by mail, e-mail, phone, or in person - about any pending or
potential lawsuit!
Doing so may
result in serious consequences.