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:342687
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
