[web2py] Re: Weird problems generating menu from database

2017-07-29 Thread Вячеслав Анатольевич
Hi! Paraphrase the question, can anyone explain how to create a drop-down menu from a database table or show a working example? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Weird problems generating menu from database

2017-07-30 Thread Вячеслав Анатольевич
Thanks for the answer, Massimo! But this example makes the menu items in one line with one drop-down menu item. Like this: Menuitem Menuitem - submenuitem- submenuitem I have three fields, they must be somthing like this (anothermenu - just for example - to

[web2py] Re: Weird problems generating menu from database

2017-08-01 Thread Вячеслав Анатольевич
> > I'm using bootstrap css/js form wellcom app, about stupid.css - now > reading, but it's a little different, > I need to build a menu from the database table (three fields), as in the > example above. > Somthing like this: topmenu |menu |-sibmenu | |- submenu > > -- Resources: -

[web2py] Re: Weird problems generating menu from database

2017-08-02 Thread Вячеслав Анатольевич
Have some idea about 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 Google Groups

[web2py] Re: Weird problems generating menu from database

2017-08-02 Thread Вячеслав Анатольевич
> > Me personally, no, but I understand BS3 limits the number of menu levels. > > /dps > > So, it is inpossible or not? I'm ask because it's hard to puzzle over this or it's really impossible? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Weird problems generating menu from database

2017-08-16 Thread Вячеслав Анатольевич
Thank you so much, Massimo! That's what I need! -- 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

[web2py] Re: Weird problems generating menu from database

2017-08-14 Thread Вячеслав Анатольевич
Hi! in that example - i have error: subsubmenu = [[key, None, link] for key, link in items] ValueError: too many values to unpack -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: After update can't connect Oracle

2017-07-18 Thread Вячеслав Анатольевич
But now i have another error: File ".bububu.web2py\gluon\packages\dal\pydal\adapters\oracle.py", line 71, in create_sequence_and_triggers 'MINVALUE -1;' % sequence_name) TypeError: not all arguments converted during string formatting -- Resources: - http://web2py.com -

[web2py] Re: After update can't connect Oracle

2017-07-18 Thread Вячеслав Анатольевич
Grandiose mersi! -- 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] After update can't connect Oracle

2017-07-18 Thread Вячеслав Анатольевич
HI! Can anyone explain why after updating web2py to version 2.15.1 I started to get errors when connecting to Oracle? For example, this: AttributeError: 'Oracle' object has no attribute 'oracle_fix' -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Weird problems generating menu from database

2017-07-27 Thread Вячеслав Анатольевич
> db.define_table('store_catalog', >> Field('title'), >> Field('slug',requires=IS_SLUG(),compute=lambda row: >> IS_SLUG.urlify(row.titl\ >> e)), >> Field('parent_id','reference store_catalog')) >> >> id1 = db.store_catalog.insert(title='main') >> id2 =

[web2py] Re: After update can't connect Oracle

2017-07-25 Thread Вячеслав Анатольевич
Hi, another error in oracle (can't create auth_ tables): not all arguments converted during string formatting File "D:\Web\server\web2py\gluon\packages\dal\pydal\adapters\oracle.py", line 70, in create_sequence_and_triggers 'MINVALUE -1;' % sequence_name) TypeError: not all arguments

[web2py] Re: After update can't connect Oracle

2017-07-19 Thread Вячеслав Анатольевич
In web2py 2.15.2 - error not fixed... I fixed myself but: File "D:\Web\server\web2py\gluon\packages\dal\pydal\adapters\oracle.py", line 40, in execute m = self.cmd_fix.match(command) AttributeError: 'Oracle' object has no

[web2py] Re: Weird problems generating menu from database

2017-08-06 Thread Вячеслав Анатольевич
Thanks, Massimo! So, i have a database table - named "map", in that table - three field - menu1, menu2, mnm_name. Menu mast be like that: - menu1 - menu2 -mnm_name In menu1 - menu2, in menu2 - mnm_name -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: Weird problems generating menu from database

2017-08-01 Thread Вячеслав Анатольевич
I understood what was the matter, it was styling! But, how to add the third field: if auth.is_logged_in(): rows = db(db.map).select(db.map.menu1, db.map.menu2, db.map.mnm_name, orderby=db.map.num, distinct=True) from collections import defaultdict d = defaultdict(list) for row in rows:

[web2py] Re: Weird problems generating menu from database

2017-07-31 Thread Вячеслав Анатольевич
Hi, Dave S, maybe you right! But How to create in submenuitem - submenuitem? > > > -- 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

[web2py] Re: Weird problems generating menu from database

2017-08-07 Thread Вячеслав Анатольевич
> > In Wiki menus: > - Home > @index - Info > @info - web2py > http://www.web2py.com - - About us > @aboutus - - - Contact us > @contactus - If I add a third minus - THIS NOT WORKED! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Cyrillic encoding no working

2017-08-19 Thread Вячеслав Анатольевич
Hi everyone! What happened to the Cyrillic after the update of pydal or web2py (maybe, before everything worked fine)? Whichever I choose the encoding of the Oracle database itself (utf8, cp1251, .) - I get "???". In db = DAL (, db_codec = '...') tried everything that could - the

[web2py] cx_Oracle 6.0

2017-08-18 Thread Вячеслав Анатольевич
Hi everyone! Actually the question on the topic! Do you need changes to pydal or we2py due to the release of cx_Oracle 6.0? Release web2py 2.15.3 took place a week earlier than cx_Oracle 6.0. I ask - because it creates parallel tables with already existing only with a small (or large) letter,

[web2py] Re: cx_Oracle 6.0

2017-08-18 Thread Вячеслав Анатольевич
Thanks, Leonel! It works! -- 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] Login(auth) from Oracle db

2017-06-01 Thread Вячеслав Анатольевич
Hi! Can anybody help me? I am only starting on web2py. So, i have db oracle with alredy having data, and i want to make login only, without reg/change pass and other. I have a table in db for example, user_psw, where i have "name" and "pwd" - (username & password). How i can tell web2py watch

[web2py] How I can disable user_group, membership, permission, events?

2017-06-14 Thread Вячеслав Анатольевич
So, I have db/table where i have data, i want just login user by the my field/data: def user(): auth = Auth(db, signature=False) auth.settings.create_user_groups = False db.define_table('user_psw', Field

[web2py] Re: How I can disable user_group, membership, permission, events?

2017-06-15 Thread Вячеслав Анатольевич
Thx, i understand, that its all must be in model - im testing) So, how i must write, that web2py understand "tabnum" like "id"? In book i found: db.mytable.other_id.represent = lambda id, row: row.myfield and primarykey=['accnum','acctype'] im trying, but still error. -- Resources: -