On Friday, July 24, 2015 at 1:52:25 PM UTC-7, Rahul Nahata wrote:
>
> I am trying to create an online directory which requires me to display a 
> persons details from a modified auth_user table in a seperate page ( with 
> id as an argument to the page). 
>
> I am facing problems while formatting the display of the sql record with 
> help of BEAUTIFY function applied to the row. As in the Field names are 
> displayed as first_name, addressl1, contactnum, etc. whilst I want them to 
> be First Name, Address Line 1, Contact Number, etc. Also I do have a column 
> for profile picture that I would like to display in a box format.
>
> Any solutions to customize the formatting of display of the SQL Record? 
> Please help!
>

I think of BEAUTIFY as a debug tool, although perhaps I underestimate it.

You can make a table with html (and html helpers) for complete control over 
each field, or you can use something like

{{=SQLTABLE(records, truncate=45, headers={'mytable.id':"My Event ID", // 
other fields here //} ) }}

(I think BEAUTIFY ends up as a table, it just has defaults that may not be 
useful for user-facing code)

/dps

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to