Re: (RADIATOR) query during insert data

i have made other AuthBy SQL AuthBy SQL DBSourcedbi:mysql:bill DBUsername xxx DBAuth AccountingTable accounting AcctSQLStatement update set time_bill=ceiling(acctsessiontime/60) /AuthBy i'm confused about one thing at

Re: (RADIATOR) query during insert data

Hello Budi - Can you tell me exactly what you want to do? I am not clear on what you want to have happen. The simplest way to carry information between AuthBy clauses is to add it to the incoming request packet which can be used as a scratch-pad area for this purpose. regards Hugh On

Re: (RADIATOR) query during insert data

i have tried to add this AcctSQLStatement update set time_bill=ceiling(%{Acct-Session-Time}/30) or AcctSQLStatement update set time_bill=ceiling('%{Acct-Session-Time}'/30) after that i make call for 5 seconds then check at mysql and got 0 it should be 1 any idea? rgds budi --- Hugh

Re: (RADIATOR) query during insert data

Hello Budi - Can you please send me a copy of your configuration file (no secrets) together with a trace 4 debug from Radiator showing what is happening. I will also need to see a copy of the relevant SQL records. In general you should test your SQL queries interactively with whatever tools

Re: (RADIATOR) query during insert data

ok here we go from trace 4 result .. AcctSQLStatement is executed first time before i got the paramater from AcctColumnDef. that makes the value always 0 any idea to make AcctSQLStatement executed after AcctColumnDef? AuthBy SQL DBSourcedbi:mysql:bill

Re: (RADIATOR) query during insert data

Hello Budi - You should use two AuthBy SQL clauses with the AcctSQLStatement(s) in the second one. Alternatively you could possibly use a hook (there are some examples in goodies/hooks.txt). regards Hugh On Thursday, Jun 12, 2003, at 18:21 Australia/Melbourne, budi wibowo wrote: ok

(RADIATOR) query during insert data

can i do mysql query during data insertion? i have read a litle about SessionDatabase keyword but the information is not detail enough any idea? rgds boed __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM).

Re: (RADIATOR) query during insert data

Hello Boed - You should have a look at the AuthBy SQL clause in section 6.28 in the Radiator 3.6 reference manual. doc/ref.html You can use the AuthSQLStatement to insert during authentication and you can use the AcctSQLStatement to insert during accounting (you can also have multiple