Run CF Page not browser dependent

[DeZiner]

In all my reading I haven't seen a way to execute a query without calling a page via a browser. I run some large queries often that sometimes take 30-45 minutes a piece. I've had to edit the registry on the machine I use as so the browser doesn't time out. Any way to execute a query (no results are returned to the page, just DB updates) without a browser?

DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[ecobb]

What type of database are you using? This sounds more like something you would want to do directly on the database instead of through a browser using CF.

 

[bhightower]

i agree with Ecobb this sounds like it might need to be a stored procedure....(dependent on what type of database you are running)


------------------------------------------------------------------------------
brannonH
if( !succeed ) try( );

 

[SidianConsulting]

You could use your native database features (e.g. DTS in SQL Server) to execute procedures/packages on a regularly scheduled basis. You could also use CF's built-in scheduler to run .cfm files that contain the SQL you want to run, which doesn't require a browser at all, either.

-Tek

 

[jalbao]

yes@stored proc..

but if you are dead-set on using cf for this task, you can run the page that contains the db updates via the coldfusion scheduler.