Word up, Charlie's suggestion is much better! Stick with the CFQuery param.
...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, February 15, 2007 1:27 PM To: CF-Talk Subject: Re: inserting nothing into a numeric <cfqueryparam> takes a null attribute. set it to "yes" :) <cfqueryparam value="" cfsqltype="cf_sql_integer" null="yes" /> On 2/15/07, Daniel Kessler <[EMAIL PROTECTED]> wrote: > 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:269912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
