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