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