[web2py] smartgrid: how to disable repeating parent ID in child record

2013-03-12 Thread Alex Glaros
In smartgrid, is there a way to keep the parent ID from repeating in the child file? I'd like for the parent ID field to appear only once in the child file at the beginning where the first child record begins thanks, Alex Glaros -- --- You received this message because you are subscribed t

[web2py] how to update from an ajax call

2013-03-12 Thread weheh
I'm using an ajax callback to dynamically update the main content in my page. I want to also change the page and to mirror the new content. Since these are set in the layout.html file and I'm not refreshing the whole page, I'm not sure how to change these values. Is there a way to do what I w

[web2py] Re: Version 2.4.4 Bug?

2013-03-12 Thread Jyoti Sharma
I run it using uwsgi and nginx on ubuntu. I stopped nginx server then restarted uwsgi and then started the nginx server. Regards, Jyoti On Tuesday, 12 March 2013 19:59:33 UTC+5:30, Massimo Di Pierro wrote: > > Did you restart web2py after upgrade? > > On Tuesday, 12 March 2013 05:11:56 UTC-5, J

Re: [web2py] how to start Celery worker in web2py

2013-03-12 Thread Massimo Di Pierro
This belongs to a blog post! On Tuesday, 12 March 2013 17:23:21 UTC-5, Niphlod wrote: > > ok, I think I got it . most of it is cumbersome and fruit of multiple > reiteration (e.g. lots of trials and errors). There's no way in hell to put > up celery docs pertaining the particular usecase in

Re: [web2py] db column comment

2013-03-12 Thread Richard Vézina
I will show you some code tomorrow. :) Richard On Tue, Mar 12, 2013 at 7:51 PM, Alex wrote: > Richard, > > this sounds interesting but I did not fully understand what you're doing. > Some code would probably help. > > thanks, > Alex > > Am Dienstag, 12. März 2013 16:24:06 UTC+1 schrieb Richar

[web2py] SQLFORM.smartgrid where are the default styles located

2013-03-12 Thread leapingidiots
I am trying to locate where the SQLFORM.smartgrid default styles are located in my web2py project. Any help would be appreciated *cheers -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving

[web2py] Why does session get reset every time a page is loaded?

2013-03-12 Thread Vixus
I have defined a Search class in models/search.py and I store this in session: if session.search == None: session.search = Search() But I was wondering why nothing that was being set in the class was being carried throughout the session, and when I checked it turns out that this session vari

[web2py] Re: No CMS for Web2Py?

2013-03-12 Thread Derek
Well, the thing about web2py is that it's been backwards compatible from the start, so an abandoned project should work just fine in the latest version of Web2py. The way it's laid out, it makes modifying code easy as well. Don't be afraid to pick up an older CMS and run with it. On Tuesday, Ma

[web2py] how to automatically get the parent primary key into the child foreign key?

2013-03-12 Thread Alex Glaros
In example 34 below, is there a way to automatically get personID and productID into the purchase table without needing to select them if the person was already associating with the product? Let's say, Joe chooses to buy something from my store. He clicks on the product which takes him to smar

[web2py] Re: How to add field to SQLFORM.grid

2013-03-12 Thread Alan Etkin
> Hi. I need to add field (column) to the SQLFORM.grid. The column is simple > order number – just numbers 1,2,3,4,... at the beginning of every row. > I did not find a builtin feature of grid to make that, but can think of two ways of doing this a) Using virtual fields and the grid fields ar

[web2py] Re: Is this a bug? DAL update records using an expression

2013-03-12 Thread Alex
I've got the same problem. I have a field with type decimal(12,4), I can add a number to this field but not subtract. So instead of db(db.client_service.id == id).update(minutes_done = db.client_service.minutes_done - minutes) I have to write minutes = -minutes db(db.client_service.id == id).up

Re: [web2py] db column comment

2013-03-12 Thread Alex
Richard, this sounds interesting but I did not fully understand what you're doing. Some code would probably help. thanks, Alex Am Dienstag, 12. März 2013 16:24:06 UTC+1 schrieb Richard: > > Alex, > > Maybe you could be interested to know how manage labels, comments, etc. > > I create a table n

