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> ------------------------------------------------------ ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
