<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.2900.3429" name=GENERATOR>
<STYLE>BLOCKQUOTE {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 2em
}
OL {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
UL {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</STYLE>
</HEAD>
<BODY style="FONT-SIZE: 10pt; FONT-FAMILY: verdana">
<DIV><FONT face=Verdana size=2>
<DIV><FONT size=2>Hi ,</FONT><FONT size=2>I am a student studying in
VoIP and implementing my theory in SER.</FONT></DIV>
<DIV><FONT size=2>I try to access mysql database to get some information,
but </FONT><FONT size=2>have a problem aboout paramaters
of exe_msg.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2> My goal is :count the number of contact
addresses that certain user registered, and take </FONT></DIV>
<DIV><FONT size=2>this is my solution: </FONT></DIV>
<DIV><FONT size=2>exec_msg(' Count="select count(contact) from location where
username=\"$SIP_HF_CONTACT\" "'</FONT></DIV>
<DIV><FONT
size=2> CountResult=`mysql
-user -pheslo -e "$Count" ser`;</FONT></DIV>
<DIV><FONT
size=2>
')</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>What is the result of "CountResult" ?</FONT></DIV>
<DIV><FONT size=2>I suppose originally that it will be the the number of
the query, but it seems not.........</FONT></DIV>
<DIV> </DIV>
<DIV>and i try the exec_msg('rm -r test'); but it failed;</DIV>
<DIV>Dose the function wored? and how to use it,<FONT size=2>Hhw can I get
my answer what I want to get ?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Hoping someone can give me some advises ^^.</FONT></DIV>
<DIV><FONT size=2>Thannks in advance.</FONT></DIV></FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV align=left><FONT face=Verdana color=#c0c0c0 size=2>2009-02-26
</FONT></DIV><FONT face=Verdana size=2>
<HR style="WIDTH: 122px; HEIGHT: 2px" align=left SIZE=2>
<DIV><FONT face=Verdana color=#c0c0c0 size=2><SPAN>ÇñÀÚ</SPAN>
</FONT></DIV></FONT></BODY></HTML>