Figure 2 prAPP_Get_SessionValues
CREATE PROCEDURE prAPP_Get_SessionValues
@sSessionKey UNIQUEIDENTIFIER
AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT
s.sSessionKey,
sd.sVariableName,
sd.sValue,
s.dtLastAccessDateTime
FROM tblSession s
INNER JOIN tblSessionData sd ON s.sSessionKey = sd.sSessionKey
WHERE sd.sSessionKey = @sSessionKey
ORDER BY
sVariableName
-- Update the "Last Access Date/Time"
EXECUTE prAPP_Update_Session @sSessionKey
Figure 3 prAPP_Update_Session FakePre-d0596561b85c4aeb9c3b5aaa1a446630-a8182b8056bd44ba8079c0e47503da14 Figure 4 CreateSession Excerpt FakePre-477279ef5d15447e9ee0f4d07a53808a-47bfae263d0e4719b891c58466c81199 Figure 5 The Encryption and Decryption Functions FakePre-d41454830b1c4a1ca8e94dd86c0c0fc9-e5a80485e6a540ccabe238b9f92fe6bd Figure 6 GetRecords FakePre-0e10dc0115df41368907a240c79174ab-3910cc4b24074a10b246ea21c6da12c4 Figure 7 The GetSelectedRecords Private Function FakePre-1d1f771ade804562a797a8691315e91b-2a703c9c306e4afeac335d40a5d6294a Figure 10 Connect.asp FakePre-b81da336d8cc4d2ebda696bb3ea42510-a0248922d4874aa29a267af16b0a5574 Figure 11 SomePage.asp FakePre-632a27d2b71744ff9c1f447c40e1acc5-bbd66023af3c40f1b52eaaaa7a8035e0