I am guessing as nothing appears to be wrong from a quick glance, but you might want to run the query in the database you are using editor or query designer, because I am guessing that the query that is checking for the record is returning 1 record all the time.
So that would point to the logic or conditions being wrong. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 -----Original Message----- From: Matthew Gibson [mailto:[email protected]] Sent: Wednesday, 14 December 2011 2:19 AM To: cf-newbie Subject: CFFile Append Not Workring Hi I am a total newbie, trying to learn coldfusion in my spare time and fix some errors that are occuring on our website. Unfortunately our web company went bust and a few queries aren't working so I could do with some advice. One of our main queries is to copy a csv with order details to our server so our program can import order details.The query takes the order info, asks teh other databse for the correct 'SKU' code returns it then creates a csv string, it then contacts the server again to make sure the file doesn't exist. When a file does exist it means it hasn't yet been processed, so we need the information to append to the existing csv file. Unfortunately though the cf file append doesn't seem to be working and it always ends up overwriting the csv file thus wiping out the previous information. would any kind soul take a look at the code and see where I am going wrong? Again I am a total newbie so apologies for any obvious mistakes, I am trying to learn! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5748 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
