Below are links to OpenSER documents and examples that  will answer your questions.

OpenSER Documents: http://openser.org/index.php?option=com_content&task=view&id=34&Itemid=51

OpenSER Module Documents: http://openser.org/docs/modules/devel/

AVPOPS Module Document: http://openser.org/docs/modules/devel/avpops.html

Section 1.5.4. avp_db_query(query[,dest]):  http://openser.org/docs/modules/devel/avpops.html#AEN268

OpenSER Docuwiki:  http://openser.org/dokuwiki/doku.php

AVP Examples: http://openser.org/dokuwiki/doku.php?id=avp_examples&DokuWiki=5cbf7be84b819d9044e1b4763ef1bee8

avp_db_query() examples: http://openser.org/docs/avp_db_query.html

Regards,

Norm

zm23 wrote:

Hi,

    I want to store some information in a separate table in mysql database.  Think of it as a second user preference table but I want to keep that information separate.  What will be the best way to achieve that?  So that I am able to lookup values from this additional table and use it to make routing decisions.   Also, does openser provide a way to do custom sql queries.

Thanks in advance for your help.

-- 

Zahid Mehmood

CUIT Network Systems

------------------------------------------------------------------------

_______________________________________________

Users mailing list

Users@openser.org

http://openser.org/cgi-bin/mailman/listinfo/users

  ------------------------------------------------------------------------

No virus found in this incoming message.

Checked by AVG Free Edition.

Version: 7.1.405 / Virus Database: 268.10.7/411 - Release Date: 8/7/2006