[Zope] Z SQL Method returns diferent data in ID field

[Hugo Ramos]

Yellow,

I'm using a mysql database and Zope MySQL Database Adapter 1.1.4

I've build a Z SQL Method with the following select:

bla bla
Arguments: artigos.id artigos.autor artigos.email artigos.titulo
artigos.topico artigos.dep artigos.sumario artigos.corpo artigos.attachment
artigos.data artigos.data2

Query template: select * from artigos
<dtml-sqlgroup where>
   <dtml-sqltest artigos.id type=int optional>
   <dtml-sqltest artigos.autor type=nb optional>
   <dtml-sqltest artigos.email type=nb optional>
   <dtml-sqltest artigos.titulo type=nb optional>
   <dtml-sqltest artigos.topico type=nb optional>
   <dtml-sqltest artigos.dep type=nb optional>
   <dtml-sqltest artigos.sumario type=nb optional>
   <dtml-sqltest artigos.corpo type=nb optional>
   <dtml-sqltest artigos.attachment type=float optional>
   <dtml-sqltest artigos.data type=nb optional>
   <dtml-sqltest artigos.data2 type=nb optional>
</dtml-sqlgroup

Everything works fine but i get an 'id' field with '1L' instead of '1'

anyone had the same problem???

thanks

---
Hugo Ramos - hramos@ruido-visual.pt
Ruido Visual, Lda