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