New to Javascript:
I'm putting together a web page for Supervisors and Employee's. The Superviors will be able to see the reason the person in out in the "Remarks" Field. The database would have a Remark like "Meeting/AM" or "Meeting/PM".
Instead of having 2 databases the person would update 1 and then copy it to another directory and rename the database to
out.mdb.
My question is:
How or what JavaScript would I need in the Employees web page that when a Remark = "Meeting/AM" it would show "AM"
when the web page is open.
Here is what I have so far for the Employees web page.
**Out.asp**
Option Explicit
'Define our variables.
Dim cnnDB, strQuery, rsInfo ,cnndb1 ,authUser
'Create an instance of the Connection object.
Set cnnDB = Server.CreateObject("ADODB.Connection"
'And open it.
cnnDB.Open "out"
'Build our SQL query string.
strQuery = "SELECT OUT.Name, OUT.REMARKS FROM OUT WHERE (((OUT.REMARKS) Is Not Null)) ORDER BY OUT.Name;"
'Execute the query and return a recordset.
Set rsInfo = cnnDB.Execute(strQuery)
%>
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Out Today</title>
</head>
<body bgcolor="#C0C0C0" bgproperties="fixed">
<h2 align="center">Out Today</h2>
<p align="center"><b><i><u><span style="text-transform: uppercase"><font face="Book Antiqua" color="#0000FF">**
Information will be updated each workday by 9 am **</font></span></u></i></b></p>
<hr>
<div align="center">
<center>
<table border="4" bgcolor="#C0C0C0" bordercolor="#0000FF" bordercolordark="#FF0000" bordercolorlight="#000080">
<tr>
<th><strong><u>Name</u></strong></th>
<td width="25"><br>
</td>
<th><strong><u>Remarks</u></strong></th>
<td width="25"><br>
</td>
</tr>
<strong><%
'Iterate through the recordset, pull
'out the required data, and insert it
'into an HTML table.
Do While Not rsInfo.EOF
%>
</strong>
<tr>
<td><strong><% =rsInfo("Name" %></strong></td>
<td align="center" width="25"><br>
</td>
<td><strong><% =rsInfo("Remarks" %></strong></td>
<td align="center" width="25"><br>
</td>
</tr>
<%
'Move to the next record in the
'recordset
rsInfo.MoveNext
Loop
'Close the recordset.
rsInfo.Close
'And close the database connection.
cnnDB.Close
%>
</table>
</center>
</div>
<p align="center"> </p>
<p align="center"><font color="#0000FF"><strong>Page was last updated on</strong></font></p>
<p align="center"><font color="#0000FF"><strong><!--webbot bot="Timestamp"
s-type="REGENERATED" s-format="%A, %B %d, %Y" --></strong></font></p>
</body>
</html>
Thanks - Have a great day
< I want to work in Theory - everything and everybody works in Theory !!>
I'm putting together a web page for Supervisors and Employee's. The Superviors will be able to see the reason the person in out in the "Remarks" Field. The database would have a Remark like "Meeting/AM" or "Meeting/PM".
Instead of having 2 databases the person would update 1 and then copy it to another directory and rename the database to
out.mdb.
My question is:
How or what JavaScript would I need in the Employees web page that when a Remark = "Meeting/AM" it would show "AM"
when the web page is open.
Here is what I have so far for the Employees web page.
**Out.asp**
Option Explicit
'Define our variables.
Dim cnnDB, strQuery, rsInfo ,cnndb1 ,authUser
'Create an instance of the Connection object.
Set cnnDB = Server.CreateObject("ADODB.Connection"
'And open it.
cnnDB.Open "out"
'Build our SQL query string.
strQuery = "SELECT OUT.Name, OUT.REMARKS FROM OUT WHERE (((OUT.REMARKS) Is Not Null)) ORDER BY OUT.Name;"
'Execute the query and return a recordset.
Set rsInfo = cnnDB.Execute(strQuery)
%>
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Out Today</title>
</head>
<body bgcolor="#C0C0C0" bgproperties="fixed">
<h2 align="center">Out Today</h2>
<p align="center"><b><i><u><span style="text-transform: uppercase"><font face="Book Antiqua" color="#0000FF">**
Information will be updated each workday by 9 am **</font></span></u></i></b></p>
<hr>
<div align="center">
<center>
<table border="4" bgcolor="#C0C0C0" bordercolor="#0000FF" bordercolordark="#FF0000" bordercolorlight="#000080">
<tr>
<th><strong><u>Name</u></strong></th>
<td width="25"><br>
</td>
<th><strong><u>Remarks</u></strong></th>
<td width="25"><br>
</td>
</tr>
<strong><%
'Iterate through the recordset, pull
'out the required data, and insert it
'into an HTML table.
Do While Not rsInfo.EOF
%>
</strong>
<tr>
<td><strong><% =rsInfo("Name"
%></strong></td><td align="center" width="25"><br>
</td>
<td><strong><% =rsInfo("Remarks"
%></strong></td><td align="center" width="25"><br>
</td>
</tr>
<%
'Move to the next record in the
'recordset
rsInfo.MoveNext
Loop
'Close the recordset.
rsInfo.Close
'And close the database connection.
cnnDB.Close
%>
</table>
</center>
</div>
<p align="center"> </p>
<p align="center"><font color="#0000FF"><strong>Page was last updated on</strong></font></p>
<p align="center"><font color="#0000FF"><strong><!--webbot bot="Timestamp"
s-type="REGENERATED" s-format="%A, %B %d, %Y" --></strong></font></p>
</body>
</html>
Thanks - Have a great day
< I want to work in Theory - everything and everybody works in Theory !!>
