(RADIATOR) Executing SQL statement according to another SQL statement from diffrent database

[Bulent Gulcan]

Hello All,

We are using radiator and MSSQL database for authentication and accounting.

We are trying to update one column in CUSTOMER table of SUBBCRIBER database,
if an entry exist in ACCT table of ACCOUNTING database.
In other words :
IF exist (or not exist) ..... in ACCT table in ACCOUNTING database THEN
update column A in CUSTOMER table in SUBSCRIBER database.

As I read from radiator documentation, we can connect only one database and
make sql queries in one <AuthBy SQL>....</AuthBy> clause.

Can we use the result of a SQL query from a database for other sql queries
from another database ?

Thanks for your help.
Regards

Bulent Gulcan
Is Net A.S.

--
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.