Can you give me more details? I'm not sure if directly call it from view or
controller. I apprecite if you can provide a sample code with the
following. db.KR_Product.UnitPrice.represent = lambda value, row: '$ %.2f'
% (0.0 if value == None else value)
On Mon, Jan 26, 2015 at 4:56 PM, Niphlod <niph...@gmail.com> wrote:
> if you're not using web2py's facilities (SQLTABLE, grid, rows.render(),
> etc), you have to call represent directly
>
> {{=db.KR_Product.UnitPrice.represent(list.UnitPrice)}}
>
>
>
> On Monday, January 26, 2015 at 11:39:07 PM UTC+1, Omi Chiba wrote:
>>
>> I want to show the UnitPrice like $1,000,00 but it shows 1000.00.
>>
>> *Model*
>>
>> db.define_table('KR_Product',
>> Field('ProductCode', length=15),
>> Field('PartNumber', length=50),
>> Field('SubA', length=15),
>> Field('SubB', length=15),
>> Field('UnitPrice', 'decimal(18,2)'),
>> Field('Quantity', 'decimal(18,0)'),
>> Field('Weight', 'decimal(18,3)'),
>> Field('LeadTime', length=50),
>> Field('Model', length=2),
>> Field('Lead', length=2),
>> Field('Block', length=1),
>> Field('Stroke', length=4),
>> Field('Grade', length=1),
>> Field('Cover', length=1),
>> Field('Sensor', length=1),
>> Field('Housing', length=1),
>> Field('Flange', length=1),
>> Field('Description', length=500)
>> )
>>
>> db.KR_Product.UnitPrice.represent = lambda value, row: '$ %.2f' % (0.0
>> if value == None else value)
>>
>>
>> *View*
>>
>> <div id="container">
>> <div id="wrapper">
>> <table class="table table-hover">
>> <thead>
>> <th>Part Number</th>
>> <th>Lead Time</th>
>> <th style="text-align: right;"><span
>> class='right'>Quantity</th>
>> <th style="text-align: right;"><span class='right'>Unit
>> Price($)</th>
>> <th style="text-align: right;"><span
>> class='right'>Weight(kg)</th>
>> </thead>
>> <tbody>
>> {{for list in lists:}}
>> <tr>
>> <td>{{=list.PartNumber}}</td>
>> <td>{{=list.LeadTime}}</td>
>> <td style="text-align: right;">{{=list.Quantity}}</td>
>> <td style="text-align: right;">{{=list.UnitPrice}}</td>
>> <td style="text-align: right;">{{=list.Weight}}</td>
>> </tr>
>> {{pass}}
>> </tbody>
>> </table>
>> </div>
>> </div>
>>
> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/bJHpQE5O74g/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
