Forums

I want to prevent DB-conflicts  because of many users start orders  in my shop-system simultaneously.

Can I use Transaction start / commit ? Or what are these actions for?

Hi Eddi

it depends on the kind of conflict you want to prevent, what is the current problem you are having ?

I am working on a ticket-ordering-system for a small Theater.

Szenario: 

• We have 1 tiket left.
• costumer 1 opens the orderform , sees 1 Ticket left
• costumer 2 opens the orderform , sees 1 Ticket left too
• costumer 3 opens the orderform , sees 1 Ticket left too

When each of them presses the "order now" button and submits the form, they all get an "Order OK-Message".

I want the first costumer, who submits ,  to win the order.

Can I use the autocommit off /on mechanism in CF7??

Are CF7 DB-actions Transaction start /Transaction commit solutions to my Problem?

Beside that, I like to know , what is the function of these actions?

Eddi