3.54.2. HostSelectParam Previous topic Parent topic Child topic Next topic

This optional parameter specifies a bind variable to be used with HostSelect. %1 is replaced with unquoted realm. For more information, see Section 3.6.1. SQL bind variables.
Here is an example of using HostSelectParam:
# Use bound parameters to improve performance in SQL
HostSelect select HOST%0, SECRET, AUTHPORT, ACCTPORT, RETRIES,\
RETRYTIMEOUT, USEOLDASCENDPASSWORDS, \
SERVERHASBROKENPORTNUMBERS, SERVERHASBROKENADDRESSES, \
IGNOREREPLYSIGNATURE, FAILUREPOLICY from RADSQLRADIUS where TARGETNAME=?
HostSelectParam %1
NumHosts 1