<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=big5">
<META content="MSHTML 6.00.2800.1476" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>If not, what it will be? How can I get my answer what I want
to get ?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Looking for all of the documents, I still can't find the
information about how to access databases with exec_msg function.</FONT></DIV>
<DIV><FONT size=2>Hoping someone can give me some advises ^^.</FONT></DIV>
<DIV><FONT size=2>Thannks in advance.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Lee</FONT></DIV></BODY></HTML>