Update records before form submit

[azrobert]

I have a form with a submit button that takes the user to paypal to process payment of an order. I would like to move the order from the temp table to order table as this is done. Bassicaly I need to call my stored proc when the user hits the submit button but before they leave my page for paypal. What is the best method to accomplish this.

Right now I send the user to an action page that processes the order, then takes them to paypal, but they can bail out from paypals page and leave an un-paid order. (i can check all this and delete later if I don't receive the ipn from paypal) but I would rather do both on the submit button.

Thanks in advance.

 

[azrobert]

In further though..... even if I preform the update and submit at the same time they can still bail out at paypal... still would be nice to do both at the same time.

 

[aalmeida]

Azrobert,

This is an inheritance issue of using Pay Pal, you actually have to send the record to a staging table first while you wait for Pay Pal to confirm the payment once that occurs you must be able to recognize which transaction is this for then you can move on.

AL Almeida
CIO

http://www.artdigitalonline.com/

May all those that come behind us, find us faithful

 

[azrobert]

Yea, I have the PayPal ipn part working and updating the orders table as a Paid record.... Guess I will have to make a "sweeper" procedure that clears out un paid oreders every so often.

Thanks