Editing a form.

[calista]

I am writing an edit function for a form in which I pre-fill all the fields with the data stored in the database. The one I am having trouble with is a field that the user selects from a dropdown menu. I still want to present all the options, but I want the option in the database on top. The code to produce the list is shown below.

<!--- Display every employee. --->
<SELECT NAME=&quot;ProjLineMgr&quot;>
	<CFOUTPUT QUERY=&quot;GetPeople&quot;>
		<OPTION VALUE=&quot;#PersonID#&quot;>#PersonFirstName# #PersonLastName#</OPTION>
	</CFOUTPUT>
</SELECT>

I store ProjLineMgr in one table, and I have another table of people with their names and IDs. So, I need to query the employee table with ProjLineMgr to retrieve the name, and somehow put it on top while displaying the other names in case it is being changed. Any suggestions?

 

[GunJack]

Hi Calista,

Is this what you're looking for? I'm assuming query Q1 contains the information you're populating in the form.

<SELECT NAME=&quot;ProjLineMgr&quot;>
<CFOUTPUT QUERY=&quot;GetPeople&quot;>

<OPTION VALUE=&quot;#PersonID#&quot;
<cfif Q1.projLineMgr is personID> selected=&quot;yes&quot;</cfif>
>#PersonFirstName# #PersonLastName#

</OPTION>
</CFOUTPUT>
</SELECT>

Hope this helps,
GJ

 

[calista]

Boy, that was quick! Yes, that's exactly what I was looking for! Thank you! :-D