MBA 683 E-Business Technology --

s-add-seq-2.adp
 Home    Site Map    Search    EhrlichOrg.com

Syllabus    Classes    References  Examples  Student Info    Guest Info

 

<html>
<head>
<title>Student Add with Sequence page 2</title>
</head>
<body>
It is now <%= [ns_fmttime [ns_time] "%A, %B %e, %Y at %r" ] %><p><hr><p>
<%
set_the_usual_form_variables
# sets sname, QQsname
if { ![info exists sname] } { 
ns_adp_puts "You must enter a name!<br>"
} elseif { $sname=="" } {
ns_adp_puts "Name must not be blank!<br>"
} else {
set seq_val [db_nextval usf_seq]
db_dml s_row "insert into chuck.s (sid, sname) values 
($seq_val,'$QQsname')"
ns_adp_puts "<p>Added $seq_val: $sname<p>"
}
%>
<hr></body></html>

 

© 2001 by Chuck Ehrlich, all rights reserved.  Comments to webmaster.  Updated on September 26, 2000.