SQL Stored Procedure Help 1

[phil2k]

Does anyone know whether it is possible to call a URL from a stored procedure?

Thanks in advance.

Phil

 

[vongrunt]

For exactly what purpose?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[phil2k]

We have a user interface that does not give the user any feedback if for example there is an error with data entry. We can not program a message box to pop up directly form the interface so the idea is to use webpages to display the message. If a stored procedure could open IE and go to a specific address it would solve our problem.

Hope this helps

Phil

 

[gmmastros]

Phil,

SQL Server is for data storage, not a front end. You can use SQL Server to store the URL for the page you want to display. The code that displays the URL should be in your front end app.

So, basically, if your stored procedure generates an error, you can return the URL for the web page. Your app should know that an error occurred and display the url within a browser.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[richardy]

Phil,

You could get it to send a network message if their on the lan...


Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.

 

[phil2k]

Richard

How would I do that and would it work on a Novell Network?

Cheers
Phil

 

[richardy]

Example from books online:

EXEC xp_cmdshell 'net send /domain:SQL_USERS ''SQL Server shutting down
in 10 minutes. No more connections allowed.', no_output


Essentially it executes any command prompt command, I seem to remember Novell uses net send as well :S

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.

 

[phil2k]

Thanks a lot Richard

Phil