Well by looking at the logic, yes because it is doing if record count equals 1 then write not append.
On Wed, Dec 14, 2011 at 4:06 AM, Matt Gibson <[email protected]> wrote: > > 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:5750 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
