Carl its MySQL On Wed, Mar 2, 2011 at 2:00 PM, Carl Von Stetten <[email protected]>wrote:
> > What DBMS are you using? SQL Server, MySQL, Oracle, or MS Access? > Carl > > On 3/2/2011 10:43 AM, Mallory Woods wrote: > > 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:342694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
