thanks a lot that worked perfectly!
>From: James Maltby <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
>Subject: RE: drop down box
>Date: Mon, 24 Jul 2000 12:57:55 +0100
>
><!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/[email protected]/"
>TARGET="_blank">http://www.mail-archive.com/[email protected]/</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/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
