accounting - more than one query
Hi In accounting section i'd like to run at least two quieries to database but when i write: #v+ start { query = "INSERT INTO one ..." query = "INSERT INTO two ..." } only this first is executed :/ how to execute more than one query? -- Pozdrawiam Marcin / nicraM
On Dec 9, 2015, at 3:24 PM, Marcin <marcin@nicram.net> wrote:
Hi In accounting section i'd like to run at least two quieries to database but when i write: #v+ start { query = "INSERT INTO one ..." query = "INSERT INTO two ..." }
only this first is executed :/ how to execute more than one query?
Configure two SQL modules. Or, have a stored procedure on the SQL server which does the two inserts, and run the procedure from FreeRADIUS. Alan DeKok.
2015-12-09 21:32 GMT+01:00 Alan DeKok <aland@deployingradius.com>:
On Dec 9, 2015, at 3:24 PM, Marcin <marcin@nicram.net> wrote:
Hi In accounting section i'd like to run at least two quieries to database
but
when i write: #v+ start { query = "INSERT INTO one ..." query = "INSERT INTO two ..." }
only this first is executed :/ how to execute more than one query?
Configure two SQL modules. Or, have a stored procedure on the SQL server which does the two inserts, and run the procedure from FreeRADIUS.
Ok, thanks for quick reply
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Pozdrawiam Marcin / nicraM
participants (2)
-
Alan DeKok -
Marcin