Decision Support Systems For Business Intelligence
    by Vicki L. Sauter

 
 
Codebox 5.1

<!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>Sample Select A</big></center>

<cfform name="example_input_c" method="post" datasource="#d_oracle#" username="#u_oracle#" password="#p_oracle#" DEBUG>
<center>
What make of automobile is of interest to you?<small>select only one</small><br>
<cfinput type="radio" name="car_preference" value="audi">Audi<br>
<cfinput type="radio" name="car_preference" value="chevrolet">Chevrolet<br>
<cfinput type="radio" name="car_preference" value="dodge">Dodge<br>
<cfinput type="radio" name="car_preference" value="ford">Ford<br>
<cfinput type="radio" name="car_preference" value="mercedes">Mercedes<br>
<cfinput type="radio" name="car_preference" value="toyota">Toyota<br>
<cfinput type="radio" name="car_preference" value="bmw">BMW
</center>
<p align=right>
<input name="submit" type="submit" value="Start the Search!">
</cfform>

            <cfquery name="possible_cars" datasource="#d_oracle#" username="#u_oracle#" password="#p_oracle#" DEBUG>
SELECT model FROM new_cars WHERE model=’#Form.car_preference#’
</cfquery>

<ul>
<cfoutput query="possible_cars">
<li>#model#</li>
</cfoutput>
</ul>

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