Output the value from the database first.
For example:
<select name="parked">
<option value="">
<cfif id neq 0>
<cfoutput>
<option value="#id#">#name#
</cfoutput>
</cfif>
<cfloop index=i from="1" to="52">
<option value="#i# week/year">#i# week/year
</cfloop>
</select>
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Erika Foster [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 27, 2000 7:24 AM
> To: [EMAIL PROTECTED]
> Subject: Selecting a value in a dropdown.
>
>
> I am populating a select input field with a <cfloop>
>
> <select name="parked">
> <option value="">
> <cfloop index=i from="1" to="52">
> <option value="#i# week/year">#i# week/year
> </cfloop>
> </select>
>
> That's all working. This form is also an edit form if a record already
> exists for this facility. How do I pre-select the value that is in the
> database for that record from within the loop?
>
> Thanks,
>
>
> Erika Foster
> engineering-environmental Management
> Applications Developer
> (505) 866-1654
> [EMAIL PROTECTED]
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
