Re: [web2py] CUSTOMIZING WEB2PY FORMS

2018-09-24 Thread elisha bere
i am not understanding it On Fri, 7 Sep 2018 at 20:07, Javier Pepe wrote: > In docs you have example. > > > http://web2py.com/books/default/chapter/29/07/forms-and-validators#Custom-forms > > El vie., 7 de sep. de 2018 a la(s) 07:02, elisha bere ( > elishabe...@gmail.com) escribió: > >> Hie guys

Re: [web2py] Re: Customising my views

2018-09-24 Thread elisha bere
ok let me try that On Mon, 24 Sep 2018 at 18:44, Leonel Câmara wrote: > Don't use relative paths for inline styles. Use something like this > > > > That way web2py will put the absolute url to the file there and it will > work. > > -- > Resources: > - http://web2py.com > - http://web2py.com/boo

[web2py] what is '\x00'

2018-09-24 Thread mostwanted
I opened my App this morning to work on it & i got this error * '\x00' *, can anyone please assist? What does it mean??? When i went to sleep everything was ok. Regards Mostwanted -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Sou

Re: [web2py] Re: DAL with multiple foreign keyes

2018-09-24 Thread Ben Duncan
Ok, thanks .. will think of another way to do this .. On Mon, Sep 24, 2018 at 4:58 PM Leonel Câmara wrote: > Nope the DAL and web2py does not support this. > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - h

[web2py] Re: DAL with multiple foreign keyes

2018-09-24 Thread Leonel Câmara
Nope the DAL and web2py does not support this. -- 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

Re: [web2py] Re: DAL with multiple foreign keyes

2018-09-24 Thread Ben Duncan
It's more about optimization of underlying key structure and the btree access. Having the Primary key "company + customer" are faster because the optimizer can have a start point. I could do secondary key with COMPANY , but then the optimizer has to go thru a different set of routines. In this sys

[web2py] Re: DAL with multiple foreign keyes

2018-09-24 Thread Leonel Câmara
I don't get it. Why would you want the company number in the foreign key even if this is a multi tenant database? The reference to customers should just be to customers and not company + customers number. Then you put a common filter in the customers table so only the customers from the logged

[web2py] DAL with multiple foreign keyes

2018-09-24 Thread Ben Duncan
Ok, to expand my original thread:: items_purchased has a "company number", since this is a multi tenant database, that reflects what company this is part of (or division ...etc) The company number is used to define the foreign key in this table to other tables: example: fk to customers = " comp

[web2py] Re: Customising my views

2018-09-24 Thread Leonel Câmara
Don't use relative paths for inline styles. Use something like this That way web2py will put the absolute url to the file there and it will work. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.co

[web2py] DAL and Foreign Keyes

2018-09-24 Thread Ben Duncan
will DAL allow multiple foreign keys on a legacy database table? i.e. : Table called item_purchased needs to have a FK to customer table as well as item table and even possibly GL COA table Thanks ... Ben Duncan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: How do i get the details of a user in db.auth_user displayed by referencing it in my db?

2018-09-24 Thread Leonel Câmara
Note that: if auth.user: db.Customer.Booked_By.default = auth.user.id Should come before: form=SQLFORM(db.Customer) The error you're getting: * 'NoneType' object has no attribute 'first_name'* Means Booked_By is None/NULL and not a reference to auth_user. probably because of

[web2py] Submitting fixes

2018-09-24 Thread Anthony
You can make a pull request on Github. See http://web2py.com/books/default/chapter/29/15/helping-web2py#Contributing-code-and-documentation-changes. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.co

[web2py] Submitting fixes

2018-09-24 Thread Ben Duncan
I've found some errors in extract_pgsql_models.py and have fixed them. How to do I go about submitting the updated program for inclusion repos (asking for etiquette sake )? I'm not quite thru with the update yet, since I need to fix it to handle FK's with multiple key parts. Thanks Ben Duncan