My own thoughts are that it is better to let your database server handle it's own data whenever possible. By creating a CF Template, you are asking your web server to do data operations. Simple enough for the most part, but if the template get's hit by multiple users, or you have a high volume site, then you are placing unnecessary load on your servers.
My thoughts, not yours.... Shawn Grover -----Original Message----- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 10:01 AM To: CF-Talk Subject: RE: SQL Statement dumping data WOW!!, I haven't worked with DTS packages and not much with stored procedures. I will do some research. You think that this is a better solution then building a cf template and setup an automated task to run the cf template (in order to process the csv file)? Thanks, Jason Larson -----Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:50 AM To: CF-Talk Subject: RE: SQL Statement dumping data set up a DTS package to import the CSV file. create an SP to run the DTS package. use SQL Agent to schedule the SP. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:31 AM To: CF-Talk Subject: RE: SQL Statement dumping data What I am trying to accomplish is: I have a client that will be pushing up a csv file to a site and then I will setup a autmoated task that will dump all the data in a table and then refresh the data with the data in the csv file. Thanks for the quick reply Jason -----Original Message----- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:26 AM To: CF-Talk Subject: Re: SQL Statement dumping data Do you mean delete all the data or Export the data? Clint ----- Original Message ----- From: "Jason Larson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 08, 2002 10:22 AM Subject: OT: SQL Statement dumping data > I was wondering if anybody had the sql statement that will allow me to > dump all the data out of the table in a database? > > Thanks for the help > Jason > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists