I have a client who has his own website.
On the website he has a map of a show terrain.
Each of the locations has a hot spot with a value (say 'S01') which when pressed can redirect to a URL.
Our idea is for him to redirect to my website with something like
http://mywebsite.com/checkstatus/?S01.
What I want to do from my website is:
a. Check that that location is available. I have a table with an Unique identifier (not the Primary Key) which would be able to check the status of the record if I do something like
STA:Code = 'S01'
Access:Stall.Fetch(SK_StallCode)
One of the fields in the Stall table contains the status of the stall (Available/Not Available)
So I would then return a not available message or allow the user to continue is the status is available.
My question is if I received the above URL what would I need to do to store the value S01 into a session variable since once I have that the rest should be straightforward.