Carl, I will try that. I had the truncate in a cftrans.. let me try them both and see what I get.
Nope.. still the same result. I have tried having both of them in one cftrans and also having them in their own cftrans block. The odd thing is.. When the truncate works, It removes all of the data but leaves one blank record. Like blanks on all lines. Very odd. Thanks for the suggestion but that didn't do it. :( On Wed, Mar 2, 2011 at 1:30 PM, Carl Von Stetten <[email protected]>wrote: > > I wouldn't expect that the delete or truncate would still be running, > but if they are, wrapping all of the <cfquery> tags in a <cftransaction> > might help, or wrapping the delete/truncate in a transaction, then > calling the insert in a separate <cftransaction>? > > HTH, > Carl > > On 3/2/2011 9:57 AM, Mallory Woods wrote: > > I am trying to clear all of the data from a table before importing new > data. > > > > Example code: > > > > * > > <cfquery name="qryClear" datasource="datasource"> > > TRUNCATE TABLE tablename > > </cfquery> > > > > ---> > > <!--- > > <cfquery name="qryDelete" datasource="datasource"> > > delete from tablename > > </cfquery> > > ---> > > > > <cfquery name="qryInsert" datasource="datasource"> > > insert into tablename > > ...... > > </cfquery>* > > > > I have tried to truncate and delete the data. This appears to work fine. > > However, the next set of lines which is supposed to import the data runs > but > > no data is imported. > > Could the delete or truncate function still be running when the import is > > taking place? If so, what is the best suggested method to get both of > these > > functions to run after > > each other? > > > > Thanks in advance. > > > > Mallory Woods > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
