Seamus This is probably your are looking for. Update TableName set FieldName=FieldName + ' ' + 'New Record Value' where TableRowID=23442
You can use char(13) to add values to next line.. as well Joe On Mon, 25 Nov 2002 20:46:47 +1100 Seamus Campbell <[EMAIL PROTECTED]> wrote: > Hi > > I am looping thru a text file, updating a > database. > I want to have an errors table which will list > all titles not updated due > to errors. > > But what I want (and can't see how to do) is to > add each record not updated > to a memo field but not lose the previous data > ie > initially memo field is empty > then has > record 3 > next error is record 5 > so memo field now has > record 3 record 5 > next error is record 22 > so memo field now has > record 3 record 5 record 22 > > I'm not sure if I am making myself clear? > > Currently I can only collect the last error > record. > Any help gratefully recieved. > Many thanks > > Seamus > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
