This optional string array enables the use of SQL bind
variables with GetSessionQuery
. Set
GetSessionQuery
using the SQL bind variables or
without them. If you use the SQL bind variables, you must specify all
query parameters with respective
GetSessionQueryParam
s. Here is an example of using
the SQL bind variables:
GetSessionQuery SELECT expiry FROM sessions WHERE roomNumber=? AND guestNumber=?
AND macAddress=?
GetSessionQueryParam %0
GetSessionQueryParam %1
GetSessionQueryParam %2
The same query without the SQL bind
variables looks this:
GetSessionQuery SELECT expiry FROM sessions WHERE roomNumber=%0 AND guestNumber=%1
AND macAddress=%2