Just my .02.
But I mostly stay away form CFSELECT, because I don't use CFFORM
you could just use <select>
<SELECT name="stateid">
<option value="0" SELECTED>Select State</option>
<CFOUTPUT query="getstates">
<option value="#stateid#">#name#</option>
</CFOUTPUT>
</SELECT>
This I believe would get you what you want.
(but watch my typing, was just done on the spur of the moment ;o)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 12: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
______________________________________________________________________
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=coldfusiona
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
