Hi Neil, I handle your problem like this in my MySQL queries: SELECT CONV(MONTH(Birthday), 10, 10) AS BirthMonth ...yaddayaddayadda The CONV function "Returns a string representation of the number N, converted from base from_base to base to_base." So in my case, MONTH was returning a Long data type which was displaying the 'L' in my query results. I use CONV to convert the Long in base 10 to a *String* representation of the number in base ten. It's kind of a lame fix, but it works! There's a really cool searchable help system for MySQL at: http://www.mysql.com/php/manual.php3 Hope that helps! Eric.
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Neil Blue Sent: Sunday, May 13, 2001 2:44 PM To: zope@zope.org Subject: [Zope] Trailing 'L' after number values
Hello,
I am getting integer numbers from mysql with a select clause. The values are stored as int types, however when I retrieve them via a Z SQL method and show them on a page, they display with a trailing 'L'.
e.g.
12L
instead of
12
Does anyone know why this happens. It also occurs when I test an sql statement. However it has only recently started to do this and I am not sure why.
Thanks Neil Blue
_______________________________________________ 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 )