Here's the code below and I do have it set to check all inputs since the fields are all required. This may be the problem. I would really appreciate if someone can check it and let me know what's wrong. By the way, thanks GunJack for your help with my previous post on formatting an IP . I decided to change the datatype to CHAR makes it easier to retrieve and am using this javascript to check for formatting the IP.
thanks,
Olmos
<CFPARAM NAME="action" DEFAULT=" ">
<CFQUERY NAME="qry_fn_id" DATASOURCE="IT" dbtype="Oracle80">
SELECT max(FN_ID) AS maxFN_ID
FROM scott.f_natl
</CFQUERY>
<CFSET l_fn_id = qry_fn_id.maxFN_ID>
<CFIF action EQ "insert">
<CFTRANSACTION>
<CFQUERY NAME="qry_fn_id" DATASOURCE="IT" dbtype="Oracle80">
SELECT max(FN_ID) AS maxFN_ID
FROM scott.f_natl
</CFQUERY>
<CFSET l_fn_id = qry_fn_id.maxFN_ID>
<CFQUERY NAME="ADDCOMPUTER" DATASOURCE="IT" dbtype="Oracle80">
INSERT INTO scott.fn_computer
( FN_ID, COMPUTER_NO, SYSTEM_NAME, SYSTEM_IP )
VALUES
( #l_fn_id#, '#Form.COMPUTER_NO#', '#Form.SYSTEM_NAME#', '#Form.SYSTEM_IP#')
</CFQUERY>
</CFTRANSACTION>
</CFIF>
<CFIF #ParameterExists(EditComputer)# IS "Yes">
<CFQUERY NAME="UpdateComputer" DATASOURCE="IT" dbtype="Oracle80">
UPDATE scott.fn_computer
SET FN_ID=#l_fn_id#, COMPUTER_NO = '#form.COMPUTER_NO#', SYSTEM_NAME = '#form.SYSTEM_NAME#', SYSTEM_IP= #form.SYSTEM_IP#
WHERE fn_computer.FN_COMPUTER_ID = #form.FN_COMPUTER_ID#
</CFQUERY>
</CFIF>
<CFIF #ParameterExists(DeleteComputer)# IS "Yes">
<CFQUERY NAME="DeleteComputer" DATASOURCE="IT" dbtype="Oracle80">
DELETE FROM scott.fn_computer
WHERE fn_computer.FN_COMPUTER_ID = #form.FN_COMPUTER_ID#
</CFQUERY>
</CFIF>
<CFTRANSACTION>
<CFQUERY NAME="qry_fn_id" DATASOURCE="IT" dbtype="Oracle80">
SELECT max(FN_ID) AS maxFN_ID
FROM scott.f_natl
</CFQUERY>
<CFSET l_fn_id = qry_fn_id.maxFN_ID>
<CFQUERY NAME="SHOWRECORDS" DATASOURCE="IT" dbtype="Oracle80">
SELECT f_natl.sponsor_name, f_natl.visitor_name, fn_computer.FN_COMPUTER_ID, fn_computer.FN_ID, fn_computer.COMPUTER_NO , fn_computer.SYSTEM_NAME, fn_computer.SYSTEM_IP
FROM scott.f_natl , scott.fn_computer
WHERE f_natl.FN_ID = fn_computer.FN_ID
AND fn_computer.FN_ID = #l_fn_id#
</CFQUERY>
</CFTRANSACTION>
<HTML>
<HEAD>
<TITLE>
</TITLE>
<script language="JavaScript1.2"><!--
function validate(form) {
var str = form.system_ip.value;
var re = /^[1-9]{3}\.[0-9]{1,}\.[0-9]{1,}\.[0-9]{1,}/;
if (form.system_ip.value == ""
{
alert("Please enter your System IP address."
;
form.system_ip.focus();
return false;
}
if (re.test(str)) {
return true;
}
alert("" + str + " is an invalid IP Address!"
;
form.system_ip.select();
form.system_ip.focus();
return false;
}
// --></script>
</HEAD>
<BODY>
<form ACTION="formgrid.cfm" method="post" onSubmit="return validate(this)">
<INPUT TYPE="hidden" NAME="action" VALUE="edit">
<INPUT TYPE="hidden" NAME="action" VALUE="#qry_fn_id.l_fn_id#">
<CENTER>
<H1>Computer Access</H1>
</CENTER>
<P>
<CFOUTPUT QUERY="SHOWRECORDS">
<H2>Computer List: </h2>
<INPUT TYPE= "hidden" NAME="fn_computer_id" VALUE= "#fn_computer_id#">
<TABLE border="1">
<TR>
<TH></TH>
<TH></TH>
<TH>FN_ID</TH>
<TH>COMP. NUMBER</TH>
<TH>SYSTEM NAME</TH>
<TH>SYSTEM IP</TH>
</TR>
<TR>
<TD><A HREF="editformgrid2.cfm?fn_computer_id=#fn_computer_id#"><FONT SIZE=-1>[EDIT]</FONT></A></TD>
<TD><A HREF="deleteformgrid2.cfm?fn_computer_id=#fn_computer_id#"><FONT SIZE=-1>[DELETE]</FONT></A></TD>
<TD>#FN_ID#</TD>
<TD>#COMPUTER_NO#</TD>
<TD>#SYSTEM_NAME#</TD>
<TD>#SYSTEM_IP#</TD>
</TR>
</form>
<FORM ACTION="submitcomplete2.cfm" method="post" >
Click done when computer list is complete <INPUT TYPE="submit" VALUE="Done">
</form>
</CFOUTPUT>
</TABLE>
</form>
<HR>
<H2>Enter New Computer Information:</H2>
<p>
<FORM NAME = "computerinfo" ACTION="formgrid2.cfm" method="post" onSubmit="return validate(this)">
<INPUT TYPE="hidden" NAME="action" VALUE="insert">
<INPUT TYPE= "hidden" NAME="fn_id" VALUE= "#fn_id#">
<INPUT TYPE= "hidden" NAME="fn_computer_id" VALUE= "#fn_computer_id#">
<INPUT TYPE="hidden" NAME="COMPUTER_NO_required" VALUE="Missing Computer Number">
<INPUT TYPE="hidden" NAME="SYSTEM_NAME_required" VALUE="Missing System Name">
<INPUT TYPE="hidden" NAME="SYSTEM_IP_required" VALUE="Missing System IP">
<table width="100%" align = "center" border = "1" cellpadding=2 cellspacing=2 bgcolor=#ffffcc>
<INPUT TYPE= "hidden" NAME="fn_id" VALUE= "#fn_id#">
<INPUT TYPE= "hidden" NAME="fn_computer_id" VALUE= "#fn_computer_id#">
<tr>
<td>
<font size=-1><a href="computer_no.html" target="_blank">* COMPUTER_</a></font><br>
<input type=text size=15 maxlength=9 name="COMPUTER_NO" >
</td>
<td><font size=-1><a href="system_ip.html" target="_blank">* IP ADDRESS OF SYSTEMS</a></font><br>
<input type=text size=15 maxlength=15 name="SYSTEM_IP" >
</td>
<td><font size=-1><a href="name_of_systems.html" target="_blank">* NAME OF SYSTEM</a></font><br>
<input type=text size=30 maxlength=30 name="SYSTEM_NAME" >
</td>
</tr>
</table>
<INPUT TYPE="submit" VALUE="Add Computer to list" >
</FORM>
<FORM ACTION="submitcomplete2.cfm" method="post">
Click done when computer list is complete
<INPUT TYPE="submit" VALUE="Done">
</form>
</BODY>
</HTML>
