I believe if it is a csv file (i.e. has columns), cfhttp treats it as a query, using the first line to define the columns.
Adam > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 06 January 2004 12:21 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Importing... > > > > just wondering, why would you use CFHTTP to read the file rather than just > <cffile action="read"> ? Is it faster? > > > Duncan Cumming > IT Manager > > http://www.alienationdesign.co.uk > mailto:[EMAIL PROTECTED] > Tel: 0141 575 9700 > Fax: 0141 575 9600 > > Creative solutions in a technical world > > ---------------------------------------------------------------------- > Get your domain names online from: > http://www.alienationdomains.co.uk > Reseller options available! > ---------------------------------------------------------------------- > ---------------------------------------------------------------------- > > > > > "Adam > > Reynolds" To: > <[EMAIL PROTECTED]> > <[EMAIL PROTECTED] cc: > > o.uk> Subject: RE: [ > cf-dev ] Importing... > > > 06/01/2004 > > 11:34 > > Please > > respond to > > dev > > > > > > > > > Upload the CSV file to an accessible area of the site. > > Use cfhttp to read the file and retrieve all the records and loop through > them. > > Delete the file. > > I think you have a limit of about 2Meg on the file size for > cfhttp (correct > me if I am wrong). > > Adam > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > Sent: 06 January 2004 11:09 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] Importing... > > > > > > > > I want to be able to do this..... > > > > User names and addresses are entered to a database via a form. > > The form consist of name address etc... > > Ok this works great for adding an individual record. > > > > The user now wants to be able to have say 500 records in a text > or access > > file. > > Browse to this file and have the system automatically update > the database > > with the data. > > > > > > Can this be done via the form? - I know I can import it directly to the > > database but I need it via the form online > > > > Any ideas .... > > > > Happy New Year. > > > > Regards - Paul > > > > > > > > > > ****************************************************************** > > ******************************* > > The information contained within this e-mail (and any attachment) > > sent by Birmingham City Council is confidential and may be > > legally privileged. It is intended only for the named recipient > > or entity to whom it is addressed. If you are not the intended > > recipient please accept our apologies and notify the sender > > immediately, or telephone +(44) 121 303 6666. Unauthorised > > access, use, disclosure, storage or copying is not permitted and > > may be unlawful. Any e-mail including its content may be > > monitored and used by Birmingham City Council for reasons of > > security and for monitoring internal compliance with the office > > policy on staff use. E-mail blocking software may also be used. > > Any views or opinions presented are solely those of the > > originator and do not necessarily represent those of Birmingham > > City Council. We cannot guarantee that this message or any > > attachment is virus free or has not been intercepted and amended. > > > > ****************************************************************** > > ******************************* > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
