[Zope] problem selecting integers from mysql

[sean.upton@uniontrib.com]

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

Sean

-----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


Hi,

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

-Kevin

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

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