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

Sample JavaScript

Go to | addrecord.cfm | insert_complete.html |

<!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="queryparticipants" 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>
Last Name: <cfinput type="text" NAME="LASTNAME" maxlength="50" size="30"/>
<p align="center">
<cfinput NAME="submit" type="submit" value="Find Records"> <cfinput NAME="clear" type="reset" value="Clear">
</cfform>

<cfquery name="queryparticipants" datasource="#d_oracle#" username="#u_oracle#" password="#p_oracle#" DEBUG>
    SELECT LASTNAME,FIRSTNAME,DEPT FROM CLASS WHERE LASTNAME='#Form.LASTNAME#'
</cfquery>
<p>

<table><tbody>
<cfoutput query="queryparticipants">
     <tr><td>#LASTNAME#</td><td> </td><td>#FIRSTNAME#</td><td> </td><td>#DEPT#</td></tr>
</cfoutput>


<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, "addrecord.cfm". That code is below.

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

<cfquery name="add_participants" datasource="#d_oracle#" username="#u_oracle#" password="#p_oracle#" DEBUG>
INSERT INTO CLASS (LASTNAME, FIRSTNAME, DEPT, YEAR) VALUES ('#LASTNAME#', '#FIRSTNAME#', '#DEPT#','#YEAR#')
</cfquery>

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

</body>
</html>


In addition, you need to create the greeting page, "insert_complete.html". That code is below.

<!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="50%">Thank You!<p>
    You have just inserted a row into our table. <p>
    To view the result, check the <a href="http://thatcher.umsl.edu/~sauterv/twentytwo.cfm">query example</a>.

</tbody></table>
</center>
<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>


Return to Index


| 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.