Re: [web2py] Re: How to find the entry in a table with the highest ID

2016-04-19 Thread Jack Lodge
When i try this method the Item_Request fills in the ID as None On Saturday, April 16, 2016 at 5:09:39 PM UTC+1, Richard wrote: > > Hello Jack, > > You mean you want to pass the id of the inserted record to another > controller ? > > # Controller form 1 > if form.pr

[web2py] How to find the entry in a table with the highest ID

2016-04-15 Thread Jack Lodge
Im trying to make a Order system for my alevel course work and when im filling in some forms i make a *Request* then i redirect the user to the *Item_Request* form to fill in the details there, i need to be able to get the id of the Request that they just submitted so i can populate the

[web2py] Re: web2py 2.14.1 beta

2016-03-22 Thread Jack Kuan
I assume these print statements(in *gluon/sqlhtml.py*), probably added while debugging, will be removed in the 2.14.1? print dbset.query print tablenames print tables Thanks On Monday, March 21, 2016 at 6:38:16 PM UTC-4, Massimo Di Pierro wrote: > > Please help

[web2py] Simple Tutorial for using web2py with an html5 template

2015-11-04 Thread jack somber
I found a modern template at html5up.com, and am trying to use it with web2py. Does anyone know of a tutorial for this. Assets include css, js, fonts, sass. Or is it as simple as uploading the assets and connecting them to the html? Thanks. -- Resources: - http://web2py.com -

[web2py] PyCharm license for web2py dev - who wants?

2015-10-15 Thread Jack Kuan
+1 Would love to give it a try. Thanks! -- 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

[web2py] Re: Modifying web2py JS files -- best practices?

2015-08-08 Thread Jack Kuan
, Jack Kuan wrote: Often the starting point of making a web2py app is to copy the welcome app and base your repo on it. But as you add/modify/delete files from your repo that's based on the welcome app to suit your need, you then face the problem of merging updates to the welcome app back

[web2py] Re: web2py 1.12.1 is out

2015-08-07 Thread Jack Kuan
surely you meant 2.12.1 ? -- 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: Modifying web2py JS files -- best practices?

2015-08-06 Thread Jack Kuan
that looks like the welcome app. If later the welcome app is updated in web2py, here's how you can merge the changes to your repo: git pull -s subtree -X subtree=applications/welcome web2py master Hope this is useful Jack On Thursday, August 6, 2015 at 1:41:12 AM UTC-4, Joe Barnhart wrote

[web2py] Re: Can we disable moderation in the group?

2015-03-12 Thread Jack Kuan
I too have a feeling that all my posts have been moderated because whenever I make a new post, I have to wait for hours or a day for it to show up in the group. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Can we disable moderation in the group?

2015-03-06 Thread Jack Kuan
I don't see the need and think it can be off putting for new comers. -- 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

[web2py] Weird problems with scheduler on OSX

2015-03-06 Thread Jack Kuan
I have had a similar problem with the scheduler on OS X. Try search scheduler os x urllib in this group, and see if my post helps. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Weird problems with scheduler on OSX

2015-03-06 Thread Jack Kuan
Hi Joe, Oh I'm sure web2py still uses urllib somewhere. Have you tried just adding the lines to gluon/widget.py and see if that helps? Jack On Friday, March 6, 2015 at 11:35:46 PM UTC-5, Joe Barnhart wrote: Hi Jack -- I found that post and checked, but my web2py (v.2.9.12-stable) did

[web2py] Running scheduler on OS X - problem with urllib.getproxies() and multiprocessing

2014-11-28 Thread Jack Kuan
://bugs.python.org/issue9405 +import urllib +urllib.getproxies() + for app in apps: app_, code = get_code_for_scheduler(app, options) if not app_: Just wanted to throw this out in case anyone meets the problem. Thanks Jack -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] SQLFORM.grid search: how to show only a subset of available search fields?

2014-10-26 Thread Jack Kuan
Answering my own question: my solution is to massage the returned grid object, removing duplicate options and other unwanted html elements. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] SQLFORM.grid search: how to show only a subset of available search fields?

2014-10-22 Thread Jack Kuan
Hi, I'm using left=[...] when creating a searchable SQLFORM.grid. My problem is that the drop-down menu for choosing which fields to build the search query contains ALL the fields in the search result. Is there a way to limit it to only a subset of the fields like what the 'fields' argument of

[web2py] Re: question about db.mytable.update_or_insert()

