Mike Try this as your last option:
<OPTION value="" <CFIF AppMenuID eq "">Selected</CFIF>>[None selected]</OPTION> Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com -----Original Message----- From: Office [mailto:[EMAIL PROTECTED]] Sent: 28 March 2002 22:42 To: CF-Talk Subject: Select list values I'm populating an SQL7 table with possible numeric values "AppMenuID" using a look up list from a web form. The field can also be left null. It puts the correct value or "null" into the table but the form dosn't show that null has been selected for the record next time I come back. How do I get this to work. Thanks for any tips Mike Peters ---------------------------------------------------- NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz ---------------------------------------------------- <SELECT name="AppMenuID" size="1"> <OPTION <CFIF AppMenuID IS "1">Selected</CFIF> value="1">Messages</OPTION> <OPTION <CFIF AppMenuID IS "4">Selected</CFIF> value="4">My Groups</OPTION> <OPTION <CFIF AppMenuID IS "2">Selected</CFIF> value="2">Personal</OPTION> <OPTION <CFIF AppMenuID IS "3">Selected</CFIF> value="3">Submit</OPTION> <OPTION <CFIF AppMenuID IS "5">Selected</CFIF> value="5">Tasks</OPTION> <OPTION <CFIF AppMenuID IS "Null">Selected</CFIF> value="">[None selected]</OPTION> </SELECT> ------------------------------------------------------ ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
