Thanks Andrew, I am not quite sure what you mean though. Do you mean that the record is being returned as present each time so the append isn't working?
>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 > > > >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:5749 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
