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