<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: drop down box</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>A clunky way of doing this is to use CFIF in your option values:</FONT>
</P>
<P><FONT SIZE=2>Like:</FONT>
<BR><FONT SIZE=2><cfoutput query="getdetails"></FONT>
<BR><FONT SIZE=2><p>Status:</FONT>
<BR><FONT SIZE=2> <select name="#pol_status#"
size="1"></FONT>
<BR><FONT SIZE=2> <option value="All" <CFIF
#pol_status# eq "All">slected</cfif>>All</option></FONT>
<BR><FONT SIZE=2> <option value="New" <CFIF
#pol_status# eq "New">slected</cfif>>New</option></FONT>
<BR><FONT SIZE=2> <option value="Active" <CFIF
#pol_status# eq
"Active">slected</cfif>>Active</option></FONT>
<BR><FONT SIZE=2> <option value="Archive" <CFIF
#pol_status# eq
"Archive">slected</cfif>>Archive</option></FONT>
<BR><FONT SIZE=2> <option value="Hide" <CFIF
#pol_status# eq "Hide">slected</cfif>>Hide</option></FONT>
<BR><FONT SIZE=2> </select></FONT>
</P>
<P><FONT SIZE=2>You may need to create a param <cfparam name="pol_status"
default=""> and add this line above your cfoutput - can't remember why
though!</FONT></P>
<P><FONT SIZE=2>James</FONT>
</P>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: janey smith [<A
HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>
<BR><FONT SIZE=2>Sent: 24 July 2000 12:44</FONT>
<BR><FONT SIZE=2>To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=2>Subject: drop down box</FONT>
</P>
<BR>
<P><FONT SIZE=2>having a problem passing values submitted in a drop down list
box.</FONT>
<BR><FONT SIZE=2>on my form page the user selects their choices from the drop down,
the the </FONT>
<BR><FONT SIZE=2>user can choose to edit these choices on the next page, their
original </FONT>
<BR><FONT SIZE=2>choices shoud appear on the edit page, which follows:</FONT>
</P>
<P><FONT SIZE=2><CFQUERY NAME="GetDetails"
DATASOURCE="quickpoll"></FONT>
<BR> <FONT SIZE=2>SELECT pol_ID,
pol_Question, pol_Category, pol_Status</FONT>
<BR> <FONT SIZE=2>FROM pol_Poll</FONT>
<BR> <FONT SIZE=2>WHERE pol_ID =
#URL.PollID#</FONT>
<BR><FONT SIZE=2></CFQUERY></FONT>
</P>
<BR>
<P><FONT SIZE=2><cfoutput query="getdetails"></FONT>
<BR><FONT SIZE=2><p>Status:</FONT>
<BR><FONT SIZE=2> <select name="#pol_status#"
size="1"></FONT>
<BR><FONT SIZE=2> <option
value="All">All</option></FONT>
<BR><FONT SIZE=2> <option
value="New">New</option></FONT>
<BR><FONT SIZE=2> <option
value="Active">Active</option></FONT>
<BR><FONT SIZE=2> <option
value="Archive">Archive</option></FONT>
<BR><FONT SIZE=2> <option
value="Hide">Hide</option></FONT>
<BR><FONT SIZE=2> </select></FONT>
<BR><FONT SIZE=2> Category:</FONT>
<BR><FONT SIZE=2> <select name="#pol_Category#"
size="1"></FONT>
<BR><FONT SIZE=2> <option
value="All">All</option></FONT>
<BR><FONT SIZE=2> <option
value="sports">sports</option></FONT>
<BR><FONT SIZE=2> <option value="current
affairs">current affairs</option></FONT>
<BR><FONT SIZE=2> <option
value="general">General</option></FONT>
<BR><FONT SIZE=2> </select></FONT>
<BR><FONT SIZE=2></cfoutput></FONT>
</P>
<P><FONT SIZE=2> hope this makes sense, i want the choice selected to
appear in the drop </FONT>
<BR><FONT SIZE=2>down, and the user can then make the required change if
necessary</FONT>
<BR><FONT SIZE=2>thanks in advance</FONT>
<BR><FONT
SIZE=2>________________________________________________________________________</FONT>
<BR><FONT SIZE=2>Get Your Private, Free E-mail from MSN Hotmail at <A
HREF="http://www.hotmail.com" TARGET="_blank">http://www.hotmail.com</A></FONT>
</P>
<P><FONT
SIZE=2>------------------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>Archives: <A
HREF="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
TARGET="_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/</A></FONT>
<BR><FONT SIZE=2>To Unsubscribe visit <A
HREF="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
TARGET="_blank">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</A>
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.</FONT></P>
</BODY>
</HTML>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
