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.