I set the datatype
of the re Value in the wsdl
file to be of xsd:anyType
:
<message name="getEtapeProspResponse">
<part name="return" type="xsd:anyType"/>
</message>
<代码>PHP功能,webservice
• 从MySQL表格中选列的栏目中填入的“缝.”。 其中一个栏目有<条码>数据类型条码><>>。
function getEtapeProsp($user,$motpasse)
{
$user_code = verifyUser($user, $motpasse) ;
$resultat="";
if ( $user_code != null)
{
$datejour = date("Y-m-d");
$connec = mysql_connect("192.168.1.123:3306", "root", "mysqlroot");
mysql_select_db("finance",$connec);
$query = mysql_query("SELECT * FROM etape_prospection INNER JOIN type_prospection ON etape_prospection.type_prosp_id = type_prospection.type_prosp_id WHERE prosp_id IN (SELECT prosp_id FROM transfert WHERE user_code = ".$user_code ." AND date_transfert= ".$datejour." ) order by etape_prospection.prosp_id");
while($ligne = mysql_fetch_array($query))
{
$resultat .= $ligne[ etape_prosp_id ]. ; ;
$resultat .= $ligne[ type_prosp_lib ]. ; ;
$resultat .= convertDateFormatHH($ligne[ etape_prosp_date ]). ; ;
$resultat .= $ligne[ etape_prosp_comment ]. ; ; // this is the text column
$resultat .= $ligne[ prosp_id ]. ; ;
$resultat .= "
";
}
}
else
{
$resultat = "Login ou mot de passe incorrect" ;
}
return $resultat;
}
In the database the value of the "etape_prosp_comment" has an accentuated letter , é.
The problem is that when I call the webservice from my J2ME
application then an exception is thrown. But if I don t insert any accentuated letters in the column
then the webservice is ok.
因此,如何解决这一突出的字母问题?