Webmaster Forum / ColdFusion / Getting Started / December 2005

Hello and Happy Holidays!  

All I want for Christmas is to complete my code.

I have a form page that is populated from a database.  It populates correctly
but then i do on update to the database and i get stuck on the drop down menus.
I do this to get my data and have one selected...

<select name="StatusID">
     <option value="#GetFiles.StatusID#" selected>
<cfoutput>#GetFiles.Staus#</cfoutput></option>
           <cfoutput query="GetStatus">
      <option value="#StatusID#">#Staus#</option>
            </cfoutput>
</select>

This works great!!!!  But when i go to the update page(hit submit)  you must
rechoose the drop down and if i try it another way, i get an error.

I am just trying to update the database and not have to change the dropdown
unless the value changes.  I hope i am making sense.

Off to wrap presents...is there ever an ending?  

Thank you,
DDonna