Stuart Sammels
|
| Posted: 08/28/2001, 6:33 PM |
|
My friend Alan asked the following question at the gotocode.com site - but
no answer yet. Please help as I need this info also!!!
Alan wrote:
I am using the bookstore example and have created the checkout page with no
problem as per the verisign example. I do not want to use verisign as I will
use a SSL folder. I have created the link on the bottom of the prepare
checkout page to take the customer to the final page (which would have been
the verisign confirmation page). I have set up the page as per the verisign
example but need only to send the info to the purchases table and delete
from the orders table. I know I should put this in the open events in the
final page but I have little programming background and need a little help.
I know this code is wrong I have no code experience but I think it is close
to what I need.
The final page.
In the open events:
Session("UserID")
cn.execute("insert into purchases (order_id, member_id, item_id,
quantity) select order_id, member_id, item_id, quantity from orders
where member_id = " & Session("UserID"))
end if
and in the closing events to delete orders:
if Session("UserID") then
cn.execute("delete from orders where member_id - " & Session("UserID"))
end if
|
|
|
 |
Stuart Sammels
|
| Posted: 08/29/2001, 7:30 AM |
|
Got it thanks to CC support.
Here it is for anybody else.
cn.execute("insert into purchases (order_id, member_id, item_id,
quantity) select order_id, member_id, item_id, quantity from orders
where member_id = " & Session("UserID"))
Thanks CC Support for the speedy response!
Stuart Sammels
|
|
|
|
|
