Hi, ok the frameset code:
<html>
<head>
<title>Company Database Test</title>
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape"
&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
</head>
<frameset rows="19%,*" cols="*">
<frame src="head.html" noresize scrolling="no" name="head">
<frameset cols="24%,*" rows="*">
<frame src="menu.html" noresize scrolling="no" name="menu">
>
<frame src="home.html" noresize scrolling="yes" name="main">
</frameset>
</frameset>
<noframes>
</noframes>
--------------------------------------------------------
The homepage: (very basic, needs username & password form)
<html>
<head>
<LINK REL="stylesheet" TYPE="text/css" HREF="stylesheet.css">
<title>Company Database Test</title>
</head>
<body>Welcome to the Oracle Database Test website<p>
Please use the menu to the left access the Oracle database functions.<p>
</body>
</html>
--------------------------------------------------------
The add to database page (1 of 4 similar pages where I would like the username and password fields to be automatically completed depending on the initial login) BTW The form action link is not active at this time:
<!--add.html-->
<html><head>
<LINK REL="stylesheet" TYPE="text/css" HREF="stylesheet.css">
<title>Add to Oracle Database</title></head>
<h1>Add to Oracle Database<p></h1>
<body><hr>Please input your username and password along with the required data to add a record to the Department table</h1>
<form action="
method="post" name=form1>
<table>
<TR>
<TD></TD>
<TD>Username:</TD>
<TD><INPUT TYPE="text" name="user" SIZE=20 ></TD>
<TD></TD>
</TR>
<TR>
<TD></TD>
<TD>Password:</TD>
<TD><INPUT TYPE="password" name="pwd" SIZE=20 ></TD>
<TD></TD>
</TR>
<TR>
<TD></TD>
<TD>Department Number:</TD>
<TD><INPUT TYPE="text" name="deptno" SIZE=20 ></TD>
<TD></TD>
</TR>
<TR>
<TD></TD>
<TD>Department Name:</TD>
<TD><INPUT TYPE="text" name="deptname" SIZE=20 ></TD>
<TD></TD>
</TR>
<TR>
<TD></TD>
<TD>Location:</TD>
<TD><INPUT TYPE="text" name="loc" SIZE=20 ></TD>
<TD></TD>
</TR>
</table><br>
<input type=submit value=Submit onclick=
"if (document.form1.user.value == '' || document.form1.pwd.value == '')
{
alert('Input all fields!')
return false
}"
>
<input type=reset value="Clear">
</form>
</body>
</html>
-------------------------------------------------------
The head.html just has a logo etc, nothing related to the working of the site.
-------------------------------------------------------
The add.pl code:
#!/usr/local/bin/perl -w
#insert.pl
use DBI;
use CGI;
$rgt = new CGI;
$user = $rgt->param("user"
;
$pwd = $rgt->param("pwd"
;
$deptno = $rgt->param("deptno"
;
$deptname = $rgt->param("deptname"
;
$loc = $rgt->param("loc"
;
$dname =~ tr/a-z/A-Z/;
$loc =~ tr/a-z/A-Z/;
$ENV{ORACLE_HOME}="/u22/Oracle/9.0.1";
$ENV{ORACLE_SID}="shu9i";
$db = DBI->connect( "DBI:Oracle(RaiseError=>1):shu9i", $user, $pwd) or die
"Cannot connect to Oracle instance: $db->errstr\n";
$qry = "INSERT into DEPT values (" .$deptno. ", '" .$deptname. "', '" .$loc.
"')";
$cursor = $db->prepare($qry) or die "Cannot prepare cursor\n";
$cursor->execute or die "Unable to execute SQL command\n";
$cursor->finish or die "Cannot close cursor\n";
$db->disconnect or die "Cannot disconnect from Oracle instance\n";
print "Content-type: text/html\n\n";
print "<HTML><HEAD><TITLE>Insert</TITLE></HEAD><body bgcolor=#CDCDCF><table align=center><hr>";
print "<h3>Operation completed for user <font color=blue>" . $user . "</font>!</h3><hr><p>Department number <font color=blue> " .$deptno. " </font>, named <font color=blue> " .$deptname. "</font>, at location <font color=blue> " .$loc." </font> has successfully been added to the DEPT table. Thank You";
print "</table></body></HTML>";
exit(0);
-------------------------------------------------------
I have used Firewords for the menu.html so the code is fairly long. Basically it consists of 5 hyperlinks: Add.html, delete.html, view.html, update.html and home.html which are all displayed in the mainframe when clicked!
Hope this gives a clearer picture of what I have. Thanks again for any help!!!!!
