FN-FORUM: ASP Shopping Cart Help

date posted 27th February 2008 22:30

Hi,

I have an ASP shopping cart script on a clients website which appears to work
as it should. The only problem is when a new customer adds something to their
basket it doesn't always create a new ID and row in the database. The customer
then has a basket full of items in their basket which they haven't added. The
add to cart script is:

Sub CreateNewOrder()
Application.lock
if Application("orderID") = "" then
Application("orderID") = 1
end if


intOrderID = Application("orderID")
Session("orderID") = intOrderID
Conn.Execute("INSERT INTO orders " _
& " (orderID, status) values " _
& " ("&intOrderID&", 'OPEN')")

Application("orderID") = Application("orderID") + 1
Application.Unlock
End Sub

Any ideas?

TIA



Going on holiday?
Need Travel Insurance?

www.easyholidayinsurance.com