What I want is something like the following.
add another column in the voipcall table called tariffID.
then, after the call details have been inserted there,
select grpid from voiptariffsel where accountid = voipcall.accountid, and insert that gripid in the tariffID at the end of the table.
Not a big thing.. just want to get the grpid from the voiptariffsel table and insert it there.
Since I am keeping my grpid's unique, it is fine even when the details are deleted.
Cheers,
Shashi
On 10/18/05, Zygmuntowicz Michal <m.zygmuntowicz@xxxxxxx> wrote:
That's not the best idea, because a CDR should
not depend on external tables. Think what will
happen if you delete this tariff or an other tariff
will replace this one. Tariffs are dynamic and change
rapidly, while CDRs, once created, should not change.
----- Original Message -----
From: "Shashi Dahal" <shashi0@xxxxxxxxx>
Sent: Tuesday, October 18, 2005 12:06 PM
I configured gnugk+freeradius+sqlbill/postgresql and it works very good.
I was wondering if anyone has changed it to include tariffID in the voipcall
table too.
If not, any ideas to the right direction would be highly appretiated.
Cheers,
Shashi
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________________
Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/
