You could write: PermanentEndpointsQuery=SELECT peip, IF(LENGTH(peport), peport, 1720) As peport, pealias, IF(LENGTH(peprefix), peprefix, NULL) As peprefix FROM petable WHERE GatekeeperId = '%1' to fix this. But the fix in the code is also necessary to have an elegant solution. Thanks for pointing this out! ----- Original Message ----- From: "AP MUTHU" <apmuthu@xxxxxxx> Sent: Wednesday, April 14, 2004 8:24 AM SQLConfig -> PermanentEndPointsQuery In Toolkit.cxx, a hard coding 'error?' on line 626:- params[0] + ":" + params[1], params[2] + ";" + params[3] results in : and ; being inserted if params[1] and/or params[3] is null or blank. If NULL is converted automatically to blank and shows params[1] and params[3] uniformly blank then the : and the ; can be eliminated if coded based on IF statement. My currently used MySQL query in SQLConfig:- PermanentEndpointsQuery=SELECT peip, IF(LENGTH(peport), peport, NULL) As peport, pealias, IF(LENGTH(peprefix), peprefix, NULL) As peprefix FROM petable WHERE GatekeeperId = '%1' when tested for a blank or null - port and prefix field results in:- EP|192.168.17.81:0|deci:h323_ID|gateway|5158_isogk1 in the GKTRACE and 192.168.17.81:=deci; in the temp ini instead of the desired:- EP|192.168.17.81|deci:h323_ID|gateway|5158_isogk1 in the GKTRACE and 192.168.17.81=deci in the temp ini Is a change in the code necessary? Many databases yield NULL and blank and empty. ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/
