Well, this script will be running on a scheduled task, but it'll be a CF scheduled task. That solution might work with some modifications.
Let me bring a little more background in to the equation. The data that is being read in via CSV has a date attached to each record, if any of the dates in the database matches those dates, I need to delete any and all data from that day, then do the group import, if possible. So, I don't see any way to do this without CF getting involved. Sorry, this is getting more complicated, but it is the problem that was put in front of me. :) Andy Matthews wrote: > What about saving the file to the server then running a scheduled task and > let the database do the import. It'll be WAY faster and won't involve CF at > all. I recently had our sysadmin setup something like that for me. It ran in > 10 or 15 seconds what was taking CF about 2 or 3 minutes to perform. > > <!----------------//------ > andy matthews > web developer > certified advanced coldfusion programmer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > -----Original Message----- > From: Crow T. Robot [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 22, 2006 2:49 PM > To: CF-Talk > Subject: Re: appending two queries > > > This will happen once a day, every day. Same data structure, yes, same > database table, yes. Same data, no. > > Ben Nadel wrote: >> Is this a one-time deal? Or is this something you need to do on a regular >> basis (same DB, same table). >> >> ....................... >> Ben Nadel >> Web Developer >> Nylon Technology >> 350 7th Avenue >> Floor 10 >> New York, NY 10001 >> 212.691.1134 x 14 >> 212.691.3477 fax >> www.nylontechnology.com >> >> "Some people call me the space cowboy. Some people call me the gangster of >> love." >> >> -----Original Message----- >> From: Crow T. Robot [mailto:[EMAIL PROTECTED] >> Sent: Thursday, June 22, 2006 3:36 PM >> To: CF-Talk >> Subject: appending two queries >> >> Let's say that I have a CSV file that I am reading into a page, and I >> convert it to a query. I have a database table that it set up exactly > like >> the converted query, I want to basically insert the CSV data into the >> database. Is there an easier, more efficient way to do this that looping >> over the CSV query and doing an insert for each record? >> >> SQL Server 2K, CFMX6.1 >> >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244576 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
