I am populating a drop down menu with a query from a database:

<select name="Color1">
        <option value="">
        <cfoutput query="select">
        <option value="#select.Color1#"> #select.Color1#
        </cfoutput>
</select>

Inside of the database there are NULL or blank entries.  So when i get the 
drop down populated i get a bunch of blank spaces.

Is there a way i can modify my CFOUTPUT so it does not display the blank 
entries into my Drop Down???

Thanks,
Chad


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to