Decision Support Systems For Business Intelligence
    by Vicki L. Sauter

 
 
CodeBox 3.5

<!DOCTYPE HTML PUBLIC "-     //W3C     //DTD HTML 4.0 Transitional     //EN"><html><head>
<meta name="MSSmartTagsPreventParsing" content="TRUE">
<title>JavaScript Examples</title>
<STYLE TYPE="text/css">
<!--
   H1, H2, H3, H4, H5, H6 {font-family:"Arial"}
   td {font-family:"Arial"}
   td {font--size: 10pt}
   td {font-weight: bold}
   td {border-width: 2px}
   table {border-color: #8D89C7}                                                                                  
   body {font-family:"Arial"; font-size: 10pt; font-weight:bold}
   p {font-family:"Arial"; font-size: 10pt; font-weight:bold}
-->
</STYLE>
</head>

<body text="#000080" vlink="#000080" background="graphics/background2.gif" link="#000080">
<center><big>Using Forms</big></center>

           
<cfform name="possible_cars" action="addrecord.cfm" method="post" datasource="#d_oracle#" username="#u_oracle#" password="#p_oracle#" DEBUG>

<center><table cellpadding=5 border><tbody>
<tr><td>
<center>Please Complete the Following Form</center><p>
Manufacturer: <CFINPUT TYPE="text" NAME="manufacturer" MAXLENGTH="50" SIZE="30"/><p>
Model: <CFINPUT TYPE="text" NAME="model" MAXLENGTH="50" SIZE="30"/><p>
Base Price: <CFINPUT TYPE="text" NAME="price" MAXLENGTH="4" SIZE="4"/><p>
CAFE-MPG: <CFINPUT TYPE="text" NAME="mpg" MAXLENGTH="4" SIZE="4"/>
<br>
<p align="center">
<CFINPUT NAME="submit" TYPE="submit" VALUE="Save">
<CFINPUT NAME="clear" TYPE="reset" VALUE="Clear">
</cfform>

                        </td></tr>
</tbody></table>
</center>

 

<p><hr><p>
<img src="graphics/button2.jpg" width = 20> <a href="index.html">Return to Index</a>

<small>
<script language="JavaScript">
// This automatically updates the last modified date for the page.
//
when = document.lastModified
document.write("This page was last modified on: " + when + "<br>")
//
// This automatically updates the location documentation on the page.
where = document.location
document.write("URL: " + where)
</script>

</body>
</html>


<!DOCTYPE HTML PUBLIC "-     //W3C     //DTD HTML 4.0 Transitional     //EN"><html><head>
<meta name="MSSmartTagsPreventParsing" content="TRUE">
<title>JavaScript Examples</title>
<STYLE TYPE="text/css">
<!--
H1, H2, H3, H4, H5, H6 {font-family:"Arial"}
td {font-family:"Arial"}
td {font--size: 10pt}
td {font-weight: bold}
td {border-width: 2px}
table {border-color: #8D89C7}
body {font-family:"Arial"; font-size: 10pt; font-weight:bold}
p {font-family:"Arial"; font-size: 10pt; font-weight:bold}
-->
</STYLE>
</head>

<body text="#000080" vlink="#000080" background="graphics/background2.gif" link="#000080">
<center><big>Select car to be Deleted Statement</big></center>

            <cfquery name="possible_cars" datasource="#d_oracle#" username="#u_oracle#" password="#p_oracle#" DEBUG>
SELECT make, model, base_price, cafe_mpg FROM possible_cars
</cfquery>

            <table><tbody>
<cfform name="possible_cars" action="deleterecord.cfm" method="post">
<tr>  <td>#make#</td>   <td width=5> </td>   <td>#model#</td>   <td width=5> </td>   <td>#base_price#</td>        <td width=5> </td>    <td>#cafe_mpg#</td>      <td width=5> </td>
<td><CFINPUT TYPE=”radio” NAME= “request_delete"  VALUE=”#model#”></td>
</tr>
</cfoutput>
</tbody></table>

 

<p><hr><p>
<img src="graphics/button2.jpg" width = 20> <a href="index.html">Return to Index</a>

<small>
<script language="JavaScript">
// This automatically updates the last modified date for the page.
//
when = document.lastModified
document.write("This page was last modified on: " + when + "<br>")
//
// This automatically updates the location documentation on the page.
where = document.location
document.write("URL: " + where)
</script>

</body>
</html>

 

   Page Owner: Professor Sauter (Vicki.Sauter AT umsl.edu)