>- see footer for list info -<
Or if you don't want logic in the drop down output, Q of Q the main query to
filter out the offending row.

Ade

-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 12 January 2005 11:50
To: Coldfusion Development
Subject: RE: [CF-Dev] populating drop downs (select lists)


>- see footer for list info -<
You should probably do it several ways....one way would be to check the
option value from the DB back to the select list and see if its equal to
'--No Preference--' another would be to simply alter the select statement to
not bring back the '--No Preference--' option from the database (assuming
you are getting this value from their)

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul Swingewood
Sent: 12 January 2005 11:48
To: [email protected]
Subject: [CF-Dev] populating drop downs (select lists)

>- see footer for list info -<
I have a drop down box (Select List) which is populated from a database. The
first item of the list is --No Preference--

I use the same list in the back end system for data entry. Obviuosly now I 
don't want the user to see the --No Preference-- as an option. How do I do 
this?

Regards - Paul
_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to 
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<

Reply via email to