Decision Support Systems For Business Intelligence
    by Vicki L. Sauter

 
 
CodeBox 3.4

<!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>Insert into the Database Statement</big></center>

           
<cfquery name="add_cars" datasource="#d_oracle#" username="#u_oracle#" password="#p_oracle#" DEBUG>
INSERT INTO possible_car
(make, model, base_price, cafe_mpg )
VALUES ('#manufacturer#', '#model#', '#price#','#mpg#')
</cfquery>                                                                   

 

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