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