[web2py] Re: How to display reference field in sqltable?

2012-03-09 Thread Edward Shave
Many, many thanks for that. I ran your fix and now all is present and correct. Thanks again, Ed On Friday, 9 March 2012 07:01:25 UTC, nick name wrote: On Thursday, March 8, 2012 8:52:34 PM UTC-5, Edward Shave wrote: Many thanks for reply, unfortunately it didn't work in this instance... I

[web2py] Re: How to display reference field in sqltable?

2012-03-08 Thread Alan Etkin
This should tell web2py to display the name instead of the id in references db.define_table('account', ..., format='%(name)s') You can find more info in the book's chapter 6.5, Record representation On 7 mar, 20:52, Edward Shave ed.sh...@eshavefindings.co.uk wrote: *I have the following table

[web2py] Re: How to display reference field in sqltable?

2012-03-08 Thread Edward Shave
Many thanks for reply, unfortunately it didn't work in this instance... I wonder if it is because the table is referencing itself? Anyway I have found the following works but I wonder about the efficiency? *db.account.transfer_acc.represent= lambda value:db.account[value].name* On Thursday, 8

[web2py] Re: How to display reference field in sqltable?

2012-03-08 Thread Anthony
On Thursday, March 8, 2012 8:52:34 PM UTC-5, Edward Shave wrote: Many thanks for reply, unfortunately it didn't work in this instance... I wonder if it is because the table is referencing itself? Anyway I have found the following works but I wonder about the efficiency?

[web2py] Re: How to display reference field in sqltable?

2012-03-08 Thread nick name
On Thursday, March 8, 2012 8:52:34 PM UTC-5, Edward Shave wrote: Many thanks for reply, unfortunately it didn't work in this instance... I wonder if it is because the table is referencing itself? By coincidence, I noticed the same problem earlier myself and opened ticket #700