thank you so much for your hint, anthony both of it is work well.

{{extend 'layout.html'}}

{{for i, row in enumerate(rows):}}
{{=DIV(', '.join(row.test))}}
{{=DIV(db.test.test.represent(row.test))}}
{{pass}}

On Wednesday, April 17, 2013 10:33:13 AM UTC+7, Anthony wrote:
>
> In the database, the value is stored as a string with the individual 
> values separated by pipe characters (i.e., "|a|b|"). However, when you 
> select from the DB using the DAL, the value gets converted to a list. 
> list:string fields get a default "represent" attribute that displays the 
> values as a comma-separated list in grids, etc., but you have to do it 
> yourself or explicitly call the "represent" function in other contexts:
>
> DIV(', '.join(row.test))
>
> or
>
> DIV(db.test.test.represent(row.test))
>
> Anthony
>
> On Tuesday, April 16, 2013 10:37:20 PM UTC-4, 黄祥 wrote:
>>
>> hi folks,
>>
>> is it possible to change list:string type field output format?
>>
>> e.g.
>> *in grid output : a, b*
>> *in shell output :  |a|b|*
>> >>> print db(db.test.test.contains('b')).select()
>> test.id,test.test
>> 1,|a|b|
>> *in view using query output : ab*
>> {{for i, row in enumerate(rows):}}
>>     {{=DIV(row.test)}}
>> {{pass}}
>> *in view using query output : ['a', 'b']*
>> {{for i, row in enumerate(rows):}}
>>     {{=DIV(str(row.test))}}
>> {{pass}}
>>
>> i want to have the output format for list:string type field in view : *a, 
>> b* or *a; b* instead of ab. did anyone know how to produce the output 
>> like that in web2py?
>>
>> thank you very much in advance
>>
>

-- 

--- 
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/groups/opt_out.


Reply via email to