I have a table with a numeric field. It initially has nothing
inserted into it. However on UPDATE, a number can be inserted when
person is assigned to the record. When a person is no longer
assigned to it, I want to remove the number from the field. How do I
UPDATE it with null or nothing.
<cfif technician NEQ ''>
technician = <cfqueryparam value="#Trim(Form.technician)#"
cfsqltype="CF_SQL_INTEGER">,
technician_fname = <cfqueryparam
value="#get_technician_info.fname#" cfsqltype="cf_sql_varchar">,
technician_lname = <cfqueryparam
value="#get_technician_info.lname#" cfsqltype="cf_sql_varchar">,
<cfelse>
technician = <cfqueryparam value="void"
cfsqltype="CF_SQL_INTEGER">,
technician_fname = <cfqueryparam value=""
cfsqltype="cf_sql_varchar">,
technician_lname = <cfqueryparam value=""
cfsqltype="cf_sql_varchar">,
</cfif>
--
Daniel Kessler
College of Health and Human Performance
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
Phone: 301-405-2545
http://hhp.umd.edu
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269909
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
