(RADIATOR) 2 SQL sentences in AddQuery

Jon Omagojeaskoa omago at sarenet.es
Wed Jul 4 11:15:23 CDT 2001


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
<omago at sarenet.es>
+34 94 4209470
-------------------------------------------------------------------

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


More information about the radiator mailing list