> I think you have a limit of about 2Meg on the file size for > cfhttp (correct me if I am wrong).
because of this, we setup an odbc socket on the directory and then use that to query the CSV file directly. Works great, although involves a little extra setup when the app is deployed.. > -----Original Message----- > From: Adam Reynolds [mailto:[EMAIL PROTECTED] > Sent: 06 January 2004 11:34 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Importing... > > > 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]
