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