Jerry worked a treat
Thanks Mike Peters ---------------------------------------------------- NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz ---------------------------------------------------- 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> ------------------------------------------------------ ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
