Information Systems
College of Business Administration
University of Missouri - St. Louis

Sample JavaScript

Go to | deleterecord.cfm |

<!DOCTYPE HTML PUBLIC "-     //W3C     //DTD HTML 4.0 Transitional     //EN"><html><head>
<meta name="MSSmartTagsPreventParsing" content="TRUE">
<link rel="SHORTCUT ICON" href="graphics/dss.ico">
<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>
<title>JavaScript Examples</title>
</head>


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

<table bgcolor="#bde7b7" width="100%"><tbody><tr><td>
<center><table cellpadding="5" bgcolor="#bde7b7">
<tbody><tr>

     <td><center><a href="http://www.umsl.edu/business/mis/">Information Systems</font></a></i></center></td>
     <td width="45"></td>
     <td><center><a href="http://www.umsl.edu/business/General_Business.html">College of Business Administration</a></i></center></td>
     <td width="40"></td>
     <td><center><a href="http://www.umsl.edu/">University of Missouri - St. Louis</a></i></center></td>
</tr>
</tbody></table></center></td></tr></tbody></table>


</font><h2><center>Sample JavaScript</font></center></h2>

<center>

<table width="90%" bgcolor="#bde7b7" border="2" cellpadding="15">
<tbody><tr>
<td width="100%">
<cfform name="deleteparticipants" action="deleterecord.cfm" method="post" datasource="#d_oracle#" username="#u_oracle#" password="#p_oracle#" DEBUG>
<center><table cellpadding=5 border><tr><td>
<center>Please Complete the Following Form</center><p>

First Name: <cfinput type="text" NAME="FIRSTNAME" maxlength="50" size="30"/><p>
Last Name: <cfinput type="text" NAME="LASTNAME" LABEL="Last Name: " maxlength="50" size="30"/>

<p align="center"><cfinput NAME="submit" type="submit" value="Delete Records"> <cfinput NAME="clear" type="reset" value="Clear">
</cfform>


<p><hr><p>

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

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

<p><hr><p>
<center>| <a href="http://www.umsl.edu/index.html">UM-St. Louis Home Page</a>
| <a href="http://www.umsl.edu/business/General_Business.html">College of Business Page</a> |
<a href="http://www.umsl.edu/business/mis/index.html">IS
Home Page</a> |</center>
<p><hr><p>

<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>
<br>Page Owner: <a href="http://www.umsl.edu/%7Esauter/">Professor Sauter</a>
(<a href="mailto:Vicki.Sauter@umsl.edu">Vicki.Sauter@umsl.edu</a>)<br>
</i>© Vicki L. Sauter. All rights reserved.

</body></html>

In addition, you need to create an additional file, "deleterecord.cfm". That code is below.

<html>
<head>
<title>Cold Fusion Sample</title>
</head>
<body>

<cfquery name="deleteparticipants" datasource="#d_oracle#" username="#u_oracle#" password="#p_oracle#" DEBUG>
DELETE FROM CLASS WHERE LASTNAME='#LASTNAME#' AND FIRSTNAME='#FIRSTNAME#'>
</cfquery>

<script>
open ("http://www.umsl.edu/~sauterv/help/javascript/samples/delete_complete.html")
</script>

</body>
</html>

| UM-St. Louis Home Page | College of Business Page | IS Home Page |


Page Owner: Professor Sauter (Vicki.Sauter@umsl.edu)
© Vicki L. Sauter. All rights reserved.