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 )