Thanks, guys... It did need a null value. (It's a decimal datatype).
So, Dominic's solution worked! Rick > -----Original Message----- > From: Scott Stewart [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 09, 2008 3:20 PM > To: CF-Talk > Subject: RE: Why won't this insert work? > > Try get_data.no_acres > > -- > Scott Stewart > ColdFusion Developer > > SSTWebworks > 4405 Oakshyre Way > Raleigh, NC. 27616 > (919) 874-6229 (home) > (703) 220-2835 (cell) > > -----Original Message----- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 09, 2008 3:15 PM > To: CF-Talk > Subject: Why won't this insert work? > > Hi, all... > > Why won't this insert create a record even when > #no_acres# has no value (empty)...? > > I'm inserting into MySQL 5 and the no_acres column > is set to allow null. > > The code below runs fine if I intercept any insertions > where #no_acres# has no length, or rather, is empty. > > Thanks, > > Rick > > Here's the code: > > <cfquery name="get_data" datasource="abc"> > > select no_acres > from smlc_acr_temp > > </cfquery> > > <cfloop query="get_data"> > > <cfquery name="insert_data" datasource="abc"> > > insert into smlc_acr > > (no_acres) > > values (#no_acres#) > > </cfquery> > > </cfloop> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4