<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:269911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4