[web2py] Size of SQLFORM.grid items

2016-06-13 Thread Jitun John
Above is a simple SQL.grid I have used. I added "headers={'store_log_stats.cluster_name' : 'Cluster__Name'}," to make sure that the column

[web2py] Re: Is this project a good fit for web2py, and if so, what other frameworks will I need?

2016-03-19 Thread John Gall
OSX install if that would > help you. It's a bit raw (doesn't actually run yet, I just use it for > reference), but I could post it if it would help. > > On Saturday, March 19, 2016 at 12:22:55 PM UTC-7, John Gall wrote: >> >> Hello! >> >> I&#x

[web2py] Is this project a good fit for web2py, and if so, what other frameworks will I need?

2016-03-19 Thread John Gall
Hello! I'm starting a new project I plan to work on over the next six months, and I originally planned to use web2py in conjunction with other frameworks to accomplish my goal. I've been told that this project is not possible with web2py, and I wanted to get an opinion from someone who has work

[web2py] Looping over applications

2016-03-15 Thread Bob St John
This is not a problem, but I would like to confirm that this pseudo code is best practice. I have a single instance of web2py (2.13.4) with multiple applications, each application has its own MySQL database. 'init' is my control application which I use for administration. In 'init' I want to a

[web2py] Re: Rows not releasing all the memory back

2016-02-18 Thread Jitun John
Issue is kind of resolved. I created a dummy.. small sqlite file and read that sqlite the same way as large ones are done. and then do for row in some_rows.exclude(lambda row: row.id > 0) again. This tends to free up memory. -- Resources: - http://web2py.com - http://web2py.com/book (Document

[web2py] Re: Rows not releasing all the memory back

2016-02-11 Thread Jitun John
I am using to remove rows... for row in alerts_rows.exclude(lambda row: row.id > 0): pass On Friday, February 12, 2016 at 5:49:38 AM UTC+5:30, Alfonso Serra wrote: > > You can try "del rows" to remove the reference from memory before > collecting > del a single row raises a TypeError but d

[web2py] Re: Rows not releasing all the memory back

