How can I concat 2 SQL sentences in <SessionDatabase SQL>'s "AddQuery" ?
I've tried with ";" :
AddQuery insert into RADONLINE \
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID,
TIME_STAMP, \
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) \
values ('%n', '%N', %{NAS-Port},
'%{Acct-Session-Id}', %{Timestamp}, \
'%{Framed-IP-Address}', '%{NAS-Port-Type}',
'%{Service-Type}') ; \
update RADPOOL set STATE=2 WHERE
YIADDR='%{Framed-IP-Address}'
But :
Wed Jul 4 20:09:32 2001: DEBUG: do query is: insert into RADONLINE
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('omago', '203.63.154.1',
1234, '00001234', 994270172, '212.81.164.11', 'Async', 'Framed-User');
update RADPOOL set STATE=2 WHERE YIADDR='212.81.164.11'
Wed Jul 4 20:09:32 2001: ERR: do failed for 'insert into RADONLINE
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('omago', '203.63.154.1',
1234, '00001234', 994270172, '212.81.164.11', 'Async', 'Framed-User');
update RADPOOL set STATE=2 WHERE YIADDR='212.81.164.11'': You have an error
in your SQL syntax near '; update RADPOOL set STATE=2 WHERE
YIADDR='212.81.164.11'' at line 1
Thanks.
-------------------------------------------------------------------
Jon Mikel Omagojeaskoa Insunza
SARENET
<[EMAIL PROTECTED]>
+34 94 4209470
-------------------------------------------------------------------
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
