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