RSS, Web Services and...

Float truncated

Please support our RSS, Web Services and SOAP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2009

Posts: 1

Reputation: keizersoz is an unknown quantity at this point

Solved Threads: 0

keizersoz

Offline

Newbie Poster

Float truncated

Jul 7th, 2009

Hello all, In my WSDL I defined a float

 Help with Code Tags 
 RSS, Web Services and SOAP Syntax (Toggle Plain Text) 
<xsd:complexType name="M01_rowType">
<xsd:sequence>
<xsd:element name="helpdTTSAvg" type="xsd:float"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="M01_tableType">
<xsd:sequence>
<xsd:element name="helpdTTSVal" minOccurs="0" maxOccurs="unbounded" type="tns:M01_rowType"/>
				</xsd:sequence>
<xsd:complexType name="M01_rowType">
<xsd:sequence>
<xsd:element name="helpdTTSAvg" type="xsd:float"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="M01_tableType">
<xsd:sequence>
<xsd:element name="helpdTTSVal" minOccurs="0" maxOccurs="unbounded" type="tns:M01_rowType"/>
				</xsd:sequence>

I can also see from PHP that I received float values, however SOAP truncates the float to integer, whereas for instance 3.06 is trucated to 3. Does someone has any idea how this can happen?

my php is defined as follows

Help with Code Tags

RSS, Web Services and SOAP Syntax (Toggle Plain Text)

   $strQuery="SELECT \n".
       "ROUND(AVG(CalculateDateDiffHD(C.CALL_DATE, C.DATE_CLOSED)/60),2) AS TTS_TT \n".
                "FROM \n".
               "CALLS C \n".
               "WHERE \n".
              "TO_CHAR(C.CALL_DATE,'YYYY-MM')= TO_CHAR(CURRENT_DATE,'YYYY-MM') \n";
 
 
        $stmt = OCIParse($db, $strQuery);
        OCIExecute($stmt);
 
        $helpdTTS=new stdClass;
        $helpdTTS->helpdTTSList=array();
        $index=0;
 
        while (ocifetchinto($stmt, $arrResult, OCI_ASSOC)) { // meaning returns associative array,         removed null values, function depprecated
          $helpdTTSVal=new stdClass;
          $helpdTTSVal->helpdTTSAvg=$arrResult["TTS_TT"]*1;
          $helpdTTS->helpdTTSList["helpdTTSVal"][$index]=$helpdTTSVal;
        }
 
        return $helpdTTS;