[Zope] problem selecting integers from mysql

sean.upton@uniontrib.com sean.upton@uniontrib.com
Fri, 11 May 2001 10:18:14 -0700

put int() around your results; it will convert a longint to an integer.


-----Original Message-----
From: Kevin L [mailto:kevinsl@yahoo.com]
Sent: Friday, May 11, 2001 10:02 AM
To: zope@zope.org
Subject: [Zope] problem selecting integers from mysql


I have a Z SQL Method and one of the columns it selects is of
type "int(11) unsigned". But when I test the query I get the
number plus an "L" appended to the end. For example I get 1L,
32L, 6533L. I assume the L means longint but does anyone know
how to get rid of it?

thanks much


Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices

Zope maillist  -  Zope@zope.org
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-dev )