[web2py] Re: the ajax callback action return a list [URGENT]

Hey paco, the problem is that i am using script, so the the action in the controller is a callback, it means that it dont have his html page. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/we

[web2py] grid add/edit form label

The grid object accepts headers but is only for the grid. Now how to set the labels of the fields in grid add/edit forms. Thanks in advance. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2

[web2py] Re: grid edit

Yes Anthony, with this the grid edit is OK. [setattr(f, 'writable', False) for f in db. amc_master if f.name not in ['id', 'amcdesc', 'amcmod', 'complndays']] But how come it worked fine with postgresql without the id field setting? Anyway thanks a lot for resolving the issue. -- Resources: -

[web2py] Re: SQLFORM.grid - trying to limit search filter to queried items not entire table items

Thanks again Anthony, To be honest that's a bit beyond my abilities at the moment though plenty of food for thought! I think I have a work around... essentially by doing the person search before building the list for the grid. i.e I can identify the person first and add person.id it to the qu

[web2py] Re: web2py support

On Wednesday, May 31, 2017 at 2:04:26 PM UTC-7, icodk wrote: > > Thanks T.R.Rajkumar > > Sorry for the noise. Using chronological view, I didn't correctly associate your post with what you were following up on., /dps On Wednesday, May 31, 2017 at 11:57:09 AM UTC+2, T.R.Rajkumar wrote: >> >>

[web2py] Re: SQLFORM.grid change form vars

Antony could you elaborate or give an example of how to use formargs,editargs etc. ? You write that it can be used by passing it to SQLFORM but what could be the actual use of it? In another post https://groups.google.com/forum/#!searchin/web2py/formargs$20field$20order%7Csort:relevance/web2py/c

Re: [web2py] Migration fails when dropping a column on Postgresql

Hi Richard - Thanks for response. I am running web2py version: Version 2.14.6-stable+timestamp.2016.05.10.00.21.47 I'm using rname because postgresql doesn't like case sensitive table and field names much, and neither do my colleagues, but I like CamelCase in my code, so as you say, for code re

[web2py] Re: Migration fails when dropping a column on Postgresql

Will do - thanks Anthony On Wednesday, May 31, 2017 at 9:34:48 PM UTC+2, Anthony wrote: > > Probably the code for dropping columns was never updated to handle rnames. > Please submit an issue in the pydal repo: > https://github.com/web2py/pydal/issues. > > Anthony > > On Wednesday, May 31, 2017

[web2py] postgres 8, psycopg2, text datatype limit of 32k.

any idea why I would get a "Enter from 0 to 32768 characters" when I try to submit a standard 'text' datatype from SQLFORM from a standard db.define_table under db.py with psycopg2 as the driver and Postgres 8 as the backend on a cantos 6.7 box. the text limits on Postgres are 1GB. so what wo

[web2py] Re: Future of web2py

weppy the web framework for humans sounds good ? frigolux the refrigerator for polar bears -- 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 receive

[web2py] Re: Error while running web2py.py

I would also recommend checking your python version it really should be 2.7.something and the Tk error suggests it is probably python 3 which will definitely not be a productive experience with web2py 2.0.8 it can be experimented with the latest trunk version but anything less will probably be

[web2py] Re: web2py support

Thanks T.R.Rajkumar On Wednesday, May 31, 2017 at 11:57:09 AM UTC+2, T.R.Rajkumar wrote: > > Could be interesting to hear what are the arguments for the porting > > The points are > 1. The application business logic has changed and the workflow has also > changed. So I have to do the app fresh.

[web2py] Re: Error while running web2py.py

