Not sure where to put JavaScript and how it should look:

nospace52 · Sep 8, 2003

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&quot

'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>
**
Information will be updated each workday by 9 am **
<hr>
<div align="center">
<center>
<table border="4" bgcolor="#C0C0C0" bordercolor="#0000FF" bordercolordark="#FF0000" bordercolorlight="#000080">
<tr>
<th>Name</th>
<td width="25"> 
</td>
<th>Remarks</th>
<td width="25"> 
</td>
</tr>
<%
'Iterate through the recordset, pull
'out the required data, and insert it
'into an HTML table.
Do While Not rsInfo.EOF
%>

<tr>
<td><% =rsInfo("Name&quot

%></td>
<td align="center" width="25"> 
</td>
<td><% =rsInfo("Remarks&quot

%></td>
<td align="center" width="25"> 
</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>
 
Page was last updated on


</body>

</html>

Thanks - Have a great day

BiggerBrother · Sep 9, 2003

A way of doing these two pages is to have a log in page, so you can determine user level. This thenm leads onto a single page containing 2 panels. This page would need to be an asp page. The code would then populate two tables to store all the information for both user types.

Using the invisible attribute of the panels, tyou can then hide one or the other panel, dependant on the user level. Is this the kind of thing you were looking for?

BB

nospace52 · Sep 9, 2003

BiggerBrother -
The web pages are on Windows 2000 - I do have a Supervisor web page set up with a user and password - I'm looking for a way to put in a JavaScript or a (If Statement) in the Acess 2000 sql that would set the Remarks to "Out" , "AM" , "PM" ,
"V03" or "P03" based on certain critera.
I have tried the IIF statement in Access but that is only on a True , False state.

Thanks

BiggerBrother · Sep 9, 2003

if all remarks are in the format REASON / TIME using a slash to separate, you could use the charat() statement to find where in the returned sql statemnet the / can be found, and then trim the string at this point.

BB

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Not sure where to put JavaScript and how it should look:

nospace52

Technical User

BiggerBrother

Technical User

nospace52

Technical User

BiggerBrother

Technical User

Similar threads

Part and Inventory Search

Sponsor