[web2py] db.Field "required=True" not working

2013-03-12 Thread Jeison Dück
Hello, people, I know this is a newbie question but, that "required" parameter bellow shouldn't prevent from saving an empty value for myfield? It's being saved empty. All next table definitions I have in db.py are working as expected but that. db.define_table('sample', db.Field('myfield',

[web2py] Re: No CMS for Web2Py?

2013-03-12 Thread mjm
Hi Massimo auth.wiki seems useful, but mostly for the site developer, not user friendly enough for site owner/user IMHO. Something like Plone is overkill for a website. I'd like to see something simple and polished somewhere in between. I'd be hesitant to use projects like Instant Press and Mo

[web2py] Re: web2py 2.4.3 is OUT

2013-03-12 Thread Tim Richardson
> > The web page has a new look. I hope you like it. > > When my web2py apps grow up, they want to look like yours. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send a

Re: [web2py] how to start Celery worker in web2py

2013-03-12 Thread Niphlod
ok, I think I got it . most of it is cumbersome and fruit of multiple reiteration (e.g. lots of trials and errors). There's no way in hell to put up celery docs pertaining the particular usecase in web2py. Pleease, watch it carefully, may burn your house to the ground. @Bruno: maybe the s

[web2py] Re: No CMS for Web2Py?

2013-03-12 Thread Massimo Di Pierro
The builit-in wiki despite the misleading name, is kind of a CMS. You have pages. Pages have attachements. Pages have permissions. Attachments inherit permissions. If you think of a page as a folder, this is a CMS lite. ;-) There is InstantPress, there is movu.ca and there is w2cms (https://git

Re: [web2py] Re: new app www.foxter.co

2013-03-12 Thread samuel bonilla
all ready you can enter with google plus www.foxter.co other suggestions or advice. 2013/3/12 samuel bonilla > thanks Derek, good idea, I will implement janrain. > > please, i need more suggestions or advice > > 2013/3/12 Derek > >> Looks good, my only issue is the login, I hate ha

[web2py] No CMS for Web2Py?

2013-03-12 Thread mjm
I really like Web2Py to get things done without much fuss. But I am somewhat surprised there seems to be no CMS for W2P. Projects mentioned in this context on this list Instant Press and Movuca are not very active: Instant Press has seen no releases since 2010. Movuca almost no commits in the

Re: [web2py] how to start Celery worker in web2py

2013-03-12 Thread Niphlod
cause I know exactly how to create a web2py environment in "my own module" but for the life of me I can't figure out how to apply the same method to a celery worker (if you're not a fan of "magic" in web2py, celery workers instances do a LT of magic behind the scenes) On Tuesday, March 12,

Re: [web2py] how to start Celery worker in web2py

2013-03-12 Thread Eric S
Is it not possible launch a Celery worker that has access to the web2py environment? This is possible for custom schedulers with commands such as the following -- why would it not be available to Celery workers? python web2py.py -S appName -M -R worker.py On Tuesday, March 12, 2013 10:17:47 A

Re: [web2py] how to start Celery worker in web2py

2013-03-12 Thread Niphlod
more than celery we'd need a generalized web2py "create the context" recipe running tasks defined in modules is easy. running tasks outside web2py that needs the usual environment is a PITA On Tuesday, March 12, 2013 6:17:47 PM UTC+1, Eric S wrote: > > > I'm interested in a robust

[web2py] Re: grid/smartgrid searching foreign key tables

2013-03-12 Thread Niphlod
yep, in a "programmatic" way cause *format* can be any callable in the world of the developer mind, but basically the idea is the same. On Tuesday, March 12, 2013 9:54:53 PM UTC+1, Alex Glaros wrote: > > like de-normalized? > > On Tuesday, March 12, 2013 1:41:29 PM UTC-7, Niphlod wrote: >> >> it'

[web2py] Re: Creating a DB that mirrors the structure of an existing DB for archiving purposes?

2013-03-12 Thread Lamps902
Thanks, guys - this appears to be exactly what I needed! Is it generally a good idea, as far as performance goes, to store the archived entries in a separate database, as opposed to the original *db*? -- --- You received this message because you are subscribed to the Google Groups "web2py-us

[web2py] Re: grid/smartgrid searching foreign key tables

2013-03-12 Thread Alex Glaros
like de-normalized? On Tuesday, March 12, 2013 1:41:29 PM UTC-7, Niphlod wrote: > > it's a table that is "close to the original", in this case with all > columns filled directly with the representation of the eventual foreign key > of the original one. > > On Tuesday, March 12, 2013 9:23:55 PM U

Re: [web2py] Re: new app www.foxter.co

2013-03-12 Thread samuel bonilla
thanks Derek, good idea, I will implement janrain. please, i need more suggestions or advice 2013/3/12 Derek > Looks good, my only issue is the login, I hate having to setup a new login > for a new website. Any way you can just enable janrain? > > > On Tuesday, March 12, 2013 11:51:11 AM UT

[web2py] Re: grid/smartgrid searching foreign key tables

2013-03-12 Thread Niphlod
it's a table that is "close to the original", in this case with all columns filled directly with the representation of the eventual foreign key of the original one. On Tuesday, March 12, 2013 9:23:55 PM UTC+1, Alex Glaros wrote: > > what is a "shallow copy table"? > > Alex Glaros > > On Sunday,

[web2py] Re: grid/smartgrid searching foreign key tables

2013-03-12 Thread Alex Glaros
what is a "shallow copy table"? Alex Glaros On Sunday, March 10, 2013 6:50:56 PM UTC-7, Cliff Kachinske wrote: > > I define a table so: > db.define_table ('mytable', blah..., format='% (name) s') > > So as we know, grid will display the contents of the name field when > mytable is used as a fore

[web2py] Re: select all in grid and smargrid?

2013-03-12 Thread Jack
Thank you all for replying. So what I wanted was a "select all" checkbox on top of the grid, after doing some searching, I hacked this together myself. after defining the grid I put in the following code: heading=grid.elements('th') if heading: heading[0].append(INPUT(_type='checkbox',

[web2py] Re: Creating a DB that mirrors the structure of an existing DB for archiving purposes?

2013-03-12 Thread Niphlod
check this out. http://web2py.com/books/default/chapter/29/06#Record-versioning On Tuesday, March 12, 2013 7:02:09 PM UTC+1, Lamps902 wrote: > > Hi, group. For each database in a subset of my project's databases, I > would like to have a corresponding database that (almost) clones the > structu

[web2py] Re: Creating a DB that mirrors the structure of an existing DB for archiving purposes?

2013-03-12 Thread Derek
Enable versioning. Add this line to your db.py... auth.enable_record_versioning(db) On Tuesday, March 12, 2013 11:02:09 AM UTC-7, Lamps902 wrote: > > Hi, group. For each database in a subset of my project's databases, I > would like to have a corresponding database that (almost) clones the >

[web2py] Re: new app www.foxter.co

2013-03-12 Thread Derek
Looks good, my only issue is the login, I hate having to setup a new login for a new website. Any way you can just enable janrain? On Tuesday, March 12, 2013 11:51:11 AM UTC-7, samuel bonilla wrote: > > hi all... > > foxter.co is a social network in spanish based in movuca( > github.com/rochacbru

[web2py] new app www.foxter.co

2013-03-12 Thread samuel bonilla
hi all... foxter.co is a social network in spanish based in movuca(github.com/rochacbruno/Movuca) to share articles and news thank to massimo by web2py, and bruno rocha by movuca is a great project any suggestions or advice is accepted www.foxter.co -- --- You received this message b

[web2py] Re: problem: loading bs4 (beautifulsoup4) package is successfull only if I try it twice

2013-03-12 Thread Massimo Di Pierro
Interesting. So to recap. No more problems with 2.4.4 except in the windows binary. Can you please open a ticket about this? On Tuesday, 12 March 2013 11:35:14 UTC-5, Mirek Zvolský wrote: > > Previous was in 2.3.2. > I moved forward to 2.4.4 and running from sources on localhost it works > now:

Re: [web2py] Re: web2py 2.4.3 is OUT

2013-03-12 Thread LightDot
You're basically suggesting a design change from a list to a grid..? I'm not sure I'd agree, especially if the grid would be as busy as the one you've used as an example, but the admin is just an application, you can submit patches. Which might or might not get included :) Sorting alphabeticall

[web2py] Creating a DB that mirrors the structure of an existing DB for archiving purposes?

2013-03-12 Thread Lamps902
Hi, group. For each database in a subset of my project's databases, I would like to have a corresponding database that (almost) clones the structure of the original database. The mirror databases will be used to archive records that have been deleted from the original databases. For example, if

Re: [web2py] how to start Celery worker in web2py

2013-03-12 Thread Eric S
I'm interested in a robust, widely-adopted scheduler. The current web2py Scheduler is clearly changing very rapidly, which is great, for now I want a scheduler that is mature. Can anyone answer my original question -- how have you gotten Celery workers to run with web2py? On Thursday, March

[web2py] Re: web2py 2.4.3 is OUT

2013-03-12 Thread samuel bonilla
wo. is very, very nice. El lunes, 11 de marzo de 2013 14:54:29 UTC-5, Massimo Di Pierro escribió: > > Fixes many bugs reported by users. > > The web page has a new look. I hope you like it. > > http://web2py.com > > Many tanks to all the contributors, including but not limited to:

[web2py] Re: problem: loading bs4 (beautifulsoup4) package is successfull only if I try it twice

2013-03-12 Thread Mirek Zvolský
In 2.4.4 win-binary is behaviour similar as in 2.3.2 source - sometimes fails the 1st attempt with KeyError, the 2nd attempt continues, but ends with the other error; there are no changes in sys.path. In 2.4.4 source all run perfect / I have tested on localhost and on alwaysdata.net -- ---

[web2py] Re: problem: loading bs4 (beautifulsoup4) package is successfull only if I try it twice

2013-03-12 Thread Mirek Zvolský
In 2.3.2 sys.path were always same, but the 2-nd attempt was successfull. But I don't think this is now important, if in 2.4.2. seems to be fixed (except of win binary version). Dne úterý, 12. března 2013 17:16:47 UTC+1 Massimo Di Pierro napsal(a): > > Can you please do a test for me? > > In tho

[web2py] Re: problem: loading bs4 (beautifulsoup4) package is successfull only if I try it twice

2013-03-12 Thread Mirek Zvolský
Previous was in 2.3.2. I moved forward to 2.4.4 and running from sources on localhost it works now: from browser and from command. python web2py.py -M -S akce/sys/bs # contains only: from bs4 import BeuatifulSoup However (not very important, of course, but to have web2py perfect) it doe

[web2py] Re: problem: loading bs4 (beautifulsoup4) package is successfull only if I try it twice

2013-03-12 Thread Massimo Di Pierro
Can you please do a test for me? In those cases when it works after the second attempt. Can you print sys.path before the first attempt (which fails), after the first attempt and after the second attempt? Massimo On Tuesday, 12 March 2013 09:47:34 UTC-5, Mirek Zvolský wrote: > > I try load the

[web2py] Re: problem: loading bs4 (beautifulsoup4) package is successfull only if I try it twice

2013-03-12 Thread Mirek Zvolský
No. Same import repeated second time is always successfull. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more o

[web2py] Debug Remote on Server using local Eclipse on Windows

2013-03-12 Thread Christian Sattler
Hello, I searching a solution for the following development environment: We want to develop an online application using web2py on a development webserver (based on debian linux). All developers are using Windows workstations with an Eclipse IDE to edit and to remote debugging the sources. T

Re: [web2py] db column comment

2013-03-12 Thread Richard Vézina
Alex, Maybe you could be interested to know how manage labels, comments, etc. I create a table name database_dict that contain the list of all my fields and table where I create all the columns I want to store anything I want concerning fields and tables, like : table_description, field_descripti

Re: [web2py] db column comment

2013-03-12 Thread Alex
something like a dbcomment argument would be really nice. Of course the implementation has to be db engine specific. In case the db does not support column comments then it should be ignored. For now I'll keep on updating the comments manually, hopefully it will be supported in the future :) A

[web2py] Re: "Not Supported" error when making a select with an OR over GAE

2013-03-12 Thread Massimo Di Pierro
Unless things have changed very recently, GAE can only do OR where the left and right expressions involve the same field. On Tuesday, 12 March 2013 07:25:28 UTC-5, José Manuel López wrote: > > I'm over GAE and I'm trying to do this: > db((db.Hotel.managerID == user)|(db.Hotel.hotelChainManager ==

Re: [web2py] problem: loading bs4 (beautifulsoup4) package is successfull only if I try it twice

2013-03-12 Thread Richard Vézina
Could it be related : http://stackoverflow.com/questions/12902783/where-is-beautifulsoup4-hiding On Tue, Mar 12, 2013 at 10:47 AM, Mirek Zvolský wrote: > I try load the bs4 (beautifulsoup4) package, on localhost and on > alwaysdata hosting: > # pip install beuatifulsoup4 > from bs4 import Beaut

[web2py] Re: 2.4.2 breaks custom login form

2013-03-12 Thread Massimo Di Pierro
Answered in the other thread. The main problem is the in your layout. On Tuesday, 12 March 2013 05:35:33 UTC-5, Eric wrote: > > > https://groups.google.com/forum/?fromgroups=#!searchin/web2py/2.4.2$20login/web2py/G4XnV87dh60/p7cRZKM9Xc0J > > Is the same question. A app is posted there :) > --

[web2py] Re: Login not possible in Chrome and Firefox on 2.4.2 (stable) 2013-03-04 03:26:21

2013-03-12 Thread Massimo Di Pierro
There are two interesting issues here: 1) Your view contains: And action="#" is interpreted by Chrome as relative to the base and not as relative to the current URL. This is bug in Chrome in my opinion but reason enough to revert the action default to "#". 2) even after removing the code

[web2py] problem: loading bs4 (beautifulsoup4) package is successfull only if I try it twice

2013-03-12 Thread Mirek Zvolský
I try load the bs4 (beautifulsoup4) package, on localhost and on alwaysdata hosting: # pip install beuatifulsoup4 from bs4 import BeautifulSoup # single command in akce/sys/bs controller function except of return 'ok' Import command works fine: - in pure python, outside of web2py - in browse

[web2py] Re: form.element mutiple attributes

2013-03-12 Thread Annet
Hi Anthony, Thanks for your reply, problem solved! Best regards, Annet. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.

Re: [web2py] db column comment

2013-03-12 Thread Niphlod
correct. Unless someone scripts something specific (shouldn't be hard), but as far as I know it would have to be pretty specific to every db engine (e.g. I don't think mongo has column comments ^_^) On Tuesday, March 12, 2013 3:22:22 PM UTC+1, Alex wrote: > > actually I don't need the comment in

[web2py] Re: import csv database admin

2013-03-12 Thread Alan Etkin
You may want to try this module also: https://groups.google.com/d/msg/web2py-developers/QxeJNByj6qc/cpBHsa1ymUkJ -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an ema

[web2py] Re: Version 2.4.4 Bug?

2013-03-12 Thread Massimo Di Pierro
Did you restart web2py after upgrade? On Tuesday, 12 March 2013 05:11:56 UTC-5, Jyoti Sharma wrote: > > not enough arguments for format string > > message:'Version %s.%s.%s (%s) %s' > self: > sub_plural: > symbols:('2.4.4-stable+timestamp.2013.03.11.20.32.00', > >

[web2py] Re: import csv database admin

2013-03-12 Thread Alan Etkin
Start with the obvious: Do the exported files have data? By "nothing happens" you mean the import from csv feature does not insert the values back? Is there any error feedback (ticket, flash message)? You could try by making complete dump and load in the console with the this methods: The admin

Re: [web2py] Re: Status of workflow functionality

2013-03-12 Thread dlypka
Workflow typically stores its state in very complex sql tables. If something goes wrong the tables are easily corrupted and then it is very hard to fix. (brittle) Also if the table design evolves, it is hard to migrate. This is my experience with Microsoft Workflow for Windows. I believe an entit

Re: [web2py] db column comment

2013-03-12 Thread Alex
actually I don't need the comment in the backend but I want to comment my code. Often it is useful for me to have the comment in the db as well. When I add or change a comment in my code I also have to update the db (comment on column ...). This means additional work and can easily be forgotten

Re: [web2py] Re: How to TERMINATE a RUNNING Scheduler Task?

2013-03-12 Thread David Lypka
I ran one test and it did indeed stop the task. scheduler_run.status = 'STOPPED' scheduler_task.status = 'QUEUED' scheduler_worker.status = 'ACTIVE' return value from stop_task() was 1 So I got 'QUEUED' rather than 'FAILED' but that seems logical to me. My task function body was: def task_fabrun

Re: [web2py] db column comment

2013-03-12 Thread Richard Vézina
Ha, maybe it was that... So I thougth it were fetching the comment content of postgres... Richard On Tue, Mar 12, 2013 at 9:27 AM, Niphlod wrote: > the only thing working is if you use scripts/extract_pgsql_models.py it > will create define_table statements with comments in it, but there's no

Re: [web2py] tips from a seasoned practitioner

2013-03-12 Thread Anthony
This is the db tables HTML table: response.toolbar()[9][0][0], and this is the db stats table: response.toolbar()[10][0][0]. So, you can insert just the HTML for those tables without bothering with the buttons and Javascript. Anthony On Tuesday, March 12, 2013 7:08:38 AM UTC-4, Ricardo Pedroso

[web2py] Re: form.element mutiple attributes

2013-03-12 Thread Anthony
Helpers act like dictionaries with respect to their attributes, so you can use the Python .update() method: form.element('input[name=tag]').update(_class='input-small', _placeholder= 'Tag', _style='width: 144px;') Anthony On Tuesday, March 12, 2013 9:24:44 AM UTC-4, Annet wrote: > > I have the

Re: [web2py] db column comment

2013-03-12 Thread Niphlod
the only thing working is if you use scripts/extract_pgsql_models.py it will create define_table statements with comments in it, but there's no other "facility" included in web2py to transpose column comments on the model without actually having a comment='' for each field . On Tuesday, March 1

Re: [web2py] db column comment

2013-03-12 Thread Richard Vézina
And this could be a easy (maybe ogly) solution to document his field : Field('status', 'integer', comment=['0=error, 1=warning, 2=success', 'documenting comment'][0]) Richard On Tue, Mar 12, 2013 at 9:21 AM, Richard Vézina wrote: > Hmmm... I should check, but I remember that when there was co

[web2py] form.element mutiple attributes

2013-03-12 Thread Annet
I have the following code to make an SQLFORM and inline form: form.element('input[name=tag]')['_class']='input-small' form.element('input[name=tag]')['_placeholder']='Tag' form.element('input[name=tag]')['_style']='width: 144px;' Is it possible to combine these three statements into one statem

Re: [web2py] db column comment

2013-03-12 Thread Richard Vézina
Hmmm... I should check, but I remember that when there was comment in Postgres they were in the form, maybe it only working in postgres... Maybe it not working anymore, but I am pretty sure it was working in the pass... Anyway, he can keep his comment at database level for documentation purpose if

Re: [web2py] db column comment

2013-03-12 Thread Niphlod
nope. comment exists only in the web2py realm (i.e. models definitions). There's no way to have a standardized syntax to store comments in the database too (and I'm not sure either every db engine has the support for it) On Tuesday, March 12, 2013 1:52:55 PM UTC+1, Richard wrote: > > If I rememb

Re: [web2py] db column comment

2013-03-12 Thread Richard Vézina
If I remember web2py get the backend comment if there is no comment in the model definition.. So if you want to have dual comment definition, use your backend comment for code documentation and override them in your model definition... Richard On Tue, Mar 12, 2013 at 8:27 AM, Alex wrote: > Hi,

[web2py] web2py database drivers

2013-03-12 Thread Daniel Verdú
Hi, i have a trouble with database drivers. The problem begins after installing MapProxy http://mapproxy.org/ using easy_install MapProxy on the same machine i runs web2py. When i run web2py says that google is only the database driver available : C:\web2py>python web2py.py -v -l c:\web2py\logs\

[web2py] How to add field to SQLFORM.grid

2013-03-12 Thread Andrii Pitukh
Hi. I need to add field (column) to the SQLFORM.grid. The column is simple order number – just numbers 1,2,3,4,... at the beginning of every row. Also, as you can see, this field should NOT be viewed in update or create mode. I'm sure there should be way to accomplish this. Thanks in advance fo

Re: [web2py] Formatting radio widgets (or radio buttons)

2013-03-12 Thread Richard Vézina
Just don't pickup the label, remove these entry from your custom form : form.custom.label[fieldname] On Tue, Mar 12, 2013 at 6:35 AM, Johann Spies wrote: > On 11 March 2013 18:36, Richard Vézina wrote: > >> An other option could be customize widget and you add the bootstrap >> class... >> >> >>

[web2py] db column comment

2013-03-12 Thread Alex
Hi, is it possible to set the database column comment in web2py? I'd like to document my fields only once and have the comment in the code and in the db. At the moment I comment some of my fields in db.py like Field('status', 'integer', comment='0=error, 1=warning, 2=success') So I'm somehow

[web2py] "Not Supported" error when making a select with an OR over GAE

2013-03-12 Thread José Manuel López
I'm over GAE and I'm trying to do this: db((db.Hotel.managerID == user)|(db.Hotel.hotelChainManager == user)).select () But I'm getting an error: File "/Users/XXX/Development/Server/web2py/gluon/dal.py"*, *line 4237*, **in *OR *def *OR*(**self**,*first*,*second*): **raise *SyntaxError*(*"Not

Re: [web2py] Formatting radio widgets (or radio buttons)

2013-03-12 Thread Cliff Kachinske
Adding a class to a widget isn't hard. Here's an example of a bootstrap class added to a textarea widget: db.issues.description.widget = lambda field,value:\ SQLFORM.widgets.text.widget(field,value,_class='input-xxlarge') On Tuesday, March 12, 2013 6:35:23 AM UTC-4, Johann Spies wr

Re: [web2py] Re: grid/smartgrid searching foreign key tables

2013-03-12 Thread Cliff Kachinske
No, I'm the one who was missing bits :( The search widget has come a lng way since the last time I experimented with grid. Thanks to all who have worked on it. On Tuesday, March 12, 2013 4:26:05 AM UTC-4, Niphlod wrote: > > I'm starting to miss some bits ok for autocomplete, select

Re: [web2py] Re: grid/smartgrid searching foreign key tables

2013-03-12 Thread Niphlod
no probl. maybe we can embed some "help page" directly too. let me know when it'll be ready. On Tuesday, March 12, 2013 12:06:35 PM UTC+1, Philip Kilner wrote: > > Hi Niphlod, > > On 12/03/13 08:26, Niphlod wrote: > > PS: I remember that some user wanted to put up a nice doc for users (not > >

Re: [web2py] tips from a seasoned practitioner

2013-03-12 Thread Ricardo Pedroso
On Tue, Mar 12, 2013 at 3:37 AM, Anthony wrote: > Note, response.toolbar() already includes both of these things in the "db > tables" and "db stats" buttons. "db tables" even differentiates between lazy > tables and tables that have been fully defined so you can see which tables > are getting defi

Re: [web2py] Re: grid/smartgrid searching foreign key tables

2013-03-12 Thread Philip Kilner
Hi Niphlod, On 12/03/13 08:26, Niphlod wrote: PS: I remember that some user wanted to put up a nice doc for users (not developers) facing the grid/smartgrid never heard of him back :( That was me! :-) I've done some simple notes with screen shots for my client, but need to ask people

[web2py] Re: 2.4.2 breaks custom login form

2013-03-12 Thread Eric
https://groups.google.com/forum/?fromgroups=#!searchin/web2py/2.4.2$20login/web2py/G4XnV87dh60/p7cRZKM9Xc0J Is the same question. A app is posted there :) -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and

Re: [web2py] Formatting radio widgets (or radio buttons)

2013-03-12 Thread Johann Spies
On 11 March 2013 18:36, Richard Vézina wrote: > An other option could be customize widget and you add the bootstrap > class... > > > On Mon, Mar 11, 2013 at 12:35 PM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> Form custom maybe?? >> >> >> http://web2py.com/books/default/chapter/2

[web2py] Version 2.4.4 Bug?

2013-03-12 Thread Jyoti Sharma
not enough arguments for format string message:'Version %s.%s.%s (%s) %s' self: sub_plural: symbols:('2.4.4-stable+timestamp.2013.03.11.20.32.00', After upgrading I could not access the admin interface, I kept getting the above error. I edited admin/languages/def

[web2py] Re: web2py on GAE: Connect to google:sql and google:datastore

2013-03-12 Thread Alan Etkin
> What do you think? Could this work? Will web2py auth support this? > If the google:sql adapter supports joins (which I belive is the reason for the accessible_query restriction), and I think it does, there should be no problem, but I never tried it. The issue is how to deal with access contr

[web2py] Re: Problem with smartgrid no GUI Bread Crums or missing buttons for links

2013-03-12 Thread Niphlod
this is what happens when you use the correct css with the markup you posted. something on your end isn't serving the styles. On Tuesday, March 12, 2013 11:12:35 AM UTC+1, Dan Kozlowski wrote: > > > > Attached HTML file >> >> -- --- You received this message because you are subscribed to

Re: [web2py] Re: Status of workflow functionality

2013-03-12 Thread António Ramos
If i knew howto and have time i would create a workflow as a service. This way i centralize all my rules for every app in a single app. If i have 40 apps in my company it would be easy to manage all rules from all apps. Is this a good way to go? 2013/3/12 Cliff Kachinske > Workflow is not a

[web2py] Re: Problem with smartgrid no GUI Bread Crums or missing buttons for links

2013-03-12 Thread Dan Kozlowski
Attached HTML file > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.goog

[web2py] web2py on GAE: Connect to google:sql and google:datastore

2013-03-12 Thread decurgia
Hi all According to the web2py book[1] accessible_query(...) is not working on GAE. As there is now a google:sql and google:datastore storage available I thought of using both: sql for the auth and datastore for the rest. The output of the accessible_query would be ideal to query the datastore.

[web2py] Re: Integrating web2py with dhtmlx

2013-03-12 Thread Niphlod
I don't see any limitations if you want to with it. On Tuesday, March 12, 2013 9:58:53 AM UTC+1, software.ted wrote: > > Is its possible to use web2py with dhtmlx. Its got cool UI features!!! > very classy. > > > > -- > > ..

[web2py] Integrating web2py with dhtmlx

2013-03-12 Thread Teddy Nyambe
Is its possible to use web2py with dhtmlx. Its got cool UI features!!! very classy. -- ... Teddy Lubasi Nyambe Opensource Zambia Lusaka, ZAMBIA Cell: +260 97 7760473 website: http://www.opensource.org.zm ~/ Hu

Re: [web2py] Re: grid/smartgrid searching foreign key tables

2013-03-12 Thread Niphlod
I'm starting to miss some bits ok for autocomplete, select boxes, filter based on one column only but I think the basic functionality of the search widget seems "ok": if users are in a hurry they put something in and all text-ty fields gets searched, if they need an advanced search the

[web2py] import csv database admin

2013-03-12 Thread BlueShadow
Hi, I am trying to change my database from SQLite to postgres (As some of you already know :) ) I created a copy of my app (without the database folder) and changed the database to postgres (which finally works :) ) To get my database I exported every table to a csv file. but when I import the c