On Wednesday, May 31, 2017 at 8:48:16 AM UTC-7, Razor brahman wrote: > > getting this error..Help please > > *student@student-HP:~/web2py$* > > > > > > > > > > > > > * python web2py.py -i 0.0.0.0web2py Web FrameworkCreated by Massimo Di > Pierro, Copyright 2007-2017Version 2.0.8 (2012-09-07 03:4

[web2py] Re: smartgrid

sorry we have to let linked_tables Sorry and thank you Le mercredi 31 mai 2017 21:21:23 UTC+2, LC LC a écrit : > > Thank you very much > but i have new problem it shows on right the links Auth memberships Auth > events Auth cases ... > > and i'd like to select and not show all the linked ta

[web2py] Re: smartgrid

On Wednesday, May 31, 2017 at 3:21:23 PM UTC-4, LC LC wrote: > > Thank you very much > but i have new problem it shows on right the links Auth memberships Auth > events Auth cases ... > You need to use the "linked_tables" argument for that (can either be a list, or a dictionary of lists, to

[web2py] Re: Migration fails when dropping a column on Postgresql

Probably the code for dropping columns was never updated to handle rnames. Please submit an issue in the pydal repo: https://github.com/web2py/pydal/issues. Anthony On Wednesday, May 31, 2017 at 11:48:24 AM UTC-4, Doug Taylor wrote: > > Hi I'm a relative noob to web2py and python - but plenty o

[web2py] Re: SQLFORM.grid - trying to limit search filter to queried items not entire table items

> > Is it possible to get the display_name (virtual field) to appear/behave as > a 'normal' field in the grid? > No. Searching and sorting are handled via database queries, and the virtual field values are not stored in the database but are calculated in Python *after* records are fetched from

[web2py] Re: Future of web2py

But web2py is still maintained right? or we start buying flask books On Saturday, May 27, 2017 at 9:11:02 AM UTC+2, Andrea Fae' wrote: > > Hello guys, > I'd like to know if there will be future of web2py? Any information about > it? > Thanks > -- Resources: - http://web2py.com - http://web2py.c

[web2py] Re: smartgrid

Thank you very much but i have new problem it shows on right the links Auth memberships Auth events Auth cases ... and i'd like to select and not show all the linked tables Le mercredi 31 mai 2017 17:45:17 UTC+2, Anthony a écrit : > > Use the "constraints" argument, which is a dictionary wit

[web2py] SQLFORM.grid - trying to limit search filter to queried items not entire table items

I have a person table and a task table, every task references some person. Both tables have a virtual field 'display_name' that constructs a meaningful coded name returned as a string to display on screen if person is a 'client'. SQLFORM.grid is used to provide a selectable list of entries

Re: [web2py] Re: Semantic UI for SQLFROM.grid

I think you are rigth about the root of the issue... It maybe because styling is so painfull, so we try to avoid it as much as possible... :) Richard On Mon, May 29, 2017 at 7:08 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Big can of worms. Look into sqlhtml.py where the bootst

Re: [web2py] Migration fails when dropping a column on Postgresql

Hi Doug, I am not sure I follow and understand the exact problem, it maybe me, but can you provide model before and after and. You may also try to reproduce the bug and explain the exact step to trigger it and pack an dummy app to facilitate the reproducing of the bug for us. Also, specify the v

[web2py] Re: Future of web2py

What do you think about weppy? It is based in web2py and have some thoughts interests -- 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 me

[web2py] Migration fails when dropping a column on Postgresql

Hi I'm a relative noob to web2py and python - but plenty of dev experience. Must say it has been a smooth learning curve for me and most stuff just works out the box... thanks Massimo! Pretty sure I found a bug here though. Running on ubuntu Xenial, postgresql 9.6 with psycopg2. I have a table

[web2py] Error while running web2py.py

getting this error..Help please *student@student-HP:~/web2py$* * python web2py.py -i 0.0.0.0web2py Web FrameworkCreated by Massimo Di Pierro, Copyright 2007-2017Version 2.0.8 (2012-09-07 03:47:51) stableDatabase drivers available: SQLite(sqlite3), MySQL(pymysql), PostgreSQL(pg8000),

[web2py] Re: Can't show images from database in web2py 2.14.6?

Hard to say without more details. What response is returned to the browser? Does this generate an error ticket? Did you change anything in the system (move any files, etc.)? Are you sure the file is where it is supposed to be? Anthony On Wednesday, May 31, 2017 at 8:43:27 AM UTC-4, Mike Stephen

[web2py] Re: smartgrid

Use the "constraints" argument, which is a dictionary with table names as keys and queries as values. SQLFORM.smartgrid(db.auth_user, constraints=dict(auth_user=db.auth_user.id == 2), ...) Anthony On Wednesday, May 31, 2017 at 11:03:06 AM UTC-4, LC LC wrote:

[web2py] Re: grid edit

On Wednesday, May 31, 2017 at 5:39:11 AM UTC-4, T.R.Rajkumar wrote: > > When I do SQLFORM.grid(db.amc_master) without setting any of the > readable/writable attributes the grid edit works fine. I am able to edit > and the form submits without errors. > Even with specifying the fields list grid e

[web2py] smartgrid

Hi, i'd like to have a conditional expression when i use smart grid, is it possible query=db(db.auth_user.id=='2').select() grid = SQLFORM.smartgrid(query,linked_tables=['coautor','aff'], user_signature=True) i know in the doc it is written "The first argument is a table, not a query"

Re: [web2py] now web2py related but this is free now ...

Very nice! web2py kind of integration apply to math/statistic/algorithym :) Richard On Wed, May 31, 2017 at 6:27 AM, Johann Spies wrote: > +1 Thank you very much. > > Johann > > > -- > Because experiencing your loyal love is better than life itself, > my lips will praise you. (Psalm 63:3) > >

