RE: [CFTALKTor] Remote Update of Database

[terry]

Well...   You can get Perl for windows, and there are job schedulers one can get for Windows (or are included in Winblows 98+), so you should still be able to accomplish what you are asking.   Make a cold fusion page which effectively accepts a form submission and allows you to put data directly into the database (or update given a primary key as part of the form).  You can even do deletion by tacking on a status field with a flag for records that you want deleted.   I do this sort of thing to move database info across numerous websites (although rarely using CF, almost always using Perl or PHP as the server side code).  It is essentially platform independent data transfer, not the most efficient, but highly effective.   Terry Fielder Network Engineer Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED]   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Sent: Wednesday, July 10, 2002 11:24 AM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] Remote Update of Database Hi Terry,   Actually I am in a Windows environment.  I know how much you like windows :) ----- Original Message ----- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 11:00 AM Subject: RE: [CFTALKTor] Remote Update of Database If your client machine is Linux/perl, you can script this to be done as a cron job with a simple script.   Terry Fielder Network Engineer Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED]   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Sent: Wednesday, July 10, 2002 10:47 AM To: [EMAIL PROTECTED] Subject: [CFTALKTor] Remote Update of Database Hello All,   I was wondering if someone could offer a suggestion for a certain task I would like to perform.  I have a client that is running a VB application that creates an Access database.  I then take that database and upload it to the web daily and over write the access database on the web and site gets refreshed.  This was fine when the database was small now I find myself dealing with a 150 - 200 mb database.  Does anyone know of a way that I can insert a record from my local machine to a remote server and validate that the record was indeed updated without checking the website?  This would be a process that I would like have running over night.   Thanks   Mike