CODEWITHSUNDEEP
stored-procedurescoldfusion
Dsmithdallas
Dsmithdallas

Reputation: 31

How can I issue a coldfusion stored procedure call and not wait for the result

fellow ColdFusion developers. I am working in a restricted environment. I cannot make any adjustments to the timeouts, or set up an asynchronous gateway. Nor do I have access to the CF server settings. What I want to do seems simple. I want to kick off a stored procedure with arguments, and not wait for the results. In fact, the procedure updates data on its own and does not return anything. I have seen similar questions but there doesn’t seem to be a simple answer. Any help wound be appreciated.

Upvotes: 3

Views: 388

Answers (2)

Alex Baban
Alex Baban

Reputation: 11742

If you can't use cfthread, you could try to use cfhttp with a timeout. Move the stored procedure call out to a new page. Use cfhttp to call the new page from the place where you had the stored procedure call.

Upvotes: 1

Scott Stroz
Scott Stroz

Reputation: 7519

Put your call to the stored procedure in a cfthread

Upvotes: 13

Related Questions