Embed a CFIF statement inside the loop that determines whether or not the
database value matches the <OPTION> value. Then, if it does match, include
the SELECTED parameter inside the option tag.
<select name="parked">
<option value="">
<cfloop index=i from="1" to="52">
<CFIF Query.DatabaseValue IS i>
<option value="#i# week/year" SELECTED>#i#
week/year
<CFELSE>
<option value="#i# week/year">#i# week/year
</CFIF>
</cfloop>
</select>
Keep in mind that this will only work if there is only one possible match
between the database values and your index (i).
Jesse D. Roberts
Business Process Analyst
Procurement Quality Assurance
Boeing - Huntington Beach, CA
[EMAIL PROTECTED]
Ph. 714-896-3462
Fx. 714-896-3303
> -----Original Message-----
> From: Erika Foster [SMTP:[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?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
