scotitpulsa
IS-IT--Management
I have a c# app that hits a mysql database. Basically multiple users at any time can make a wide range of selections on a front end page, then based on the selections a query in a session variable is created. After selections are finished, they click go, and the query that was built based on the selections executes to the DB and results are returned. My problem is this:
When two or more users are using the app, if user 1 makes a selection, then immediately user 2 makes a selection, and user 1 clicks "GO", user 1 will get user 2's selection? Any idea on how to prevent this?
When two or more users are using the app, if user 1 makes a selection, then immediately user 2 makes a selection, and user 1 clicks "GO", user 1 will get user 2's selection? Any idea on how to prevent this?