[Zope] Trailing 'L' after number values

[Eric Walstad]

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 )