Drop down menu help

ikle_pixie · ikle_pixie

I've used 3 of dreamweavers drop down boxes on my page. I would like to know if its at all possible to have the selected items from the list open in a new chromeless window. Thanks

quiero mas · quiero mas

Been trying hard to sort out this but to not luck.
post from a search page with a simple drop down menu populated witha
distinctly.
anway cant get the results to appear in the results page please check out my
code -if you can hekp me ill buy you a beer.

<cfquery name="Distinct" datasource="simple">
SELECT Area
FROM Simple
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>search</title>
<link rel="stylesheet" href="hs.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=shift_jis">
</head>

<body>

<form name="form1" method="post" action="try5.cfm">
<label>
<input type="submit" name="Submit" value="Submit">
<select name="select">
<cfoutput query="Distinct">
<option value="#Distinct.Area#" <cfif (isDefined("Distinct.Area") AND
Distinct.Area EQ Distinct.Area)>selected</cfif>>#Distinct.Area#</option>
</cfoutput> </select>
</label>
</form>

</body>
</html>

result page

<cfparam name="FORM.Area" default="1"><cfquery name="try2" datasource="simple">
SELECT Area
FROM Simple</cfquery>
<cfquery name="try7" datasource="simple">
SELECT LastName
FROM Simple
WHERE Area LIKE '%#FORM.Area#%'</cfquery>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>try5</title>
<meta http-equiv="Content-Type" content="text/html; charset=shift_jis">
</head>

<body>
<cfoutput>#try7.LastName#</cfoutput>
</body>
</html>

Dan Bracuk · Dan Bracuk

Your form does not have an input called area, so on your action page, the
cfparam tag is setting the value to 1.

By the way, you have way too much code for what your are trying to accomplish.

Originally posted by: quiero mas
Been trying hard to sort out this but to not luck.
post from a search page with a simple drop down menu populated witha
distinctly.
anway cant get the results to appear in the results page please check out my
code -if you can hekp me ill buy you a beer.

<cfquery name="Distinct" datasource="simple">
SELECT Area
FROM Simple
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>try5</title>
<meta http-equiv="Content-Type" content="text/html; charset=shift_jis">
</head>

<body>
<cfoutput>#try7.LastName#</cfoutput>
</body>
</html>

quiero mas · quiero mas

thanks for your comments - i appreciate the advice. I am very new to this as
you may have gathered. Do you know of any examples of code that i can have a
look at? I will actually be trying to make this a multiple menu. I am trying
to set up a bilingual health information site (non0 profit) for non japanese
living here in Hokkaido. I want them to be able to filter their search by four
or five menus. I really appreciate you taking the time to look and i am a man
of my word. next time we hook up the beers are on me

Regards Mark

Dan Bracuk · Dan Bracuk

Here is your form code
<form name="form1" method="post" action="try5.cfm">
<label>
<input type="submit" name="Submit" value="Submit">
<select name="select">
<cfoutput query="Distinct">
<option value="#Distinct.Area#" <cfif (isDefined("Distinct.Area") AND
Distinct.Area EQ Distinct.Area)>selected</cfif>>#Distinct.Area#</option>
</cfoutput> </select>
</label>
</form>

You don't need the label tags. They can go.
Also, with the query you have now, all that cfif stuff inside your option tag
is unnecessary, so it can go.
Finally, you need an input tag named area. Change the name of your select tag
from select to area.

Here is your result page.
<cfparam name="FORM.Area" default="1">
<cfquery name="try2" datasource="simple">
SELECT Area
FROM Simple</cfquery>

<cfquery name="try7" datasource="simple">
SELECT LastName
FROM Simple
WHERE Area LIKE '%#FORM.Area#%'</cfquery>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>try5</title>
<meta http-equiv="Content-Type" content="text/html; charset=shift_jis">
</head>

<body>
<cfoutput>#try7.LastName#</cfoutput>
</body>
</html>

The cfparam is fine, but, what you should do is to use a cfif tag to send the
user to your form if the value is actually 1. That's because they didn't
submit the form.

Query try2 is unnecessary, it can go.
In query try7, change this
WHERE Area LIKE '%#FORM.Area#%'</cfquery>
to this
WHERE Area = '#FORM.Area#'
</cfquery>
I assume you only want the record that matches what the user submitted.

Your cfoutput should now show you the last name.

quiero mas · quiero mas

Dan thank you very much for your help - things are now flowing smoothly - my
next challenge is to work out a multiple filter
e.g area, closest subway, medical department, woman doctor, english speaking
doctor and/or appointment not necessary

ideally someone can filter their search by one or all of these or some combo
in between - is this going to difficult or just a little fiddly. I appreciate
you taking the time to answer and hope i can help someone else in the future

best regards
Mark

Drop down menu help

Thread Tools

Display

Drop down menu help

Similar Questions and Discussions

Drop Down Menu for Pay Pal

drop down menu

Drop Down Menu?

Drop Down Menu in DW

How do I build Drop Down menu using Menu magic with Database result

drop down menu help

Re: drop down menu help

Re: drop down menu help

Re: drop down menu help

Re: drop down menu help

Posting Permissions