Hi John, Yes once you have the cffile issue worked out its exactly as you say. Read in the file loop over it and inside the loop do the database insert.
Paul -----Original Message----- From: John Barrett [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 August 2008 3:45 PM To: CF-Newbie Subject: Re: writing multi queries? No error, it just does not upload the file. I just ran it on my Mac at work, and it works(of course I changed the path, and yes it does upload the file.), but the host is a linux server, and I changed the permission to "777". My thinking that once I can write the file, and loop through all the fields in the csv file, then I could use cfquery to write to the db. Is this the usual way to go about something like this? I contacted the host to find out what is wrong, seems to me that it is something on their side. They told me that cffile is enabled. Thanks so much for your help, John > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3897 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
