Sorry, try:
db.PartyPhoneNumberIntersection.countryTelephoneCode.represent = \
lambda id, r: '%(countryTelephoneCode)s %(countryName)s' % db.Country(id
)
Anthony
On Wednesday, April 24, 2013 1:18:51 PM UTC-4, Alex Glaros wrote:
>
> Anthony, doesn't there have to be some sort of pointer to the correct
> reference record in the lookup table?
>
> Here is a real example below (different fields and table than first
> example).
>
> I tried to put "db.Country" in front of the lookup table field names in
> the "represent" clause, but the syntax is wrong. Now that you can see the
> lookup table, could you please write out the complete syntax?
>
> db.define_table('Country', ## Lookup table
> Field('countryName','string'),
> Field('countryCode','string'),
> Field('countryTelephoneCode','integer'))
> ##
> ----------------------------------------------------------------------------------
> db.define_table('PhoneNumber',
> Field('countryTelephoneCode','reference Country'),
> Field('telephoneNumber','integer'))
> ## ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> db.PhoneNumber.countryTelephoneCode.represent = lambda v, r:
> '%(db.Country.countryTelephoneCode)s
> %(db.Country.countryName)s' % r
>
> Thanks,
>
> Alex
>
>
> On Wednesday, April 24, 2013 5:00:00 AM UTC-7, Anthony wrote:
>>
>> db.PartyPhoneNumberIntersection.countryTelephoneCode.represent = \
>> lambda v, r: '%(countryTelephoneCode)s %(countryName)s' % r
>>
>> Anthony
>>
>> On Wednesday, April 24, 2013 4:08:25 AM UTC-4, Alex Glaros wrote:
>>>
>>> Is there a way to concatenate fields in the represent function in the
>>> same way that countryTelephoneCode and countryName are in the "requires"
>>> validator below?
>>>
>>> db.PartyPhoneNumberIntersection.countryTelephoneCode.requires = IS_IN_DB
>>> (db, db.Country.countryTelephoneCode, '%(countryTelephoneCode)s %(
>>> countryName)s',zero=T('choose one'))
>>>
>>> thanks,
>>>
>>> Alex Glaros
>>>
>>
--
---
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.
