Re: SQLConfig - PermanentEndPointsQuery on blank or NULL Port, Prefix

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux