herschelrj
Programmer
I am trying to take some form data and put it into an Access database on the webserver. Any help??? I was using Frontpage but now Dreamweaver. Here is the code for the form...
<form method="POST" action="sh_reg.asp" name="FrontPage_Form1" language="JavaScript" onSubmit="return FrontPage_Form1_Validator(this)" webbot-action="--WEBBOT-SELF--">
<!--webbot bot="SaveDatabase" SuggestedExt="asp" U-ASP-Include-Url="../_fpclass/fpdbform.inc" S-DataConnection="sh_registration" S-RecordSource="sex_harras" U-Database-URL="fpdb/sh_registration.mdb" U-Confirmation-Url="sh_conf.asp" S-Builtin-Fields="HTTP_USER_AGENT REMOTE_HOST Timestamp REMOTE_USER" S-Builtin-DBFields="Browser_type Remote_computer_name2 Timestamp User_name" S-Form-Fields="deptid email last first jobtitle department course_id emplid" S-Form-DBFields="deptID email last_name first_name Jobtitle department session emplID" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" i-checksum="34604" endspan --> <!--mstheme--></font><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%" id="AutoNumber2">
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">EMPLID*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="EMPLID" s-data-type="Number" s-number-separators="x." b-value-required="TRUE" i-minimum-length="6" i-maximum-length="6" s-validation-constraint="Greater than or equal to" s-validation-value="100000" s-validation-constraint="Less than or equal to" s-validation-value="200000" --><input type="text" name="emplid" size="20" maxlength="6"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">Last*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="last" b-value-required="TRUE" --><input type="text" name="last" size="20"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">First*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="first" b-value-required="TRUE" --><input type="text" name="first" size="20"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">DeptID*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-data-type="Number" s-number-separators="x." b-value-required="TRUE" i-minimum-length="4" i-maximum-length="4" --><input type="text" name="deptid" size="20" maxlength="4"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">Department*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="department" b-value-required="TRUE" --><input type="text" name="department" size="20"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">JobTitle*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="jobtitle" b-value-required="TRUE" --><input type="text" name="jobtitle" size="20"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">EMAIL</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<input type="text" name="email" size="20"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">Session</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="course Id" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="course_id">
<option>Select Session</option>
<option>001S</option>
<option>002S</option>
<option>003S</option>
<option>004S</option>
<option>001B</option>
<option>002B</option>
<option>003B</option>
<option>004B</option>
<option>005B</option>
<option>006B</option>
<option>007B</option>
<option>008B</option>
</select> <!--mstheme--></font></td>
</tr>
</table><!--mstheme--><font face="Arial, Arial, Helvetica">
<p>
<label>
<input type="submit" name="Submit" value="Submit">
</label>
<input type="reset" value="Reset" name="B2">
</p>
</form>
Any help appreciated.
<form method="POST" action="sh_reg.asp" name="FrontPage_Form1" language="JavaScript" onSubmit="return FrontPage_Form1_Validator(this)" webbot-action="--WEBBOT-SELF--">
<!--webbot bot="SaveDatabase" SuggestedExt="asp" U-ASP-Include-Url="../_fpclass/fpdbform.inc" S-DataConnection="sh_registration" S-RecordSource="sex_harras" U-Database-URL="fpdb/sh_registration.mdb" U-Confirmation-Url="sh_conf.asp" S-Builtin-Fields="HTTP_USER_AGENT REMOTE_HOST Timestamp REMOTE_USER" S-Builtin-DBFields="Browser_type Remote_computer_name2 Timestamp User_name" S-Form-Fields="deptid email last first jobtitle department course_id emplid" S-Form-DBFields="deptID email last_name first_name Jobtitle department session emplID" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" i-checksum="34604" endspan --> <!--mstheme--></font><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%" id="AutoNumber2">
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">EMPLID*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="EMPLID" s-data-type="Number" s-number-separators="x." b-value-required="TRUE" i-minimum-length="6" i-maximum-length="6" s-validation-constraint="Greater than or equal to" s-validation-value="100000" s-validation-constraint="Less than or equal to" s-validation-value="200000" --><input type="text" name="emplid" size="20" maxlength="6"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">Last*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="last" b-value-required="TRUE" --><input type="text" name="last" size="20"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">First*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="first" b-value-required="TRUE" --><input type="text" name="first" size="20"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">DeptID*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-data-type="Number" s-number-separators="x." b-value-required="TRUE" i-minimum-length="4" i-maximum-length="4" --><input type="text" name="deptid" size="20" maxlength="4"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">Department*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="department" b-value-required="TRUE" --><input type="text" name="department" size="20"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">JobTitle*</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="jobtitle" b-value-required="TRUE" --><input type="text" name="jobtitle" size="20"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">EMAIL</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<input type="text" name="email" size="20"> <!--mstheme--></font></td>
</tr>
<tr>
<td width="32%"><!--mstheme--><font face="Arial, Arial, Helvetica">
<font color="#000080">Session</font> <!--mstheme--></font></td>
<td width="68%"><!--mstheme--><font face="Arial, Arial, Helvetica"> <!--webbot bot="Validation" s-display-name="course Id" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="course_id">
<option>Select Session</option>
<option>001S</option>
<option>002S</option>
<option>003S</option>
<option>004S</option>
<option>001B</option>
<option>002B</option>
<option>003B</option>
<option>004B</option>
<option>005B</option>
<option>006B</option>
<option>007B</option>
<option>008B</option>
</select> <!--mstheme--></font></td>
</tr>
</table><!--mstheme--><font face="Arial, Arial, Helvetica">
<p>
<label>
<input type="submit" name="Submit" value="Submit">
</label>
<input type="reset" value="Reset" name="B2">
</p>
</form>
Any help appreciated.