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