|
<html>
<head>
<title>Student Add Delete V4 </title>
<meta http-equiv="pragma" content="no-cache">
</head><body>
It is now <%= [ ns_fmttime [ns_time] "%A, %B %e, %Y at %r" ] %>.<p>
<%
set_the_usual_form_variables
# sets lname, QQlname
db_foreach s_row "select sid, sname from chuck.s
where upper(sname) like upper('%$QQlname%') order by upper(sname)" {
ns_adp_puts "<form method=get action=\"s3-upd-2.adp\">
Number: <input type=text name=sid value=\"$sid\" size=6 readonly notab>
Name: <input type=text name=sname value=\"$sname\" size=10>
<input type=submit name=action value=\"Update\">
<input type=submit name=action value=\"Delete\">
<input type=reset value=\"Undo\">
</form>"
} if_no_rows {
ns_adp_puts "Did not find any rows containing '$lname'"
}
%>
<p><hr><p>Lookup student by name or partial name<br>
<form method=get action="s4-add-del-2.adp">
Lookup Name: <input type=text name=lname size=20>
<input type=submit value="Lookup">
</form>
Add student record<br>
<form method=get action="s-add-seq-2.adp">
Add Name: <input type=text name=sname size=20>
<input type=submit value="Add">
</form>
<p><hr>
<a href="s-inq.adp">s-inq.adp</a> <a href="index.htm">/tech Home Page</a><p>
</body>
</html>
|
