Sorry it took so long to get back to you
I think I may have found what's causing problems.
All of your fields need to be defined in your
html_record_form and should be included in your other forms (can be hidden fields).
What you have now is:
html_record_form: (3 fields)
Name
Major
Classification
sub html_record_edit: (9 fields)
$rec{'ID'}
$rec{'Name'}
$rec{'Phone'}
$rec{'Email'}
$rec{'Resume'}
$rec{'Webpage'}
$rec{'Major'}
$rec{'Classification'}
$rec{'Description'}
sub html_record_long: (8 fields)
$rec{'Name'}
$rec{'Phone'}
$rec{'Email'}
$rec{'Resume'}
$rec{'Webpage'}
$rec{'Major'}
$rec{'Classification'}
$rec{'Description'}
Notice you have a different number of fields defined in each form?
Include all your fields in all your forms and I think this may get your database working correctly.
Also I noticed a few changes you might want to make here:
sub html_page_top {
####################
&html_print_headers;
print qq|
<html><head><title>$html_title: $page_title</title></head>
<body bgcolor="#FFFFFF">
<center><table border=1 bgcolor="#FFFFFF" cellpadding=5 cellspacing=3 width=500>
<TR><TD><i><font color="#0080C0" font size=+1>Guatemala Student Information Database</font></i><br></TD></TR>
<TR><TD> |;
sub html_error_page_top {
########################
&html_print_headers;
print qq|
<html><head><title>$html_title: Error! $page_title</title></head>
<body bgcolor="#DDDDDD">
<center><table border=1 bgcolor="#FFFFFF" cellpadding=5 cellspacing=3 width=500>
<tr><td colspan=2 bgcolor="navy">
<FONT FACE="MS Sans Serif, arial,helvetica" size=1 COLOR="#FFFFFF"><b>$html_title: Error: $page_title</b></font></td></tr>
<tr><td><p><center><B><$font_title>Error:</font> <$error_color>$page_title</font></b></center><br>
</TD></TR><TR><TD> |;
sub html_page_bottom {
#############################
<table border=0 width=100%>
<tr><td align=left><$font>Copyright 1998 <A HREF="http://www.gossamer-threads.com">
Gossamer Threads Inc.</A></font></td>
<td align=right><a href="http://www.gossamer-threads.com/scripts/dbman/"><img src="http://www.gossamer-threads.com/images/powered.gif" border=0 width=100 height=31 alt="Database Powered by
Gossamer Threads Inc."></a></td></tr></table> |;
print qq| </td></tr></table></center></body></html> |;
}
Another tip:
If you use &html_page_top;
and &html_page_bottom;
within your various page displays you can also eliminate having to include the same page headers and footers in your html.pl file and just pull this from one location. It sure saves on the file size
Hope this helps
