>- see footer for list info -< Lee, I remember people talking about mass inserts on CFCHAT years ago. Try Googling for mass or multiple insert.
I guess the idea is that you could create all the SQL in CF and then output the generated SQL between a CFQUERY tag. If that makes sense? Cheers Niklas On 2/28/06, Robin Griffiths <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > You could loop through and parse the data, then save it in a tab-delimited > file that would be compatible with bcp .... > > http://www.windowsitlibrary.com/Content/77/14/1.html > > You'd need access to cfexecute, I think - unless the SQL Server gurus know > a > way to do it via stored procs or some such? > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Lee Fortnam > Sent: 28 February 2006 09:14 > To: 'Coldfusion Development'; 'database programming' > Subject: [CF-Dev] Long array into a database > > >- see footer for list info -< > Hi All, > > I have the need to import a tab delimited file, having got over the flash > form upload issue (thanks to Andy!) and having converted the file into an > array using the following UDF (http://www.cflib.org/udf.cfm?ID=855.) I > know > have an array containing the column names in the first element of the > array > and then the appropriate data in the subsequent elements of the array. > > My question is this, I need to import the array into the database but the > array could contain 10K plus items, whilst I could just cycle through the > array performing an insert for each record, I wondered if anyone knew of a > more eloquent method of performing the same. Each element of the array > contains an ID number and telephone number (which may require further work > to convert it to a standardised format, i.e. '441217091345' from something > like '709 1345', this can be done either before the import or at the same > time. > > The system is CFMX7 and I am using SQL Server 2000. I am not a DTS guru > and > as result would prefer if possible to perform this using standard SQL > Stored > Procedures unless anyone is prepared to guide me through the DTS option. > > Many Thanks, > > Lee Fortnam > [EMAIL PROTECTED] > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > -< > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > -< > -- Niklas Richardson Prismix Ltd UK based Flex and ColdFusion Specialists _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
