3.79.16. GetCurrentServiceQueryParam Previous topic Parent topic Child topic Next topic

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 GetCurrentServiceQueryParams. 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
For more information about SQL bind variables, see Section 3.6.1. SQL bind variables.