Excellent .. thanks for that .. just tested and it works a treat ! one for the notebook I think :�P
Regards Stephen -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 11:44 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Importing... sure. (this is on cfmx, but you can do it on prev versions I think) in NT/2000, setup a dsn on the directory that files will be uploaded to. in CFMX admin, create an odbc socket pointing to that new DSN. in your code, reference it as follows: <cfquery name="pricedata" datasource="#text_driver#"> SELECT * FROM filename.csv ORDER BY pricedate </cfquery> voila. > -----Original Message----- > From: Stephen Pope [mailto:[EMAIL PROTECTED] > Sent: 06 January 2004 11:39 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Importing... > > > Never done it like that but sounds v.useful ! Have you any > quick info on how you set that up ? > > Regards > > Stephen > > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 06 January 2004 11:38 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Importing... > > > 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] > > > -- > ** 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]
