PyCon was great! I will post some more info soon. Massimo
On Mar 29, 5:44 pm, TheDude <[email protected]> wrote: > Worked like a charm thanks. :) Also taught me a few things heh ;) Btw, > how was PyCon? > > On Mar 29, 5:25 pm, mdipierro <[email protected]> wrote: > > > You can use > > > class NameValidator: > > def __init__(self,error_message='not in db'): > > self.error_message=error_message > > def __call__(self,name): > > users=db(db.users.name==name).select() > > if not users: return (name, self.error_message) > > return (users[0].id,None) > > def format(self,id) > > return db.users[id].name > > > db.mailbox.account_id.requires=NameValidator() > > > In the page you may also need this: > > <script> > > $(document).ready(function() { $('#mailbox_account_id').attr > > ('class','string'); }); > > </script> > > > Hope it makes sense. > > > Massimo > > > On Mar 29, 2:19 pm, TheDude <[email protected]> wrote: > > > > Here's the code:http://pastie.org/private/wmow1xkoaov5ium6cgf8w > > > > Here's the problem: > > > ok now a new problem let's say im building a mailbox application (not > > > like email like a private messaging system) and int he table mailbox I > > > have account_id (which account its tied to) > > > On the SQLFORM it shows Account ID: <input> (which i changed to > > > Player:) but I want the Player: field to actually be tied to > > > accounts.name rather than mailbox.account_id > > > and then use my own function called lookup_name() that returns the ID > > > of the account's name > > > would it be best practice to do theid = lookup_name > > > (request.post.account_id) db.mailbox.account_id.default = theid ? > > > > Is there some kind of way to make it so SQLFORMS will do this > > > automatically? I don't want that drop down box solution because when I > > > have 100,000 user entries that would take a long time to load. :) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