2016-02-09 Thread Jitun John
I believe it is caching everything to memory. Here is the code I have. But yes, not a web2py issue. def read_manager_rows(): manager_db_conn = DAL('sqlite://manager.sqlite', folder=get_current_path(), auto_import=True) global manager_rows manager_rows = manager_db_conn(manager_db_conn

[web2py] Rows not releasing all the memory back

2016-02-04 Thread Jitun John
My application, basically parses log files and presents that using web2py So each flat file is read line by line and inserted to a sqlite file. I use a global variable rows to read complete sqlite files later and do various filters and present data. So after creating rows as a global variable, wh

[web2py] extjs running on web2py

2016-01-27 Thread john sitjar
Good day sir's I would like to ask if we have a tutorial on how to run an extj s6 application using web2py.thanks, I hope for your reply -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/i

[web2py] Re: web2py 2.13.3 is OUT

2016-01-27 Thread john sitjar
Good day sir I am new to web2py and extjs 6,I would like to ask if you have a tutorial on how to run an Extjs 6 app using web2py.thanks On Thursday, December 24, 2015 at 11:21:42 PM UTC+8, Massimo Di Pierro wrote: > > web2py 2.13.3 is out. MERRY CHRISTMAS EVERYBODY!!! > > It contains some bug fi

[web2py] extjs6 how to run using web2py

2016-01-27 Thread john sitjar
good day i would like to ask on how to run an extjs6 application using web2py,with the database connection on oracle? plz help tnx -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/

[web2py] Re: using custom upload button when using SQLFORM

2016-01-02 Thread Jitun John
Hi Anthony, I would prefer the last option to replace the upload element. But even after reading "Server-side DOM and parsing" a few times I am unable to comprehend it. I guess we would like to replace with It would be kind of you to just give me an example of the code. Thanks a Lot. On Wedn

[web2py] Re: using custom upload button when using SQLFORM

2015-12-14 Thread Jitun John
Here is the Code from the Model defining the table db.define_table('logs_db', Field('case_num'), Field('case_desc'), Field('log_gen_time', writable=False, readable=False), Field('log_uniq_name', writable=False, readable=False, unique

[web2py] using custom upload button when using SQLFORM

2015-12-13 Thread Jitun John
I was trying to replace the Normal Upload button in {{form}} with a button with nice jquery Browse/File button I can see the view correctly, but the Submit button does not Submit the fields to the Database. Following is the code I am trying > > > > method="post"> > > > > > id="logs_db_c

Re: [web2py] Need help with inno Plugin/Web2pyPackagingApp

2015-12-11 Thread Jitun John
Thanks for the reply Massimiliano. You were correct. That needed a change. That brought up the myapp/default/inno interface. But it looks like the inno.py has lot more issues. Some files needed change Source: "tcl\*"; DestDir: "{app}\tcl"; Flags: ignoreversion recursesubdirs createallsubdirs So

[web2py] Need help with inno Plugin/Web2pyPackagingApp

2015-12-11 Thread Jitun John
Hi, I am using Web2pyPackagingApp to build a binary distribution of the app. I have searched for the"inno plugin" on the web.. but cant find anything. 1. Download and install the inno plugin into your web2py development environment. So I thought it might be the "inno.py" file provided in

[web2py] Re: Unable to make primary/unique

2015-12-10 Thread Jitun John
t with nice error messages displayed in the > form, you must use validators, documented in the Forms chapter. In this > case, you want requires=IS_NOT_IN_DB(...). > > Anthony > > On Thursday, December 10, 2015 at 12:58:28 PM UTC-5, Jitun John wrote: >> >> Hi, >> >&

[web2py] Unable to make primary/unique

2015-12-10 Thread Jitun John
Hi, I am trying to create a table which accepts log files. One of the entries that should be unique is log path. No Duplicate entries. db.define_table('logs_db', Field('case_num', requires=IS_NOT_EMPTY()), Field('case_desc',), Field('log_gen_time',

[web2py] Re: Using apsw with web2py

2015-12-09 Thread Jitun John
lative import. > > Massimo > > > > On Monday, 7 December 2015 17:03:36 UTC-6, Jitun John wrote: >> >> >> Hi I am an amateur programmer and new to web2py. >> >> I have written python scripts with apsw imported. ( >> http://rogerbinns.github.io

[web2py] Is it possible to use APSW or have a similar feature

2015-12-07 Thread Jitun John
Hi, I am new to web2py and am an amateur programmer. I have working python script with APSW imported. (http://rogerbinns.github.io/apsw/) I wanted to make use of the same script in web2py. But I guess I cannot import it in the module. (apsw works with 2.x version of python as well though) Wanted

[web2py] Using apsw with web2py

2015-12-07 Thread Jitun John
Hi I am an amateur programmer and new to web2py. I have written python scripts with apsw imported. (http://rogerbinns.github.io/apsw/) It allows me to create a db in the memory and once all processing/insertion is done, one can backup the date to an .sqlite file on the disk. This .sqlite file c

[web2py] Redirect url with jqmobile

2015-10-29 Thread John Habermann
Hi I have a web2py application that I have recently upgraded to version 2.12.3 and have been working on converting it to use the jqmobile plugin. I have run into an issue with form submission due to the url not changing when you submit a form so rather than load the page specified by the red

[web2py] Re: Filtering a set of items from a collection issues

2015-10-14 Thread John Smidt
That worked! Thanks for the quick help! On Tuesday, October 13, 2015 at 9:52:47 PM UTC-6, Anthony wrote: > > > > On Tuesday, October 13, 2015 at 12:21:10 PM UTC-4, John Smidt wrote: >> >> Ok, I get how the IS_IN_SET needs a filtered set as the first argument >> b

[web2py] Re: Filtering a set of items from a collection issues

2015-10-13 Thread John Smidt
IS_IN_DB( > db(db.geo_item.f_collection_id == current_collection_id), > db.geo_item.id, ...) > > You'll have to set current_collection_id to the appropriate value. > > Anthony > > > > > On Monday, October 12, 2015 at 12:54:03 PM UTC-4, John Smidt wrote: >> >&g

[web2py] Filtering a set of items from a collection issues

2015-10-12 Thread John Smidt
Hi, I am trying to populate a drop down box so that a user may choose a "featured Image" from a collection of images. There are multiple collections, so I need to filter out the other images that are in the different collections. The code I have is shown below: db.geo_collection.f_featured_img.

[web2py] IS_IN_DB validation error

2015-10-01 Thread John Smidt
IS_IN_DB to IS_IN_SET, but received an error stating that " 'Query' object does not support indexing". Any information would be greatly appreciated. Thank you, John -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2p

[web2py] Form misalignment with bootstrap3_inline

2015-08-14 Thread Bob St John
Using web2py 2.12.2 with formstyle = bootstrap3_inline Problem: When displaying a SQLFORM with readonly=True the field labels and values do not line up horizontally. I have a screen image, but the following gives you an idea of what it looks like... Bob First Name

[web2py] Re: sessions piling up

2015-08-13 Thread Bob St John
On Monday, August 10, 2015 at 8:44:40 AM UTC-7, Massimo Di Pierro wrote: > > You seem to have an old version of session2strash.py. The new one only > uses self.expiration and not expiration. > > On Sunday, 9 August 2015 10:15:57 UTC-5, Bob St John wrote: >> >> Using

[web2py] sessions piling up

2015-08-09 Thread Bob St John
Using 2.12.1 I run a small site... about 200 members who login (some using the 'Remember me for 30 days') plus about 1500 public visitors per day. The sessions are stored in the file system. I run the sessions2trash.py script once a day. I have noticed the sessions are increasing by about 1000

[web2py] Re: Customizing registration fields for linkedin login

2015-05-29 Thread John Costantino
Just giving this a Bump. Would really love a resolution to this one. Thanks guys. On Wednesday, May 13, 2015 at 10:28:43 AM UTC-4, John Costantino wrote: > > Yes, that is correct. I added extra fields using the > auth.settings.extra_fields['']. > So the table is able to

[web2py] Give hidden form field an id attribute

2015-05-13 Thread John Lofgren
) ' >>> f.hidden_fields().element('input[name=interval]')['_id'] = 'form_interval' >>> f.hidden_fields().element('input[name=interval]').xml() '' I have assigned id's to other fields in the form using f.custom.widget..u

[web2py] Re: Customizing registration fields for linkedin login

2015-05-13 Thread John Costantino
Yes, that is correct. I added extra fields using the auth.settings.extra_fields['']. So the table is able to support the extra ones I need. My issue is more so with making sure that when logging with the linkedin API. I need to be sure to get the rest of the information from the API, such as th

Re: [web2py] web2ruby possible?

2015-05-13 Thread John
+1 воскресенье, 11 сентября 2011 г., 23:35:56 UTC+3 пользователь rochacbruno написал: > > I am more interested in some web2go http://golang.org/ -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/

[web2py] Customizing registration Fields for Linkedin API log in.

2015-05-12 Thread John Costantino
I have gotten the linkedin Log in functioning properly. However when I register a use I would like to take in a few extra fields from that user. Is it possible to me to perhaps create mappings to specific fields in my DB to the attributes I will be pulling from the API call on registration? --

[web2py] Customizing registration fields for linkedin login

2015-05-12 Thread John Costantino
I have my application currently logging in and registering with linkedin. But when I register only a select few fields get filled. (first name, last name, email). I would like to also get the users public-url on registration. I am not sure how to do this. Is it possible for me to custom map spe

[web2py] form misalignment with bootstrap3_inline

2015-05-01 Thread Bob St John
Using web2py version 2.10.4 with response.formstyle=bootstrap3_inline Problem: When using SQLFORM or SQLFORM.grid(view) the form fields whose value is None or when writable=False do not line up horizontally with the label. Solution (or hack): In gluon.sqlhtml.py I added the following elif (about

[web2py] Re: database chema recommendations needed

2015-04-25 Thread John
reference/cite as sources for facts in doing research for building a family tree. Upon further thought, places (State, County, CityTown) be best in it's own table so they each only get stored once. On Tuesday, April 21, 2015 at 10:05:32 AM UTC-5, John wrote: > > New to program

[web2py] database chema recommendations needed

2015-04-21 Thread John
New to programming and web2py. Been dabbling in web design for a while, building sites with wordpress, plugging things in. My first real project will be a site/app for my sister. Genealogical resources. Lots of records that will need to be added via csv and also via forms. Will also need to be

[web2py] admin pointing to wrong static css in rendered page.

2015-03-04 Thread John McMaster
Just installed web2py on webfaction. Used one of the scripts on the webfaction community site. The domain is working. When I try to access the admin/default/index the css is clearly not being used. After using the Inspect Element to see what went wrong you can clearly see that the admin index.h

[web2py] LinkedIn API Please help for the love of god.

2015-03-02 Thread John Costantino
I have been trying to get this to work now for over 3 weeks. I have pulled data with the javascript API no problem but I wan't users to be able to log in using there linkedin accounts. I have tried the way suggested in the book as well as many of the various other implementations on the internet

[web2py] Ajax call issues.

2015-03-01 Thread John Costantino
Hey so I have a mail script written in python which works fine when I run it from a linux terminal. My issue is I need to make an ajax call passing in parameters from a custom form I created. In the Javascript it calls the script but the mail never sends. I am stumped I have been trying to get t

[web2py] py and pyc files

2014-11-11 Thread John Davis
Hello If I get an error in the ticket exception output which shows an error at line x in a .pyc file, can I assume that the corresponding .py file on line x is the error? John -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

Re: [web2py] Re: How to fix error "(No module named configuration)"?

2014-11-11 Thread John Davis
your tips and thank you for your time and expertise, John On Tue, Nov 11, 2014 at 2:08 PM, Leonel Câmara wrote: > Copying the entire web2py directory would work if the module was in the > web2py directory site-packages, but, in that case, it also wouldn't work in > the other serve

[web2py] Re: How to fix error "(No module named configuration)"?

2014-11-11 Thread John Davis
On Tuesday, November 11, 2014 11:41:02 AM UTC-5, Leonel Câmara wrote: > > Does it work if you erase all .pyc files in your application modules > folder and subfolders, restart whatever is running web2py and try again? > I will try that. I'm kind of waiting for the next approach to before I do t

[web2py] import app from one web2py server to another

2014-11-11 Thread John Davis
Hello I have an app written by someone which runs on our server. I have tried to copy this app from one server to a new one which also runs web2py. I use the admin site GUI for web2py to import the app, but when I try to run it, I get the following error. error: (No module named configuratio

[web2py] How to fix error "(No module named configuration)"?

2014-11-11 Thread John Davis
using and works ok there. I used the web2py admin interface to pack and download the app where it was working. Then I uploaded the app on a second server. I get the error on the second server when I try to start it. John -- Resources: - http://web2py.com - http://web2py.com/book (Document

[web2py] Re: populate form with just-submitted values

2014-11-07 Thread John Lofgren
Thanks very much, Leonel! I found that adding keepvalues=True as an argument to form.process() was what I needed. >>> if form.process(keepvalues=True).accepted: ... <<< John On Thursday, November 6, 2014 6:14:56 PM UTC-6, Leonel Câmara wrote: > > FORM has keepv

[web2py] populate form with just-submitted values

2014-11-06 Thread John Lofgren
.dictform? Any suggestions? Thanks, John -- 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

[web2py] SSL configuration with built-in server

2014-10-22 Thread John Lofgren
cert and key in a configuration file instead? 2) When I set the cert and key, does that turn on SSL for every page automatically? Thanks, John -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p

[web2py] LinkedIn API

2014-10-13 Thread John Costantino
Hey everyone I was wondering how to integrate the linkedin API with my web2py application I am currently running it on my local host as it is still in development. I found http://www.web2pyslices.com/slice/show/1541/integrating-linkedin-with-web2py. However I am unsure exactly what to do to get

[web2py] select insert record in shell

2014-09-29 Thread John Frank
i am starting to web2py and using shell for all db related stuff. today i notice a bizarre behavior on db select. Instead of selecting a record, it is insert value of last insert query. am i making any mistake here.. this my shell log: In [5] : for x in row: print x In [6] : db.dog.insert(na

[web2py] Getting "invalid view" when trying to access view as JSON

2014-07-17 Thread John Drake
This is odd. On my local test server I can do something like: http://localhost:8000/myapp/mycontroller/myfunction.json and I get back a JSON document. But when I try the same code on the same application running on Pythonanywhere I get: invalid view (mycontroller/myfunction.json) Just to mak

[web2py] Re: Problems with multiple forms and SQLFORM.grid

2014-06-04 Thread john smith
Yes, it works perfectly now. Here is my function: @auth.requires(auth.has_membership('librarian') or auth.has_membership('admin')) def deletesomething(): db(db.auth_membership.id==request.args(0)).delete() redirect(URL('show_reader', args=request.args(1)), client_side=True) @auth.requires(auth.ha

[web2py] Re: Problems with multiple forms and SQLFORM.grid

2014-06-04 Thread john smith
s for it I found do not work. I get invalid syntax error caused by apostrophes. Anybody have any idea on how to solve it? W dniu wtorek, 3 czerwca 2014 18:18:42 UTC+2 użytkownik john smith napisał: > > Yes, it works if I add writable=False, but I still have to set user_id to > user.id a

[web2py] Re: Problems with multiple forms and SQLFORM.grid

2014-06-03 Thread john smith
ser.id value" > What do you mean are you just trying to hide the id value? like this -> > db.table.id.readable=False ? > > On Sunday, June 1, 2014 9:10:07 AM UTC-5, john smith wrote: >> >> I want to create a page that will display user data, with additional >> c

[web2py] Re: Problems with multiple forms and SQLFORM.grid

2014-06-03 Thread john smith
(_type='submit')) > if form2.process(formname='SomeName').accepted: > redirect(URL('index')) > On Sunday, June 1, 2014 9:10:07 AM UTC-5, john smith wrote: >> >> I want to create a page that will display user data, with additional >> contro

[web2py] Re: Problems with multiple forms and SQLFORM.grid

2014-06-03 Thread john smith
Can anybody help me? I still can't figure it out on my own... W dniu niedziela, 1 czerwca 2014 16:10:07 UTC+2 użytkownik john smith napisał: > > I want to create a page that will display user data, with additional > controls. I want librarian to be able to add user to '

[web2py] Problems with multiple forms and SQLFORM.grid

2014-06-01 Thread john smith
I want to create a page that will display user data, with additional controls. I want librarian to be able to add user to 'readers' and remove group, that part works. I also want admin be able to freely manage groups of a user, I want him to have a widget that will have a list of groups with s

[web2py] Re: Can't set registration_key

2014-05-25 Thread john smith
)).update( > registration_key='') > return locals() > > Anthony > > On Sunday, May 25, 2014 8:45:56 AM UTC-4, john smith wrote: >> >> I set my app to require registration approval and cannot set the >> registration_key programmatically. I

[web2py] Can't set registration_key

2014-05-25 Thread john smith
I set my app to require registration approval and cannot set the registration_key programmatically. I can set it through appadmin interface. Here is my code: @auth.requires_membership('librarian') def show_reader(): user = db.auth_user(request.args(0, cast=int)) form=FORM(INPUT(_type='sub

[web2py] Re: Simple loan system for library

2014-05-24 Thread john smith
g comes to my mind right now. If that is not what you meant, then I have no idea. I should add that this is a school project so I can change it pretty much any way I like it. If you have better idea on how to create renting system then please do tell. W dniu sobota, 24 maja 2014 04:51:00 UTC+2

[web2py] Simple loan system for library

2014-05-23 Thread john smith
I'm trying to create library system and have a little problem. Here's my current model: db.define_table('tags', Field('name'),format='%(name)s') db.define_table('copies', Field('is_active','boolean',default=True)) db.define_table('book', Field('title',requires=IS_NOT_EMPTY(), label='Tytuł')

Re: [web2py] if statement always true in view

2014-05-04 Thread john smith
Well, that was obvious:/ Thanks for help, works perfectly now. W dniu niedziela, 4 maja 2014 09:52:12 UTC+2 użytkownik Marin Pranjić napisał: > > You have a typo in there. funciton should be function. > > That's why it always returns None. > > > Marin > > > O

[web2py] Strange ajax problem

2014-05-04 Thread John Drake
I've created a simple ajax form to update a "post" database. For some strange reason when I post a new message, the button greys out. Here is the model: db.define_table('t_post', Field('f_post', type='text', label=T('Post')), auth.signature, format='%(f_post)s') Here are

[web2py] if statement always true in view

2014-05-03 Thread john smith
Hello! I have a problem with 'reddit-clone' app from this tutorial. I'm stuck at moment in 2:28:00. My problem is with if statement that is supposed to change the button responsible for changing the view. For me the condition is always false, even though when printed, the request.function shows

[web2py] SQLFORM.grid search fields

2014-04-17 Thread John Fraser
How would one go about making certain fields readable (visible) to the search, view, edit, etc, but hidden from the actual grid. Below is my code that accomplishes the hiding the fields from the main grid, but struggling with making them readable to the search: @auth.requires_login() def index

Re: [web2py] Re: SQLFORM.grid Export and represent

2014-04-16 Thread John Fraser
1:29:30 PM UTC-4, Cliff Kachinske wrote: > >> There must be something in the request that indicates you want csv or tsv. >> >> If it's in the request.args, for example, something like this would work: >> >> if 'csv' not in request.args and 'tsv

[web2py] SQLFORM.grid Export and represent

2014-04-16 Thread John Fraser
Is there an easy way to strip HTML markup from SQLFORM.grid's CSV/TSV export? I realize I probably need to create a custom export function, but curious if there is an argument or a one liner that would do the trick. Or is there a better way to format the display? I have the following controll

Re: [web2py] using limitby in query for SQLFORM grid

2014-03-04 Thread John Philip
thanks and regards, John db().select(db.person.ALL, limitby=(0, 2)) On Tuesday, March 4, 2014 1:35:23 PM UTC+1, Kiran Subbaraman wrote: > > paginate should work. > http://web2py.com/books/default/search/29?search=paginate > > _

[web2py] using limitby in query for SQLFORM grid

2014-03-04 Thread John Philip
ppreciated. passlist = (db.nextpasses.BOT>=windowTT) sgrid = SQLFORM.grid(passlist) many thanks, John -- 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

[web2py] Re: How to schedule a task to run at the same time every day

2014-02-21 Thread John Felps
t of the current 2.8.2. You can check out web2py from google > code or github if you'd like to use it now - keeping in mind that you'll be > using a devel version that might include some less tested code, of course. > > Regards > > > On Friday, February 21, 2014 4:5

[web2py] Re: How to schedule a task to run at the same time every day

2014-02-21 Thread John Felps
Can I use it on the page appadmin/insert/db/scheduler_task? If so, where does it go? There are no fields called "trunk" On Friday, February 21, 2014 8:47:15 AM UTC-7, Niphlod wrote: > > it's a parameter (available in trunk), not an argument. > > On Friday, February 21,

[web2py] Re: How to schedule a task to run at the same time every day

2014-02-21 Thread John Felps
> > See http://web2py.com/books/default/chapter/29/04/the-core#Scheduler. > > Anthony > > On Friday, February 21, 2014 9:54:09 AM UTC-5, John Felps wrote: >> >> I have a daily task, scheduled for midnight, with a repeat of 0 and a >> period of 86400 that ha

[web2py] How to schedule a task to run at the same time every day

2014-02-21 Thread John Felps
I have a daily task, scheduled for midnight, with a repeat of 0 and a period of 86400 that has been running daily for about a month, but over time it has drifted so that it starts at nearly 4 am. How do I just tell the task to always start at midnight? -- Resources: - http://web2py.com - http:

[web2py] Re: creating a model of a table (with a large amount of data) in a mysql db. is taking a very long time

2014-02-20 Thread John Philip
ry 15 minutes) from a running application. regards. John On Wednesday, February 19, 2014 7:27:25 PM UTC+1, Derek wrote: > > I doubt that the name of it is an issue. > datetime is not in the reserved list. > > > http://web2py.com/examples/static/epydoc/web2py.gluon.reserved_

[web2py] Re: creating a model of a table (with a large amount of data) in a mysql db. is taking a very long time

2014-02-19 Thread John Philip
on varchar(11) severity enum('INFORMATION','WARNING','ERROR', 'FATAL') typeenum('SYSTEM','SOFTWARE','MIB','LOG') message varchar(432) PK thanks again for your help! John

[web2py] creating a model of a table (with a large amount of data) in a mysql db. is taking a very long time

2014-02-18 Thread John Philip
e','text'), primarykey=['datetime']) In theory this should work. However when I run the database administration button to create the models it seems to hang. I suspect because of the amount of data. Since I am only interested in the most recent data is there anyway of

[web2py] Getting the "count" of a rows object.

2014-02-14 Thread John Drake
Hello. I'm having a strange problem. I'm trying to get the count of a rows object from a query. Here is the code: def album_show(): album = db.t_album(request.args(0)) songs = db(db.t_song.f_album_id_reference==album.id).select() count = songs.count() return locals() And here

Re: [web2py] Re: pre-populate form using selected record in SQLFORM.grid

2014-02-12 Thread John Philip
Hi Anthony and Jim, thanks very much for your help. I got it working with Jim suggestion since I only wanted to insert a completely new record with the prepopulated values from the previous sqlgrid form. thanks again! regards, John On Wednesday, February 12, 2014 3:40:27 PM UTC+1, Anthony

[web2py] Re: pre-populate form using selected record in SQLFORM.grid

2014-02-12 Thread John Philip
e I need to pass the values when initiating the lamba project addpass. thanks, John On Tuesday, February 11, 2014 10:16:28 PM UTC+1, Jim S wrote: > > Try setting the defaults on the respective fields: > > db.nextpasses.field_name.default = default_value_for_this_field > > -Ji

[web2py] pre-populate form using selected record in SQLFORM.grid

2014-02-11 Thread John Philip
s.STATION,db.nextpasses.BOT,db.nextpasses.EOT], maxtextlength=50,headers={'nextpasses.DOY' : 'DOY','nextpasses.STATION' : 'Station', 'nextpasses.BOT' : 'Aos', 'nextpasses.EOT' : 'Los'}) Any help would be greatly appreciate

[web2py] Web2py License

2014-01-23 Thread John Catalano
We are in an opensource shy team that is very concerned about licensing. I see that the Web2py license is LGPL3, but does Web2py carry any other license implications such as GPL, GPL2 in it's parts? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/

[web2py] Re: Web2py on Mavericks - sqlite problem

2013-12-14 Thread John Zumsteg
I found the problem in a totally unexpected place. I am running the apps on Chrome, and had Firebug Lite installed. For the heck of it, I disabled Firebug, and all came back. John On Saturday, December 14, 2013 10:06:33 AM UTC-8, John Zumsteg wrote: > > I have several web2py apps that

[web2py] Web2py on Mavericks - sqlite problem

2013-12-14 Thread John Zumsteg
ciate any trouble-shooting insights and directions. Thanks, John -- 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 yo

[web2py] Re: Import error for requests

2013-12-13 Thread John Zumsteg
it in the site-packages folder should make it universally available to any web2py application. I guess I need more knowledge about how all this works, but for now, I can go forward. John On Thursday, December 12, 2013 8:26:49 AM UTC-8, John Zumsteg wrote: > > I have a controller that doe

[web2py] Import error for requests

2013-12-12 Thread John Zumsteg
I have a controller that does an *import requests. *I get the message "Cannot import module 'requests'" when trying to run it. I installed Requests using pip install, and /Library/Python/2.7/site-packages/ contains *requests-2.1.0-py2.7.egg*. I can import requests from the Python2.7 interpret

[web2py] Re: Question on EMTE and websockets

2013-12-08 Thread John Griffith
Did you get this fixed? On Saturday, 8 June 2013 14:52:08 UTC+1, george3825 wrote: > > Hello, > > I have been trying to get the EMTE engine up and running. So far I have > gotten the matchingserver, robottrader, and the log parsers to work and > even into a MySQL DB. I have been stuck on gettin

[web2py] EMTE product URL

2013-12-06 Thread John Griffith
e P&L page. Thank you very much, John -- 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 t

[web2py] Web2py, EMTE

2013-12-06 Thread John Griffith
work. By leaving these fields blank or incorrect the engine does not recive the price data. When on the P&L section an error is always called, I suspect is due to the URLS not being properly setup. Thank you again, John -- Resources: - http://web2py.com - http://web2py.com/book (Documen

Re: [web2py] Re: comma in html filename causing invalid request

2013-11-13 Thread John Felps
e... I just remember the old > not written rules... You do what you want... > > > On Tue, Nov 12, 2013 at 9:34 AM, John Felps > > wrote: > >> Why? RFC 1738 states "Thus, only alphanumerics, the special characters >> "$-_.+!*'(),", and rese

[web2py] Re: comma in html filename causing invalid request

2013-11-13 Thread John Felps
ange the names of the > files to have no commas, static files are not user uploads, and should be > controlled by you. > > > Segunda-feira, 11 de Novembro de 2013 15:29:34 UTC, John Felps escreveu: >> >> I have edited routes.parametric.example.py and saved as web2py/

[web2py] comma in html filename causing invalid request

2013-11-11 Thread John Felps
I have edited routes.parametric.example.py and saved as web2py/routes.py with the default application as myapp. I have some html files in static that now can be accessed as http://ip/myapp/static/dir/test.html or http://ip/static/dir/test.html however, a couple of files have commas in the fil

[web2py] Re: SQLFORM with multiple buttons how to differentiate

2013-10-31 Thread John Felps
OK, thanks. I found a workaround; by naming each button differently and instead of checking the value, just check for name in request.vars. On Wednesday, October 30, 2013 6:30:53 PM UTC-6, John Felps wrote: > > I have an sqlform that populates from a db and has several submit buttons &

[web2py] SQLFORM with multiple buttons how to differentiate

2013-10-30 Thread John Felps
I have an sqlform that populates from a db and has several submit buttons named test with different _values (and appear with different names on the screen). In PHP, the post['test'] would be equal to the button value, however, request.vars includes test, but it is always "Working..." on submiss

[web2py] Why is button value always set to "working..." in request.args

2013-10-30 Thread John Felps
I have an SQLFORM that populates from a database and that has buttons set to buttons = [TAG.button('1', _name='test'), TAG.button('2', _name='test'), TAG.button('3', _name='test'), TAG.button('4', _name='test')] and when I look at the form.va

[web2py] initiating python scraper in web2py

2013-09-04 Thread John Philip
can best implement this? many thanks! John Enter codimport sqlite3 from bs4 import BeautifulSoup from urllib2 import urlopen #Py 3: use urllib.request from datetime import datetime, timedelta myAddress = "http://xx.xx.xxx.58/xxx/schedule/CRY.html"; htmlPage = urlopen(myAddress

[web2py] questions on SQLFORM.grid (new web2py user)

2013-09-02 Thread John Philip
( with custom format : %d-%m-%Y %H:%M:%S) in gridview. However this is a problem when searching since the grid expects the %Y-%m-%d ... format. Is it possible to convert the search format? many thanks! John -- --- You received this message because you are subscribed to the Google Groups

[web2py] Re: how to iterate over a db.select in default.html

2013-07-26 Thread John Stricker
; > #iterate over tags row and create the list of links > for t in tags: > taglist += "" + > t.name + "" > #add closing tag at the end > taglist += "" > return XML(taglist) > > > > On Friday, July 26, 2013

[web2py] how to iterate over a db.select in default.html

2013-07-26 Thread John Stricker
I'm trying to display unique entry tags on all pages of a website in a bar on the left side. It seems the best place to put this info is in the 'default.html', which could call a function using LOAD. So in the controller i have: def getTags(): """get a list of distinct entry tags""" r

[web2py] Re: Nested JSON vs Single JSON dataset

2013-06-19 Thread John Payne
Alan, that did exacltly what i needed! This allows me to return a singular joined object that i can feed to slickgrid<https://github.com/mleibman/SlickGrid> . Thanks! On Wednesday, June 19, 2013 8:50:18 AM UTC-8, John Payne wrote: > > Thanks Alan, I'll give this a t

<    1   2   3   4   >