[web2py] Re: grid edit

Have you tried adding 'id' to your editable field list? [setattr(f, 'writable', False) for f in db.amc_master if f.name not in ['amcdesc','amcmod','complndays', 'id']] -Jim On Wednesday, May 31, 2017 at 4:39:11 AM UTC-5, T.R.Rajkumar wrote: > > When I do SQLFORM.grid(db.amc_master) without sett

[web2py] Can't show images from database in web2py 2.14.6?

I used the following snippet before in the old versions of web2py. They worked like charm there. However doesn't work here. What am I losing? controller: row1=db(db.slideshow).select().first().picture in view: the image doesn't display at all! -- Resources: - http://web2py.com - http://web2

[web2py] Re: not web2py related but this is free now

And a nice positive review here: http://ieeexplore.ieee.org/document/7030301/. On Wednesday, May 31, 2017 at 8:17:13 AM UTC-4, Anthony wrote: > > Briefly made it to the front page of Hacker News yesterday: > https://news.ycombinator.com/item?id=14443789. That caused a jump from > 180 to 858 Git

[web2py] Re: not web2py related but this is free now

Briefly made it to the front page of Hacker News yesterday: https://news.ycombinator.com/item?id=14443789. That caused a jump from 180 to 858 Github stars . Anthony On Monday, May 29, 2017 at 7:32:51 PM UTC-4, Massimo Di Pierro wrote: > > ...

[web2py] Re: left join in grid is throwing unsupported operand types for += 'dict and 'dict'

Yes, definitely a bug. A change was made in PyDAL and the grid code was not updated to accommodate the change. Should be a fairly easy fix. Anthony On Wednesday, May 31, 2017 at 5:22:10 AM UTC-4, Tim Richardson wrote: > > I think it's a bug, I reported it here > https://github.com/web2py/web2py

[web2py] Re: not web2py related but this is free now

nice book Massimo, I'll be studying it during the next holidays. A more severe future might arise quickly so better be cautious. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issu

Re: [web2py] now web2py related but this is free now ...

+1 Thank you very much. Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web

[web2py] Re: web2py support

Could be interesting to hear what are the arguments for the porting The points are 1. The application business logic has changed and the workflow has also changed. So I have to do the app fresh. 2. Since I like web2py I thought of porting it to web2py. Why I like web2py? The answer is a. Th

Re: [web2py] Re: Future of web2py

To Massimo... maybe we can have something like this in future web2py versions... https://tg.pl/drab 2017-05-31 2:08 GMT+01:00 Dave S : > > > On Tuesday, May 30, 2017 at 5:11:49 PM UTC-7, Ron Chatterjee wrote: >> >> Massimo, Do you see its better to do incremental cha

[web2py] Re: grid edit

When I do SQLFORM.grid(db.amc_master) without setting any of the readable/writable attributes the grid edit works fine. I am able to edit and the form submits without errors. Even with specifying the fields list grid edit works fine as the edit from has all the fields of the table. But when I

[web2py] Re: left join in grid is throwing unsupported operand types for += 'dict and 'dict'

I think it's a bug, I reported it here https://github.com/web2py/web2py/issues/1636 This used to work and the error is so basic that something must have changed somewhere, hopefully something obvious. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.c

[web2py] how to change the style of the autocomplete in SQLFORM, particular the textbox width

Hi there, I have made a custom style of the SQLFORM, one field uses autocomplete, and it's textbox is shorter than the rest of the field. I simply want to have the same width. I searched in the previous post, another thread pointed out that the html source shows 200px width, i wonder where I ca