If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

HTTP POST From SQL Server

gogul · 2005-02-10 10:00:06

Hey, I was wondering if anyone knew how create a SQL stored procedure that will send POST data to a webpage and then retrieve the information returned by the page? Cheers

10-02-2005 10:00am

#1

gogul

Closed Accounts Posts: 216 ✭✭

Join Date: July 2004

Posts: 172

Hey,
I was wondering if anyone knew how create a SQL stored procedure that will send POST data to a webpage and then retrieve the information returned by the page?

Cheers

0

Comments

#2 10-02-2005 1:02pm

ressem

Registered Users, Registered Users 2 Posts: 2,426 ✭✭✭

Join Date: April 2002

Posts: 2383

Looks like it is possible going by using EXEC to call a com component

an example using smtp component
http://www.emailarchitect.net/webapp/smtpcom/developers/sqlemail.asp

but instead using the winhttp control or wininet
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winhttp/http/network_terminology.asp

Though probably would be preferable to create your own com control to contain this stuff.

0
#3 13-02-2005 1:29am

Zaph0d

Closed Accounts Posts: 756 ✭✭✭

Join Date: July 2004

Posts: 673

Here's an example using GNU wget.

wget has a --post-data option that lets you specify a string or a filename for POST data. You can find wget here

0