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