Put the option tag before the output query.. Then in the select tag, make the option selected.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:49 PM To: CF-Talk Subject: cfselect question Does anyone know of a way to display a default field when using cfselect and a query first? I've put an option tag between the <cfselect> and </cfselect> tags and it displays it as the last entry. I would like it to display first. What I'm doing is using my states database to populate the select box, but I want it to default to "Select State" as the very first entry, but it's showing up last. <cfselect query="getStates" name="stateid" value="stateid" display="name"> <option value="0" selected>Select State </cfselect> Sorry for such a simple post, but I'm fried and can't think of any way around putting it in the table itself. Thanks, Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
