At 06:43 AM 11/28/2001, you wrote:
> Ok I have this drop down box that lists every country out there, the
>problem is after someone has selected it, I want the admin side to show
>which one has been selected, while also showing the rest of them. I have
>done this but doing a huch cfcase statement that goes from 1 - whatever and
>if it is a vertain one selected it sets a number, then the select box has a
>cfif in there to see if that number has been turned on. Does anyone have a
>simple solution, or is my solution the only way there is.
Not sure if I understand what you are saying... but here is what I do...
<SELECT NAME="MeCountryLink">
<CFOUTPUT QUERY="Q_Countries">
<OPTION VALUE="#CnID#"
#IIF(ATTRIBUTES.MeCountryLink eq CnID, DE('SELECTED'),
DE(''))#>#CnCountry#</OPTION>
</CFOUTPUT>
</SELECT>
This is using a query called Q_Countries containing the countries, CnID is
the primary key of that query, CnCountry is the field containing the
country name, ATTRIBUTES.MeCountryLink is a variable containing the ID of
the country the user currently has selected.
----------
James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/
CAUTION: The information contained in this email message is confidential
and may be legally privileged. If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited. If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.
Views expressed in this communication may not be those of Innovative Media
Ltd.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists