the problem is code order.
instead of using the recordset column in the validation, add a hidden form element to the add to cart button form that passes the TournamentPrice and use that form element in the validation.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.