2014-08-13 Thread Jack Kuan
How does one usually deal with such conflict? (two identical(except for id's) inserts causing a violation of an unique constraint) Isolating the insert into its own transaction and then do a db.commit(), catch any exception and then ignore? Thanks On Wednesday, August 13, 2014 10:57:13 AM

[web2py] Record versioning without duplicate archive records?

2014-08-12 Thread Jack Kuan
a difference between the old row and the new row? Thanks Jack -- 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

[web2py] question about db.mytable.update_or_insert()

2014-08-12 Thread Jack Kuan
doesn't find any row and thus at the end, the two transcations both try to commit an insert, which could result in duplicated rows(with different id's) or an integrity error(eg, if there's an unique constraint)? Or is web2py smart enough to generate an insert that is safe? Thanks Jack

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

2013-03-12 Thread Jack
, Jack wrote: Hi all, I was playing around with selectables in the grid and smartgrid and found this example code in the mailing list: selectable = lambda ids: delete(ids) form=SQLFORM.grid(query, selectable=selectable) def delete(ids): to_delete=db(db.tabla.id.belongs(ids

[web2py] select all in grid and smargrid?

2013-03-11 Thread Jack
Hi all, I was playing around with selectables in the grid and smartgrid and found this example code in the mailing list: selectable = lambda ids: delete(ids) form=SQLFORM.grid(query, selectable=selectable) def delete(ids): to_delete=db(db.tabla.id.belongs(ids)) to_delete.delete() It

[web2py] FORM question- Retrieving value in a field onchange

2013-02-21 Thread Jack
Hi All, I was wondering if this is an possibility. Assume I have a form that includes two fields that take text input. Is there a way to implement a mechanism where after I've typed whatever I want in the first field, and the same string will appear in the second field or, have the text

[web2py] Smartgrid buttons not going away

2013-02-13 Thread Jack
Hi all, Just a simple but annoying problem. I am trying to configure the smartgrid so that the particular smartgrid does not have the ability to create and delete records. From my understanding this can be done by setting deletable='False' and create='False' when I make the smartgrid. However

[web2py] Re: Smartgrid buttons not going away

2013-02-13 Thread Jack
of web2py? -Jim On Wednesday, February 13, 2013 4:59:51 PM UTC-6, Jack wrote: Hi all, Just a simple but annoying problem. I am trying to configure the smartgrid so that the particular smartgrid does not have the ability to create and delete records. From my understanding this can be done

Re: [web2py] Re: Smartgrid buttons not going away

2013-02-13 Thread Jack
: You're setting them to the string value 'False'. Take the single quotes out and that should do it. -Jim On Wednesday, February 13, 2013 5:32:01 PM UTC-6, Jack wrote: Hi Jim, So I created a default new app and put in the following code, in model I have: db.define_table('Config_Table

[web2py] smartgrid custom layout

2013-02-04 Thread Jack
Hi All, Just a question regarding the smartgrid. I was wondering is there anyway to change the layout and format of the smartgrid. For example if I wanted to change the spacing I have for each row or add verticle lines to separate the columns. Ideally what I'm trying to achieve is have the

[web2py] Re: import csv files to update database

2013-02-04 Thread Jack
14:29:08 UTC-6, Jack wrote: Hi all, I've recently started playing around with web2py and i have encountered a problem with the csv importing function. I have a table defined called 'production' and i have already implemetned a smartgrid that will allow me to view,edit each row in the table

[web2py] import csv files to update database

2013-01-30 Thread Jack
Hi all, I've recently started playing around with web2py and i have encountered a problem with the csv importing function. I have a table defined called 'production' and i have already implemetned a smartgrid that will allow me to view,edit each row in the table. However, I want to implement a

Re: [web2py] Re: One last thing

2011-02-21 Thread Jack Lyons
that uses anyjson, but when I try to run my application, I get a ticket saying that there is no supported JSON module found. Thanks, --Jack -- Peace ┌─┐ ─┐☮ │▒│ /▒/ │▒│/▒/ │▒ /▒/─┬─┐ │▒│▒|▒│▒│ ┌┴─┴─┐-┘─┘ │▒┌──┘▒▒▒│ └┐▒▒“”

Re: [web2py] Re: One last thing

2011-02-21 Thread Jack Lyons
Jonathan- When I tried to put that in my script, I got this error message: Traceback (most recent call last): File gluon/restricted.py, line 188, in restricted File /Users/jacklyons/Downloads/web2py/web2py.app/Contents/Resources/applications/Stalker/models/anyjson.py

Re: [web2py] Re: One last thing

2011-02-21 Thread Jack Lyons
Plumo- Web2Py is using 2.5.1, I have 2.7 on my computer. On Mon, Feb 21, 2011 at 6:13 PM, Jack Lyons jacklyons...@gmail.com wrote: Jonathan- When I tried to put that in my script, I got this error message: Traceback (most recent call last): File gluon/restricted.py, line 188

Re: [web2py] Re: One last thing

2011-02-21 Thread Jack Lyons
That fixed that problem, but I am now back to my original error: No supported JSON Module Found On Mon, Feb 21, 2011 at 6:16 PM, Jonathan Lundell jlund...@pobox.comwrote: On Feb 21, 2011, at 3:13 PM, Jack Lyons wrote: When I tried to put that in my script, I got this error message

Re: [web2py] Python Versions

2011-02-20 Thread Jack Lyons
URGENTLY! How do I change the python version that web2py uses? I have 2.6.6 installed on my computer, however web2py is using 2.5.1 PS I am using Mac OS X Snow Leopard Thanks, -- Jack -- Peace ┌─┐ ─┐☮ │▒│ /▒/ │▒│/▒/ │▒ /▒/─┬─┐ │▒│▒|▒│▒│ ┌┴─┴─┐-┘─┘ │▒┌──┘▒▒▒│ └┐▒▒“”

Re: [web2py] Python Versions

2011-02-20 Thread Jack Lyons
I am not running from the source. On Sun, Feb 20, 2011 at 3:52 PM, Jack Lyons jacklyons...@gmail.com wrote: This does not work. Any other suggestions? On Sun, Feb 20, 2011 at 3:41 PM, Bruno Rocha rochacbr...@gmail.comwrote: From MacOs terminal run $python2.6 web2py.py -- Bruno Rocha

Re: [web2py] Python Versions

2011-02-20 Thread Jack Lyons
I have it running from the source now, but it says that there is no module named gluon.widget On Sun, Feb 20, 2011 at 3:59 PM, Jonathan Lundell jlund...@pobox.comwrote: On Feb 20, 2011, at 12:53 PM, Jack Lyons wrote: I am not running from the source. You'll need to run from the source

Re: [web2py] Python Versions

2011-02-20 Thread Jack Lyons
. Any help would be greatly appreciated. On Sun, Feb 20, 2011 at 4:04 PM, Jonathan Lundell jlund...@pobox.comwrote: On Feb 20, 2011, at 1:02 PM, Jack Lyons wrote: I have it running from the source now, but it says that there is no module named gluon.widget What command are you using, and what