3.17.4. UpdateQuery Previous topic Parent topic Child topic Next topic

This SQL statement is executed whenever Accounting-Request Alive or Interim-Update message is received. It is expected to update the details of the session in the SQL database. Special formatting characters may be used (the %{attribute} ones are probably the most useful). %1 by the NAS IP address, %2 by the NAS-Port, %3 by the SQL quoted Acct-Session-Id. If UpdateQuery is defined as an empty string, then the query will not be executed and ReplaceQuery, if defined, or AddQuery otherwise, will be used. The default is the empty string.
%0 is formatted as defined in section Section 3.17.2. AddQuery. Section 3.8.1. SQL bind variables are supported.