| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-16 : 09:44:33
|
| Jason writes "Is there a way to post data to a web page via a stored procedure? For example, I want to pull data from the database and then submit that data to a web page. Thanks!" |
|
|
pmr
Starting Member
37 Posts |
Posted - 2003-05-16 : 13:11:37
|
| Do you have a web server? |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-05-16 : 13:24:04
|
| If you are looking for a "Save As ... HTML" you are not going to find it.Jay White{0} |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-16 : 14:04:06
|
| What about sp_makewebtask and ftp?Brett8-) |
|
|
|
amprewave
Starting Member
2 Posts |
Posted - 2003-05-16 : 16:15:31
|
| I do own a web server (several actually). So I have full control over anything that needs to happen in that regard.Specifically, I want to submit data to a specific URL, similar to a form post or get.Unfortunately, FTP is not possible. The sp_makewebtask is interesting, though. I am reading about it on Microsoft's website. I am not certain it will work, though. |
|
|
|
jackstow
Posting Yak Master
160 Posts |
Posted - 2003-05-19 : 06:00:17
|
| I guess you could use sp_makewebtask to create an html file with the data you want in hidden form fields - you'd need to browse to that page and submit it though.Why do you want to post to a web page from a stored proc? Maybe there's an easier way to do want you want to do. |
|
|
|
amprewave
Starting Member
2 Posts |
Posted - 2003-05-28 : 23:11:48
|
| I want to submit a credit card transaction. I can do batch uploads and all the rest, but it is easier if I could just have a sproc submit the the data to processor via a url.I don't think that sp_makewebtask is really the best solution for that. I am looking into some other things, but it looks like I will manually have to continue to do it. I have it set to do in a few moments, so it isn't too bad. |
|
|
|
Lavos
Posting Yak Master
200 Posts |
Posted - 2003-05-28 : 23:33:54
|
| Does the processor have a web service? Your best bet is to make a program using ADO, or whatever data access method that floats your boat, that takes the data, formats it, and posts it, as opposed to trying to make SQL Server do it.----------------------"O Theos mou! Echo ten labrida en te mou kephale!"So Long and Thanks for the Links. |
|
|
|
jackstow
Posting Yak Master
160 Posts |
Posted - 2003-05-29 : 04:56:47
|
| Something like dotnetCHARGE - http://www.dotnetcharge.com/ - might do the trick - that way you don't need to do a post to the payment processor at all - you can do it all within the code on your page. |
|
|
|
|
Post data to a web page via sproc