[Zope] MYSQL Problem
Jens Grewen
zope@grewen.de
Sun, 28 Jan 2001 05:35:46 +0100
This is a multi-part message in MIME format.
------=_NextPart_000_0039_01C088EC.2A513B80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I installed=20
mySQL-3.23.32
mySQLdb 0.3.1
ZmySQLDA 2.0.4
on Win98
From the following SQL statment I get the result 233L and not 233 as =
expected
select count(PID)
from product
When I run this SQL Statment from another program I get the expected =
value 233.
In my installation there are a lot of Z SQL Methods that should return =
an int value and when I use field description int in the database I =
always get this 'L' behind the expected result. A lot of things don=B4t =
work because of this.
When I change to mediumint (database field description) I get the =
expected 233.
How can I fix this.
Thanks
Jens
------=_NextPart_000_0039_01C088EC.2A513B80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I installed </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>mySQL-3.23.32</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>mySQLdb 0.3.1</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ZmySQLDA 2.0.4</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>on Win98</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>From the following SQL statment I =
get the=20
result 233L and not 233 as expected</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>select count(PID)<BR>from =
product</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>When I run this SQL Statment from =
another program I=20
get the expected value 233.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>In my installation there are a lot of Z =
SQL Methods=20
that should return an int value and when I use field description int in =
the=20
database I always get this 'L' behind the expected result. A lot of =
things=20
don=B4t work because of this.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>When I change to mediumint (database =
field=20
description) I get the expected 233.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>How can I fix this.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Jens</FONT></DIV></BODY></HTML>
------=_NextPart_000_0039_01C088EC.2A513B80--