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:332624
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
