freelanceprogrammers.org Forum Index » Cold Fusion

View previous topic :: View next topic
Post new topic   Reply to topic

Need Assistance


View user's profile Post To page top
parkwood149 Posted: Thu May 19, 2005 2:09 am


Joined: 19 May 2005

Posts: 1
Need Assistance
I am trying to contain the output to a single page using a form drop
down box. Based on the user selection, a query will display the results.

for example if there were 50 states, i select NY, now the results
would display the cities within NY.

Can someone help. I am getting myself confused.

<html>

<head>
<title>books</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">




<script language="JavaScript">
if (form.option[selectedindex].value = `audio` )
{
<cfquery datasource="Book_DB" name="Select_data" >
select * From Prsa_Green
where Audio = 1
</cfquery>
}<cfif ></cfif>
<else if form.option[selectedindex].value = `Broadcast`>
{
<cfquery datasource="Book_DB" name="Select_data" >
select * From Prsa_Green
where broadcasting = 1
</cfquery>
}
</if>
</script>
</head>

<body bgcolor="#FFFFFF">

<h3><font color="#CCCCCC" size="+4">The Green Book</font></h3>
<hr>
<form name="catagories" action="index.cfm">
<select name="catagories" onChange="MM_jumpMenu(`parent`,this,0)">
<option value="audio" selected>Audio News Release Services</option>
<option value="broadcast">Broadcast Monitoring</option>
<option value="celebrity">Celebrity Casting</option>
</select>
<input name="submit" type="submit">
</form>


<table width="100%" >
<cfoutput query="Select_data">
<tr><td width="655"><img src= "images/#co_logo_color#"><br> </td></tr>
<tr><td width="655"><font size="+1"
color="660099">#Company#</font></td></tr>
<tr>
<td width="655">Address:#Street#</td></tr>
<tr><td width="655">#street2#</td></tr>
<tr>
<td width="655">#city#,&nbsp;#state#&nbsp;#zip#</td>
</tr>
<tr>
<td width="655">Tel:#telephone#</td>
</tr>
<tr>
<td width="655">#telephone2#</td>
</tr>
<tr>
<td width="655">Fax:#fax#</td>
</tr>
<tr>
<td>
website: <a href="http://#website#" target="_top"
class="interior">
#website#</a></td>
</tr>
<tr>
<td>#co_desc#
</td>
</tr>
<tr><td> <hr><br></td></tr>

</cfoutput>
</table>




</body>
</html>
Reply with quote
Send private message
Post new topic Reply to topic
Display posts from previous:   
freelanceprogrammers.org Forum Index » Cold Fusion
 

All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help