Anthony, I reply to you also privately to say many thanks for your support on the web2py-users group.
I give you my references and if you are on LinkedIn I very appreciate if you join my professional networks. Best Regards. Valter Foresto -------------------------------------------------------------------------------- http://www.electronicbricks.it Reti Ottiche a Larga Banda in Fibra Ottica Plastica "Red Light for Green Broadband Optical Networks" Consulting, Training, Design, Marketing and Sales Comm.SEC di Valter Foresto - ElectronicBRICKS™ Operation: Strada della Pronda 66/8bis - 10142 Torino - Italy (floor 1°, office 3) Email: valter.fore...@electronicbricks.it Skype: comm.sec Mobile: +39 347 0144028 LinkedIN: commsec Twitter: valterforesto Legal: Via Francesco Millio 57 – 10141 Torino - Italy IVA/VAT: IT08775700019 ----- Original Message ----- From: Anthony To: web2py@googlegroups.com Sent: Friday, July 08, 2011 12:00 AM Subject: [web2py] Re: How to display 'complete strings' in a view table ? Rows objects are rendered via the SQLTABLE helper (see http://code.google.com/p/web2py/source/browse/gluon/sqlhtml.py#1229). It takes a 'truncate' argument that defaults to 16 (i.e., it truncates text at 16 characters). Try: {{=SQLTABLE(records, truncate=xx)}} where xx is 19 or greater in your case (to accommodate a date-time string). I think you can also set truncate=None to avoid truncation altogether. Anthony On Thursday, July 7, 2011 5:39:36 PM UTC-4, Valter Foresto wrote: I use the view : {{extend 'layout.html'}} {{=records}} to display a records table. One field in the record report the date and time : logs.event_time_stamp 2011-07-07 23... but the date and time is "2011-07-07 23..." instead of the complete "2011-07-07 23:01:15" string. What can I do to have the complete string displayed on the view table ?