|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Executing an application from a queryHi All,
Is it possible to execute a file or perhaps send a call to a webpage using an SQL query? Does anyone know of any such feature. Basically I need to call a webpage(coldfusion script) from my query and I am wondering if anyone knows of any way that his would be possible. Thanks a heap in advance for all your help ! Harkirat >> Is it possible to execute a file or perhaps send a call to a webpage Can you be more specific? SQL Queries are executed on the server while web >> using an SQL query? Does anyone know of any such feature. pages are displayed on the client. So what exactly do you mean by "calling" a webpage? Are you trying to display the webpage on the client or somewhere else? SQL Server has some provisions for generating web pages based on generated resultsets, but I am not sure that is what you are looking for. -- Anith Hi Anith,
What I need to do is be able to execute a coldfusion script via a query. The script can be run via a webpage e.g. http://mysite.com/CFScript.cfm So if I could make a 'call' to my webpage via my query that would work. Also if this is not a possibility would it be possible to execute a ..exe file using a query? That might help too. Thanks for your reply. Harkirat Anith Sen wrote: Show quote > >> Is it possible to execute a file or perhaps send a call to a webpage > >> using an SQL query? Does anyone know of any such feature. > > Can you be more specific? SQL Queries are executed on the server while web > pages are displayed on the client. So what exactly do you mean by "calling" > a webpage? Are you trying to display the webpage on the client or somewhere > else? SQL Server has some provisions for generating web pages based on > generated resultsets, but I am not sure that is what you are looking for. > > -- > Anith You can use a stored procedure to execute an .exe file using
xp_cmdshell, but there are security issues. I don't think that it;s the best approach to what you are trying to do, however; what does a cold fusion script have to do with your data? Can you provide a little more detail about the business problem you're trying to solve, and perhaps we can suggest a better alternative. Stu Hi Stu,
My coldfusion script has logic that updates a table in the database. I need this process to run everytime a new row is inserted in my table. Hence I was thinking of putting an insert trigger that calls this coldfusion script. Can you give an example on how to execute a .exe using a stored procedure. I could perhaps make a .exe that executes the coldfusion script which in turn would be called via my trigger. Thanks. Harkirat Hi
Look at xp_cmdshell in BOL. If your exe fails, the insert will get rolled back as an error like that can not be handled in T-SQL. It is not a good idea. Rather write a row in a queue table, and have something poll the table and then call your exe. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: m***@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ Show quote "harry" <i1***@tamu.edu> wrote in message news:1124657414.378047.144430@g44g2000cwa.googlegroups.com... > Hi Stu, > My coldfusion script has logic that > updates a table in the database. I need this process to run everytime a > new row is inserted in my table. Hence I was thinking of putting an > insert trigger that calls this coldfusion script. > > Can you give an example on how to execute a .exe using a stored > procedure. I could perhaps make a .exe that executes the coldfusion > script which in turn would be called via my trigger. > > Thanks. > > Harkirat > Hi Mike,
I had already thought of that. Seems like my best bet now. Thanks for your help. Harkirat I think your application would perform better if you could keep the
database logic at the dataase level; if it were me, I would probably simply run the logic in T-SQL as part of the trigger. Why bubble back up (unless of course your coldfusion script is extremely complicated)? As for an example, I don't write many triggers, and I disable xp_cmdshell altogether. Books OnLine is your best bet. Stu Hi Stu,
My coldfusion is indeed complicated thats why I don't wish to do it in SQL. Thanks for your help. Harkirat  |
|||||||||||||||||||||||
Other interesting topics