jmlawry
04-23-2006, 02:14 AM
I am having trouble with this page loading it is a page designed by access2asp which is good software so far. It has turned my access database into an asp page. But I cannot get my addform page to verify the information I entered it will not load after I enter the information so I am not sure if the code is off or what . I am including the code below and would greatly appericate some help with it. Thanks in advance for taking the time to read this message, and answering my questions if you possible can.
Thanks again,
Jean :rolleyes:
Here is the code:
<!-- #include file=utils.asp -->
<html>
<head>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1 ">
<meta name="GENERATOR" content="access2asp">
<script language="javascript">
function openImageLibrary(){
myWin=open("default_image.asp" ,"Images","width=450,height=460,status=no,toolbar=no,menubar=no,scrollbars=yes"); }
</script>
<script language="Javascript1.2"><!-- // load htmlarea
_editor_url = "htmlarea/"; // URL to htmlarea files
var win_ie_ver = parseFloat(navigator.appVersion.split("MSIE")[1]);
if (navigator.userAgent.indexOf('Mac') >= 0) { win_ie_ver = 0; }
if (navigator.userAgent.indexOf('Windows CE') >= 0) { win_ie_ver = 0; }
if (navigator.userAgent.indexOf('Opera') >= 0) { win_ie_ver = 0; }
if (win_ie_ver >= 5.5) {
document.write('<scr' + 'ipt src="' +_editor_url+ 'editor.js"');
document.write(' language="Javascript1.2"></scr' + 'ipt>');
} else { document.write('<scr'+'ipt>function editor_generate() { return false; }</scr'+'ipt>'); }
// -->
</script>
<link rel="stylesheet" type="text/css" href="fontcss.css" />
<title>tbl-SteinDataBase</title>
</head>
<body><center>
<!-- #include file ="header.asp" -->
<form method= post action=tbl-SteinDataBaseAddForm.asp onSubmit="return validateForm();" name=tbl-SteinDataBase> <table width=80%>
<!-- #include file ="sec.asp" -->
<tr><td><b><a href="javascript:openImageLibrary();">image library</a></b><br><br></td></tr>
<tr><td colspan=2><a href=tbl-SteinDataBaseListadmin.asp><< back to List screen</a><br><br></td></tr>
<tr><td colspan=2> <b>Insert new record into tbl-SteinDataBase</b><br></td></tr>
<tr><td></td><td><input type="hidden" name="txtID" size=30></td></tr>
<tr><td>ProductId</td><td><input type="text" name="txtProductId" size="30" maxlength="255"></td></tr>
<tr><td>Brewer</td><td><input type="text" name="txtBrewer" size="30" maxlength="50"></td></tr>
<tr><td>ProductName</td><td><input type="text" name="txtProductName" size="30" maxlength="255"></td></tr>
<tr><td>Series</td><td><input type="text" name="txtSeries" size="30" maxlength="50"></td></tr>
<tr><td>Year</td><td><input type="text" name="txtYear" size="30" maxlength="30"></td></tr>
<tr><td>QntyMade</td><td><input type="text" name="txtQntyMade" size="30" maxlength="255"></td></tr>
<tr><td>Of</td><td><input type="text" name="txtOf" size="30" maxlength="255"></td></tr>
<tr><td>Soldfor</td><td><input type="text" name="txtSoldfor" size="30" maxlength="30"></td></tr>
<tr><td>CurrentValue</td><td><input type="text" name="txtCurrentValue" size="30" maxlength="255"></td></tr>
<tr><td>Height</td><td><input type="text" name="txtHeight" size="30" maxlength="50"></td></tr>
<tr><td>Material</td><td><input type="text" name="txtMaterial" size="30" maxlength="255"></td></tr>
<tr><td>Manufacture</td><td><input type="text" name="txtManufacture" size="30" maxlength="50"></td></tr>
<tr><td>Artist</td><td><input type="text" name="txtArtist" size="30" maxlength="255"></td></tr>
<tr><td>Designer</td><td><input type="text" name="txtDesigner" size="30" maxlength="50"></td></tr>
<tr><td>Certificate</td><td><input type="text" name="txtCertificate" size="30" maxlength="50"></td></tr>
<tr><td>Gift</td><td><input type="text" name="txtGift" size="30" maxlength="50"></td></tr>
<tr><td>IndNumb</td><td><input type="text" name="txtIndNumb" size="30" maxlength="50"></td></tr>
<tr><td>Description</td><td><textarea name="txtDescription" cols="55" rows="15"></textarea></td></tr>
<script language="javascript1.2">
editor_generate('txtDescription');
</script>
<tr><td>SpecNotes</td><td><textarea name="txtSpecNotes" cols="55" rows="15"></textarea></td></tr>
<script language="javascript1.2">
editor_generate('txtSpecNotes');
</script>
<tr><td></td><td><input type="submit" value="Submit" name="submit"></td></tr>
<tr><td colspan="2"><br><br><font size="1" color="red">*</font><font size="1"> required field.</font></td></tr>
</table>
<!-- #include file ="footer.asp" -->
</center></form></body></html>
<% 'sql statement that gets passed to xrecord function in utils.asp
sub doRecord()
strSql="Insert into [tbl-SteinDataBase](ProductId,Brewer,ProductName,Series,Year,QntyMade,Of,Soldfor,CurrentValue,Height,Material,Manufactu re,Artist,Designer,Certificate,Gift,IndNumb,Description,SpecNotes) values( "& "'" & replace(request.form("txtProductId"),"'","''") & "',"& "'" & replace(request.form("txtBrewer"),"'","''") & "',"& "'" & replace(request.form("txtProductName"),"'","''") & "',"& "'" & replace(request.form("txtSeries"),"'","''") & "'," & request.form("txtYear")& ","& "'" & replace(request.form("txtQntyMade"),"'","''") & "',"& "'" & replace(request.form("txtOf"),"'","''") & "'," & request.form("txtSoldfor")& ","& "'" & replace(request.form("txtCurrentValue"),"'","''") & "',"& "'" & replace(request.form("txtHeight"),"'","''") & "',"& "'" & replace(request.form("txtMaterial"),"'","''") & "',"& "'" & replace(request.form("txtManufacture"),"'","''") & "',"& "'" & replace(request.form("txtArtist"),"'","''") & "',"& "'" & replace(request.form("txtDesigner"),"'","''") & "',"& "'" & replace(request.form("txtCertificate"),"'","''") & "',"& "'" & replace(request.form("txtGift"),"'","''") & "',"& "'" & replace(request.form("txtIndNumb"),"'","''") & "',"& "'" & replace(request.form("txtDescription"),"'","''") & "',"& "'" & replace(request.form("txtSpecNotes"),"'","''") & "')"
xRecord strSql,"tbl-SteinDataBaseListadmin.asp?s=1"
end sub %>
<!-- java script validation -->
<script type="text/javascript">
function validateForm() {
if (document.forms[0].txtYear.value=="")
{document.forms[0].txtYear.value=0}
if (isNaN(document.forms[0].txtYear.value)){self.alert("Please enter a numeric value in Year!");
document.forms[0].txtYear.focus();
return false; }
if (document.forms[0].txtSoldfor.value=="")
{document.forms[0].txtSoldfor.value=0}
if (isNaN(document.forms[0].txtSoldfor.value)){self.alert("Please enter a numeric value in Soldfor!");
document.forms[0].txtSoldfor.focus();
return false; }
}</script>
Thanks again,
Jean :rolleyes:
Here is the code:
<!-- #include file=utils.asp -->
<html>
<head>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1 ">
<meta name="GENERATOR" content="access2asp">
<script language="javascript">
function openImageLibrary(){
myWin=open("default_image.asp" ,"Images","width=450,height=460,status=no,toolbar=no,menubar=no,scrollbars=yes"); }
</script>
<script language="Javascript1.2"><!-- // load htmlarea
_editor_url = "htmlarea/"; // URL to htmlarea files
var win_ie_ver = parseFloat(navigator.appVersion.split("MSIE")[1]);
if (navigator.userAgent.indexOf('Mac') >= 0) { win_ie_ver = 0; }
if (navigator.userAgent.indexOf('Windows CE') >= 0) { win_ie_ver = 0; }
if (navigator.userAgent.indexOf('Opera') >= 0) { win_ie_ver = 0; }
if (win_ie_ver >= 5.5) {
document.write('<scr' + 'ipt src="' +_editor_url+ 'editor.js"');
document.write(' language="Javascript1.2"></scr' + 'ipt>');
} else { document.write('<scr'+'ipt>function editor_generate() { return false; }</scr'+'ipt>'); }
// -->
</script>
<link rel="stylesheet" type="text/css" href="fontcss.css" />
<title>tbl-SteinDataBase</title>
</head>
<body><center>
<!-- #include file ="header.asp" -->
<form method= post action=tbl-SteinDataBaseAddForm.asp onSubmit="return validateForm();" name=tbl-SteinDataBase> <table width=80%>
<!-- #include file ="sec.asp" -->
<tr><td><b><a href="javascript:openImageLibrary();">image library</a></b><br><br></td></tr>
<tr><td colspan=2><a href=tbl-SteinDataBaseListadmin.asp><< back to List screen</a><br><br></td></tr>
<tr><td colspan=2> <b>Insert new record into tbl-SteinDataBase</b><br></td></tr>
<tr><td></td><td><input type="hidden" name="txtID" size=30></td></tr>
<tr><td>ProductId</td><td><input type="text" name="txtProductId" size="30" maxlength="255"></td></tr>
<tr><td>Brewer</td><td><input type="text" name="txtBrewer" size="30" maxlength="50"></td></tr>
<tr><td>ProductName</td><td><input type="text" name="txtProductName" size="30" maxlength="255"></td></tr>
<tr><td>Series</td><td><input type="text" name="txtSeries" size="30" maxlength="50"></td></tr>
<tr><td>Year</td><td><input type="text" name="txtYear" size="30" maxlength="30"></td></tr>
<tr><td>QntyMade</td><td><input type="text" name="txtQntyMade" size="30" maxlength="255"></td></tr>
<tr><td>Of</td><td><input type="text" name="txtOf" size="30" maxlength="255"></td></tr>
<tr><td>Soldfor</td><td><input type="text" name="txtSoldfor" size="30" maxlength="30"></td></tr>
<tr><td>CurrentValue</td><td><input type="text" name="txtCurrentValue" size="30" maxlength="255"></td></tr>
<tr><td>Height</td><td><input type="text" name="txtHeight" size="30" maxlength="50"></td></tr>
<tr><td>Material</td><td><input type="text" name="txtMaterial" size="30" maxlength="255"></td></tr>
<tr><td>Manufacture</td><td><input type="text" name="txtManufacture" size="30" maxlength="50"></td></tr>
<tr><td>Artist</td><td><input type="text" name="txtArtist" size="30" maxlength="255"></td></tr>
<tr><td>Designer</td><td><input type="text" name="txtDesigner" size="30" maxlength="50"></td></tr>
<tr><td>Certificate</td><td><input type="text" name="txtCertificate" size="30" maxlength="50"></td></tr>
<tr><td>Gift</td><td><input type="text" name="txtGift" size="30" maxlength="50"></td></tr>
<tr><td>IndNumb</td><td><input type="text" name="txtIndNumb" size="30" maxlength="50"></td></tr>
<tr><td>Description</td><td><textarea name="txtDescription" cols="55" rows="15"></textarea></td></tr>
<script language="javascript1.2">
editor_generate('txtDescription');
</script>
<tr><td>SpecNotes</td><td><textarea name="txtSpecNotes" cols="55" rows="15"></textarea></td></tr>
<script language="javascript1.2">
editor_generate('txtSpecNotes');
</script>
<tr><td></td><td><input type="submit" value="Submit" name="submit"></td></tr>
<tr><td colspan="2"><br><br><font size="1" color="red">*</font><font size="1"> required field.</font></td></tr>
</table>
<!-- #include file ="footer.asp" -->
</center></form></body></html>
<% 'sql statement that gets passed to xrecord function in utils.asp
sub doRecord()
strSql="Insert into [tbl-SteinDataBase](ProductId,Brewer,ProductName,Series,Year,QntyMade,Of,Soldfor,CurrentValue,Height,Material,Manufactu re,Artist,Designer,Certificate,Gift,IndNumb,Description,SpecNotes) values( "& "'" & replace(request.form("txtProductId"),"'","''") & "',"& "'" & replace(request.form("txtBrewer"),"'","''") & "',"& "'" & replace(request.form("txtProductName"),"'","''") & "',"& "'" & replace(request.form("txtSeries"),"'","''") & "'," & request.form("txtYear")& ","& "'" & replace(request.form("txtQntyMade"),"'","''") & "',"& "'" & replace(request.form("txtOf"),"'","''") & "'," & request.form("txtSoldfor")& ","& "'" & replace(request.form("txtCurrentValue"),"'","''") & "',"& "'" & replace(request.form("txtHeight"),"'","''") & "',"& "'" & replace(request.form("txtMaterial"),"'","''") & "',"& "'" & replace(request.form("txtManufacture"),"'","''") & "',"& "'" & replace(request.form("txtArtist"),"'","''") & "',"& "'" & replace(request.form("txtDesigner"),"'","''") & "',"& "'" & replace(request.form("txtCertificate"),"'","''") & "',"& "'" & replace(request.form("txtGift"),"'","''") & "',"& "'" & replace(request.form("txtIndNumb"),"'","''") & "',"& "'" & replace(request.form("txtDescription"),"'","''") & "',"& "'" & replace(request.form("txtSpecNotes"),"'","''") & "')"
xRecord strSql,"tbl-SteinDataBaseListadmin.asp?s=1"
end sub %>
<!-- java script validation -->
<script type="text/javascript">
function validateForm() {
if (document.forms[0].txtYear.value=="")
{document.forms[0].txtYear.value=0}
if (isNaN(document.forms[0].txtYear.value)){self.alert("Please enter a numeric value in Year!");
document.forms[0].txtYear.focus();
return false; }
if (document.forms[0].txtSoldfor.value=="")
{document.forms[0].txtSoldfor.value=0}
if (isNaN(document.forms[0].txtSoldfor.value)){self.alert("Please enter a numeric value in Soldfor!");
document.forms[0].txtSoldfor.focus();
return false; }
}</script>