Re: Query error in Acct table for Tenant_ID

hi, stop rewind. the setting of the variable would go into the main virtual_server file - not in the SQL config - as i said, read the unlang manual and sql module guide to see how these things work. to the SQL query in the eg accounting section BEFORE the call to sql in the accounting section eg accounting { .. .. .. update request { tenant_list = %{sql:"SELECT tenant_id FROM ${client_table} WHERE realipaddr = '%{NAS-IP-Address}'"} } .... sql ... } then use that variable in your UPDATE command in the SQL module alan