If your on SQL server you could use bulk inserts, check it out in the books online. SQL Server now supports XML and can import and return record sets in XML format.
Russ > -----Original Message----- > From: Paul Swingewood [mailto:[EMAIL PROTECTED] > Sent: 06 July 2004 15:09 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Batch Processing - Admin systems > > I need to make an admin system that allows batch processing. > The user wants to be able to add say 50 records locally and > then upload them to the server. > I was thinking of using a form that adds a new line each time > <add another > record> is pressed & finally a <submit to database> button. The user > record> would > enter data and then <add another record> until the user > decided to upload to database. > > I think I will need an array to keep track of the data > locally pass it to some sort of verifying page to verify all > of the data (what if something is > wrong?) and then an upload page to send it to the database. > > To put this in context the user is entering stock. Its a pain > to enter an item on a form sumit/ enter another item etc ... > > Is this the right way to do it? > Does anyone have any ideas - thoughts on this? > Is there anything out there that I can have a look at for ideas? > > All comments welcome > > Regards - Paul > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
