<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=NO-BOK style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman; mso-ansi-language: NO-BOK">Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=NO-BOK style="mso-ansi-language: NO-BOK"><o:p><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman"> </SPAN></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">I have got a problem:<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><o:p><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman"> </SPAN></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Times New Roman">accessing an Oracle 10g database, whenever I ask for floats from a Zope Z SQL method, they are automatically converted to integers, simply dropping the decimal numbers.<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="COLOR: black"><o:p><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman"> </SPAN></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Times New Roman">I am using Zope 2.10.4-final with Python 2.4.4 running on a Linux2 OS. Furthermore, I am using UnixODBC with Easysoft’s ODBC-Oracle driver together with eGenix <STRONG><SPAN style="FONT-WEIGHT: normal; mso-bidi-font-weight: bold">mxODBC Zope DA</SPAN></STRONG>. <o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="COLOR: black"><o:p><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman"> </SPAN></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Times New Roman">Running iSQL on the server or even utilizing the mxODBC Zope DA driver directly in Python works well without problems. <SPAN style="mso-spacerun: yes"> </SPAN><o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="COLOR: black"><o:p><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman"> </SPAN></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Times New Roman">The error logs for the ODBC contained no sign or errors. Neither did I get any response when I ran Event Log Manager in Zope. I could not find anything in syslog. <o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="COLOR: black"><o:p><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman"> </SPAN></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Times New Roman">Any clues on how to solve this?<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="COLOR: black"><o:p><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman"> </SPAN></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Times New Roman">-su</SPAN></P><BR><p>
-------------------------------------------------------------------------<br>
Få din egen, gratis e-postadresse på <a href="http://www.start.no/">Start.no</a>
</p>