I think this'll work: UPDATE Soc SET TransProv=<cfif Len(form.TransProv)>'#form.TransProv#'<cfelse>NULL</cfif> WHERE ID=100
On Tue, Apr 6, 2010 at 2:43 AM, alex poyaoan <[email protected]> wrote: > > Hi Everybody have this situation where I have a cfselect listed below with > an added OPTION to display "Please select province" and a the list of > provinces generated from a query which displays on the dropdown using the > attribute QueryPosition="below". On the selected attribute the real value > from the database should show from the query getdetails using > #GetDetails.ProvID#" which is ok. The problem now is when a value from the > GetProvinces query is select all would be fine but when the added option > with a blank value is select it stores the string "Please select province" > on the database. How could I insert a null value when that is selected? > > <CFSELECT NAME="TransProv" > Label="Transferred province" > QueryPosition="below" > query="GetProvinces" > value="ProvID" > display="provname" > selected="#GetDetails.ProvID#" > > > <option value="">Please select province</option> > </CFSELECT> > > this is the action query to update the table > > <cfquery name="UpdateSoc" datasource="socs"> > UPDATE Soc > SET TransProv='#form.TransProv#' > WHERE ID=100 > </cfquery> > > > Thanks for any help > alex > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332626 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
