>- see footer for list info -< Hi Niklas, Russ came up with another idea of using BCP to import the information to a table in native format and then using DTS to transfer to the relevant table so going to have a look at that, will update on my findings.
Thanks, Lee Fortnam [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Niklas Richardson Sent: 28 February 2006 16:22 To: Coldfusion Development Subject: Re: [CF-Dev] Long array into a database >- 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 >-< _______________________________________________ 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 -<
