In this case the ConfigQuery should return exactly one row with three columns: RasSrv::GWRewriteE164 GK1 in=00=1234;in=0=1235;out=11= ----- Original Message ----- From: "Edson" <4lists@xxxxxxxxx> To: "'GNU Gatekeeper Users'" <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx> Sent: Wednesday, October 31, 2007 2:14 PM Subject: SQL Query for [RasSrv::GWRewriteE164] > Hi... > > How should I use the [SQLConfig] section to automate the > [RasSrv::GWRewriteE164] definitions? > > As an example, supose that I have this text entry: > > GK1=in=00=1234;in=0=1235;out=11= > > For this, should this query and result be ok? > > "SELECT gk_name, direction, prefix, result FROM table WHERE gk=%1" > > +---------+-----------+--------+--------+ > | gk_name | direction | prefix | result | > +---------+-----------+--------+--------+ > | GK1 | in | 00 | 1234 | > | GK1 | in | 0 | 1235 | > | GK1 | out | 11 | | > +---------+-----------+--------+--------+ > > Edson ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/
