Forwarding database results to another site 1

[FastEddieC]

Hi all!
I think I've been barking up the wrong tree.
I have a .ASP search page that gets it's results from a database and I need to make a button to forward that info to a "online bill pay" site. I'm trying to learn how to make that happen, so I searched google for "ASP + databse results + forwarding" and the like but I think I'm asking it the wrong questions.

Can someone advise me on what I should be searching for so I can read up on how to do this?

Thanks,


Eddie

 

[kaht]

What online bill pay site? Each site is likely different in the way that it will accept information. I would guess that it all depends on how you build the querystring for the address of the site that you're forwarding to. You'll need to know what the names of the parameters are that the online bill pay site accepts.

To give you an example, you could forward information pulled from a database straight into a google search. All you need to know is url of the search page and that google accepts a parameter q for the search criteria.

For example if we pulled the word test out of the database we could search for "test" at google by building the following url with the appropriate querystring:

http://www.google.com/search?

[!]q=test[/!]

-kaht

Lisa, if you don't like your job you don't strike. You just go in every day and do it really half-assed. That's the American way. - Homer Simpson

 

[FastEddieC]

Kaht,
I finally got that info from my destionation site - paymybill.com.
They accept forwarded info like Google does. Their URL would look like this:

https://www.paymybill.com/default.asp?account=000000&password=1234567&hidden=1&amount=100.01

I think I know how to do this from a form (using the GET method) but can it be done once the form has already produced the results?

Any help would be greatly appreciated,


Eddie

 

[FastEddieC]

Kaht - Are you still out there?

 

[kaht]

Not sure I understand your question. You said that you wanted to pull the info from a database and create a button to forward straight to the bill pay site. Just use the info that you pull out of the database to build the appropriate link.

If you are talking about having a user type this info into a form on your page, submit the form, and then redirect to the billpay site - well, then you're not really using the database at all, you're getting the info from the form. In this instance I would not use the get method, instead use the post method, pull the data submitted from the form, and then redirect the page to the bill pay site. I'm not sure of your server side language, but using ASP it would look something like this:

a = request.form("accountnum")
b = request.form("password")
c = request.form("amount")

response.redirect "[URL unfurl="true"]https://www.paymybill.com/default.asp?account="[/URL] & a & "&password=" & b & "&hidden=1&amount=" & c

I think that any more questions about this would be better suited in the server side language you're using, since it's not really an HTML or CSS question. Hope that's enough to get you going.

-kaht

Lisa, if you don't like your job you don't strike. You just go in every day and do it really half-assed. That's the American way. - Homer Simpson