asp cart into database

[cancan]

hi all,

i have a shopping cart working fully at the minute, just having problems inputting the data into the database.

I have a cart table: cartid, customerid

i can get the customerid to input fine from a session however when i add more than one item to the cart i get different cart id's for the products i.e.

1st product, cartid 1, customerid 1
2nd product, cartid 2, customerid 1

etc

i do have a session on this page Session("cart") = cartID which does hold the correct value

but going back to retrieve a second product adds 1 to the cartid
can anyone help me please

[ahmedel]

Is your application hosted in a farm? Are cookies enabled in your browser? Either of these could affect the Session state not being stored from one request of the page to the next.