Just set it equal to NULL in the SQL:
UPDATE
[table]
SET
[column] = NULL
WHERE
[column2] = [value]
......................
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-----Original Message-----
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 15, 2007 1:22 PM
To: CF-Talk
Subject: inserting nothing into a numeric
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:269910
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
