Yes I tried it a couple of times but it still inserts the quotes. I tried a
workaround which worked fine.. I inserted a value=1 to the blank option of the
cfselect and did a cfif on the update query the code is listed below
<CFSELECT NAME="TransProv"
Label="Transferred province"
QueryPosition="below"
query="GetProvinces"
value="ProvID"
display="provname"
selected="#GetDetails.ProvID#"
>
<option value="1">Please select province</option>
</CFSELECT>
and here is the UPDATE QUERY.....
<cfquery name="UpdateSoc" datasource="socs">
UPDATE Soc
SET TransProv=<cfif (form.TransProv)neq 1>'#form.TransProv#'<cfelse>NULL</cfif>
WHERE ID=100
</cfquery>
Thanks all for your help
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:332635
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
