Thanks a lot !!! The query I am doing is: select MAX(CliCodigo) from ClientesTabla And the column that is returned by zope is named 'Expr1000' (a bit strange :-)), and doing: I=int(container.last_customer()[0].Expr1000) Works !!! Thank you, I was becoming fool :-) On Fri, 2 Nov 2001, Casey Duncan wrote:
On Friday 02 November 2001 11:21 am, Julián Muñoz Domínguez allegedly wrote:
How to convert to integer the the result of a ZSLQ method ??
I call a ZSQL method with: l=int(container.last_customer())
The field I query is has the type "VARCHAR(10) with Null" I am doing this query through ZODBC DA, to an Access .mdb file.
I am digging many hours in the Documentation, and doesn't find the answer.
I get this error:
Zope Error
Zope has encountered an error while publishing this resource.
Error Type: AttributeError Error Value: DatabaseResults instance has no attribute '__int__'
It sounds like you are trying to convert the whole row or recordset to an int, which obviously won't work. You need to return just the field by itself like:
I=int(container.last_customer().name_of_field)
or possibly:
I=int(container.last_customer()[0].name_of_field)
hth, /---------------------------------------------------\ Casey Duncan, Sr. Web Developer National Legal Aid and Defender Association c.duncan@nlada.org \---------------------------------------------------/
-- __o _ \<_ (_)/(_) Saludos de Julián EA4ACL -.-