[web2py:21155] Re: Validation in Custom Form using crud

2009-05-04 Thread John Heenan
eturn dict(form=crud()) Depending on what the crud form action is as determined from parsing request.env.path_info use the approach in http://mdp.cti.depaul.edu/AlterEgo/default/show/205 to determine how to layout the crud form {{pass}} John Heenan On May 5, 12:19 am, John Heenan wrote: >

[web2py:21186] Re: Validation in Custom Form using crud

2009-05-04 Thread John Heenan
f form.accept test is conducted. If the test passes data is saved ot the database. If the test fails the form is shown again with indications of where validation failed. If validation fails then forms.error is filled in and is used to populate the error DIVs. > Thank you. Your welcome John

[web2py:21734] Webfaction + web2py question

2009-05-12 Thread John Pontious
I have been attempting to get web2py up and running on webfaction. And, based on the nice writeups I have found, I think I am pretty close. For reference, I followed: http://mdp.cti.depaul.edu/AlterEgo/default/show/202 With my current configuration, I am able to access my web2py app: http://myh

[web2py:21939] CAS question(s)

2009-05-16 Thread John Pontious
I am evaluating CAS for inclusion in a project I am working on, and I am running into a couple of problems. I seem to be having a problem with the model name "email.py", because at least in my environment if it getting loaded before the normal email python module. So, when I attempt to test just

[web2py] Re: edit the book, get a free book

2010-11-19 Thread John Kim
to the spreadsheet after Massimo suggested I just edit the book directly... I'm sure to mark more as I finish the book, too. When should I try to finish reading the book by? ^^ John On Nov 19, 4:26 pm, Branko Vukelic wrote: > On Fri, Nov 19, 2010 at 6:53 AM, mdipierro wrote: > >

[web2py] Re: edit the book, get a free book

2010-11-19 Thread John Kim
uWSGI officially supported? I was wondering how it compares to FastCGI: - uWSGI seems faster - however some people ran into issues using uWSGI; were those resolved? John-Kim On Nov 19, 9:48 pm, John Kim wrote: > I suggest FogBugz for tracking > bugs:http://www.fogcreek.com/fogbugz/StudentAndS

[web2py] Re: jqgrid plugin display data from multiple tables

2010-12-01 Thread John Heenan
back from web2py and then 3) updates the slave jqgrid table. If this is what you want to do, then working through jqgrid documentation and examples will help. John Heenan On Dec 1, 8:45 pm, Neveen Adel wrote: > Hello, > >  Is there a way to make jqgrid  plugin to display data fro

[web2py] Re: Scalability of web2py?

2010-12-01 Thread John Heenan
just does not sink in. I even pointed out how Linux loast a PR war over this issue. There is no need for Python based web frameworks to use thread per request web serving. John Heenan On Nov 30, 4:05 am, mdipierro wrote: > You achieve scalability by replicating the web server behind a l

[web2py] Re: Scalability of web2py?

2010-12-01 Thread John Heenan
real-time, distributed, and highly-available apps. > > Here's an example (maybe quoted one time too often): > > http://www.sics.se/~joe/apachevsyaws.html > > > > On Wed, Dec 1, 2010 at 6:45 PM, John Heenan wrote: > > The elephant in the room has not gone away Mas

[web2py] Re: Scalability of web2py?

2010-12-01 Thread John Heenan
s he has had enough or wants to wind down, 'offcial' Linux continues on. A professional approach requires hard fact and a serious approach to legitimate issues that at the very least acknowledges legitimate issues and avoids propaganda. Hard facts requires real world tests, not evasion, de

[web2py] Re: Scalability of web2py?

2010-12-01 Thread John Heenan
erged into another, where Torvalds is said to play a key role. In addition, the growing acceleration of kernel development has increased the time Torvalds spends reviewing other kernel changes." John Heenan On Dec 2, 11:39 am, John Heenan wrote: > The OP, Lorin, asked "What's the &

[web2py] Re: Scalability of web2py?

2010-12-02 Thread John Heenan
r maintains a thread for each request, this means that each server needs to be able to maintain nearly 114 threads per server at once. I am not impressed by this. Consider that Lighttpd can handle 10,000 requests per second ON A SINGLE SERVER using year 2000 technology. John Heenan On Dec 2, 9:46 p

[web2py] Re: web2py themes - feeling nostalgic?

2010-12-08 Thread John Kim
it can't be seen! This property was inherited from div#request_hidden (base.css:232). The information becomes visible if I uncheck this property from Chrome developer tools. How should this be fixed? Is there a reason the CSS file sets the visibility to hidden? John-Kim On Dec 8, 4:39 am,

[web2py] Pyfpdf landscape printing

2012-07-19 Thread John Zumsteg
I use pyfpdf to generate a landscape report in a web2py app. The report generates a pdf which appears correctly in a browser window, but when I try to print it, the landscape report is on a portrait page. This means, of course, that it doesn't fit: the right side runs off the page. This occur

[web2py] Printing a landscape report from pyfpdf

2012-07-19 Thread John Zumsteg
I use pyfpdf to generate a landscape report. The report generates a pdf which appears correctly in a browser window, but when I try to print it, the landscape report is on a portrait page. This means, of course, that it doesn't fit: the right side runs off the page. This occurs when trying to print

[web2py] Table and form on the same view

2012-07-28 Thread John Zumsteg
. Thanks, John --

[web2py] textarea word counter

2013-02-27 Thread John Ho
I would like to count the words as entered into the textareas of SQLFORM form. I've found several jQuery scripts, but couldn't get them to work yet. Any recommendations for such scripts? I think this would be a nice feature to add into web2py. -- --- You received this message because you a

[web2py] Re: textarea word counter

2013-02-28 Thread John Ho
Thanks that works great. On Wednesday, February 27, 2013 7:43:43 AM UTC-8, Massimo Di Pierro wrote: > > > > > > > jQuery('#source').change(function(){jQuery('#target').html(jQuery('#source').val().match(/\S+/g).length);}) > > >

[web2py] Re: web2py is moving

2013-03-01 Thread John Ho
The link to the online engish book is broken (Invalid request). On Thursday, February 28, 2013 3:40:22 PM UTC-8, Massimo Di Pierro wrote: > > web2py.com is moving to pythonanywhere.com. There may be disruptions but > we hope not. > > -- --- You received this message because you are subscribe

[web2py] Re: Version 2.4.4 Bug?

2013-03-14 Thread John Gellene
I found the same problem and solved it by deleting the ./compiled folder in the installed web2py source. Perhaps that folder may have been from the earlier version, it is not created when the 2.4.4 source archive is expanded. On Wednesday, March 13, 2013 8:35:22 AM UTC-4, Jyoti Sharma wrote: >

[web2py] How to get a filter subset?

2012-11-14 Thread John Ho
For a school admin database, different roles for logged in users: admin, teachers and staff. I can use using auth_group and auth_membership to define these roles. I have the following table: db.define_table( "class", Field("teacher_id", db.auth_user), ...) want a form to create a new class,

[web2py] Re: How to get a filter subset?

2012-11-17 Thread John Ho
Thanks. On Tuesday, November 13, 2012 9:04:44 AM UTC-8, John Ho wrote: > > For a school admin database, different roles for logged in users: admin, > teachers and staff. I can use using auth_group and auth_membership to > define these roles. > > I have t

[web2py] Cron on FluxFlex

2011-12-16 Thread John Oliva
Is it possible to use either hard or external cron on fluxflex.com or is soft cron the only option? Thanks, John

[web2py] Re: Cron on FluxFlex

2011-12-17 Thread John Oliva
Thanks Alan.

[web2py] Serving dynamic HTML files

2011-11-01 Thread John Duddy
I'm creating an app that runs external programs, which produce HTML reports. These reports are produced outside the static directory, but I want the user to be able to browse them. Is there a way I can tell web2py to serve those files like it does static files? All the links in the HTML files are

[web2py] Re: Serving dynamic HTML files

2011-11-01 Thread John Duddy
ink this is what you are looking for > :http://web2py.com/book/default/chapter/12#Fetching-an-external-URL > > Richard > > > > > > > > On Tue, Nov 1, 2011 at 3:08 PM, John Duddy wrote: > > I'm creating an app that runs external programs, which produce HTML

[web2py] Re: Serving dynamic HTML files

2011-11-01 Thread John Duddy
Unfortunately, no. I might be able to create soft links under static to those directories, making up a guid each time for the name. I was hoping for a more elegant solution. On Nov 1, 12:42 pm, Anthony wrote: > On Tuesday, November 1, 2011 3:08:10 PM UTC-4, John Duddy wrote: > > >

[web2py] Re: Serving dynamic HTML files

2011-11-02 Thread John Duddy
These files can appear ANYWHERE on the file system. I do not know in advance, as the user can add directories for the input (and output) data at runtime via configuration. So, I need a fully dynamic solution that I can tweak programmatically at runtime. Your solution (creating links under a path s

[web2py] Re: Serving dynamic HTML files

2011-11-02 Thread John Duddy
:54 pm, Anthony wrote: > On Tuesday, November 1, 2011 5:48:12 PM UTC-4, John Duddy wrote: > > > Unfortunately, no. I might be able to create soft links under static > > to those directories, making up a guid each time for the name. I was > > hoping for a more elegant so

[web2py] Re: Serving dynamic HTML files

2011-11-02 Thread John Duddy
That's cool - I'll definitely consider it. Thanks! On Nov 2, 10:03 am, ~redShadow~ wrote: > On Wed, 2011-11-02 at 09:25 -0700, John Duddy wrote: > > Certainly there is s simpler way to talk to an already running > > instance of rocket (mine) and tell it to serve more

[web2py] DAL caching values automatically?

2011-11-16 Thread John Duddy
I have a config table, and I query for values like this from a cron program: db(db.config.name=='api_key').select(db.config.value).first().value This query always returns the same value, even after I change it via the admin app's database editor. Is the DAL doing some sort of caching? Is there a

[web2py] Re: DAL caching values automatically?

2011-11-17 Thread John Duddy
I think you may have nailed it - my cron does run continuously. I always commit my transactions. Do you know how to force it to reset manually? On Nov 16, 9:17 pm, nick name wrote: > Does your cron program run continuously? what database are you using? > > If you are using a database that suppor

[web2py] Re: DAL caching values automatically?

2011-11-18 Thread John Duddy
This solved it (in models/db.py): db.executesql('SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;') Muchas gracias, nick On Nov 17, 12:09 pm, John Duddy wrote: > I think you may have nailed it - my cron does run continuously. > > I always commit my transactions.

[web2py] Re: can web2py "internal webserver" handle serveral requests in parallel?

2011-03-24 Thread John Heenan
e place queues or locks occur. IO (input-output) OS (operating systems) queues or locks are very common and are hidden. I hope this adds a bit more insight. John Heenan

[web2py] Re: relational database example app

2011-06-25 Thread john mahugu
Stifan Kristi writes: > > had already checked web2py appliances? http://web2py.com/appliances > > On Wed, May 25, 2011 at 1:19 PM, Markandeya wrote: > > Dear Friends of Web2Py, > I am just getting started and need an example application using a > relational database. A possible example: > 1)

[web2py] cron "Too many open files" regression?

2011-07-05 Thread John Duddy
I'm getting the following stack trace in my console after leaving my app running overnight. We use cron for several tasks. I saw the below thread, which indicated that the issue has been resolved: http://groups.google.com/group/web2py/browse_thread/thread/e788b0783e8fc758/6a210abb2898763d?lnk=rao

Re: [web2py] Re: cron "Too many open files" regression?

2011-07-05 Thread John Duddy
starting a lot of cron tasks that do not terminate before the > next one starts? > I suggest you use a background process and do not use cron. To my > knowledge there is no bug but cron become unpredictable if jobs take > too long. > > > Massimo > > > On Jul 5, 10:3

Re: [web2py] Re: cron "Too many open files" regression?

2011-07-05 Thread John Duddy
). These processes never exit. lsof shows the normal cacaphony of open files, lots of stuff under python2.7, a few shared libs & pipes, cron.master, and a deleted file in / tmp. <http://tmp.cd> Any ideas on how to track this down? On Tue, Jul 5, 2011 at 12:47 PM, John Duddy wrote: > I a

Re: [web2py] Re: cron "Too many open files" regression?

2011-07-06 Thread John Duddy
t; > be possible to make a single script that just runs the 3 scripts > > sequentially and use that as your cron script. Do the scripts access the > > database and the database happens to be SQLite which locks for the > duration > > of an access/ > > > > Without seeing some code and more details determining the cause is a > guess. > > > > Ron > -- John Duddy jdu...@gmail.com

Re: [web2py] cron "Too many open files" regression?

2011-07-06 Thread John Duddy
h also cannot be cleaned up. > > Are you running on Linux? If so the /proc/pid_of_web2py/fd directory using ls > -l will show you what files by name are open to the process which might > provide some clues to which part of your code. > -- John Duddy jdu...@gmail.com

[web2py] Implementing task queue model - need some help

2011-07-27 Thread John Duddy
I'd like to use a cron job running with @reboot to process a queue. What I want in the queue are the names of modules & functions to call, and a time to call them. Here's the catch - I'd like the functions in the queue to be in a controller. Here's where I execute (next is the row with the task q

[web2py] Re: Issues with rendering wiki in html.

2013-05-22 Thread John Fraser
Hi Alan, I updated to the latest mercurial version, just in case... but the issue still persists for me. Not sure what I am doing wrong. Here is my code below: /init/controllers/wiki.py: def index(): response.title = 'Wiki' response.subtitle = 'web2py' return auth.wiki(render='htm

[web2py] Re: Issues with rendering wiki in html.

2013-05-22 Thread John Fraser
I deleted the old page and created a new one with same 'index' slug also tried creating a new page entirely. Also as this maybe important. In my init/model/db.py I have the following after auth tables are defined: auth.wiki(resolve=False) On Wednesday, May 22, 2013 1:08:11 PM UTC-4, Andr

[web2py] Re: Issues with rendering wiki in html.

2013-05-22 Thread John Fraser
That works. Thanks for the help. Makes sense. I forgot about the code in db.py when initially troubleshooting. On Wednesday, May 22, 2013 1:58:00 PM UTC-4, Alan Etkin wrote: > > Also as this maybe important. In my init/model/db.py I have the >> following after auth tables are defined: >> >

[web2py] SQLFORM.grid view

2013-05-30 Thread John Fraser
When storing html in a table, how would one render that html to the SQLFORM.grid view page? . The page the user sees when clicking on the view button in the grid? I am storing HTML in the body field of the db.announcenment. By default it SQLFORM.grid displays tags in the view ,, etc... See

[web2py] Re: SQLFORM.grid view

2013-05-31 Thread John Fraser
ony > > On Thursday, May 30, 2013 10:04:29 PM UTC-4, John Fraser wrote: >> >> When storing html in a table, how would one render that html to the >> SQLFORM.grid view page? . The page the user sees when clicking on the view >> button in the grid? I am storin

[web2py] Problem running web2py with Google Appengine - invalid controller (default/index)

2013-06-05 Thread John Drake
I have been trying for some time now to get an application that I developed using web2py to run on the Google app engine. I tried to follow the web tutorial here: https://www.youtube.com/watch?v=YZTG2IBMXeU but to no avail. The web2py welcome page comes up as expected. But when I try to get t

[web2py] Nested JSON vs Single JSON dataset

2013-06-18 Thread John Payne
Hello, I'm trying to return some data via JSON to my view. The problem i'm having is that when i do a left outer join, the JSON has two nested sets of data. I'm trying to use SlickGrid which doesn't support complex fields like Set1.Field1 , Set2.Field1, etc... Is there a way to return a sing

[web2py] Re: Nested JSON vs Single JSON dataset

2013-06-19 Thread John Payne
Thanks Alan, I'll give this a try and reply back. -- --- 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, v

[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

[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: 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] 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] 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] 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] 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] 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] 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: 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/

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] 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: Size of SQLFORM.grid items

2016-06-14 Thread Jitun John
erwritten for each >field using maxtextlengths, a dictionary of >'tablename.fieldname':length e.g. {'auth_user.email' : 50} > > Anthony > > On Monday, June 13, 2016 at 10:41:15 AM UTC-4, Jitun John wrote: >> >> >&g

[web2py] Loader/waiting indeterminate progressbar

2016-06-16 Thread Jitun John
>From the main page, once a form is submitted, there is heavy python code doing lots of steps which takes from seconds to minutes to finish. It then moves to the next page. Between the 2 pages, I am trying to see if there can be a indication on the HTML page indicating working in background. Som

[web2py] Execute Python code when pressing a button

2016-06-18 Thread John Doe
Hello, i am trying to remotely turn ON/OFF a LED that is connected to a RaspberryPi. I have installed Web2Py on my PC (that is running Ubuntu). Additionaly i have installed Paramiko for my SSH conection. I've put this code in a Controller called led.py: import paramiko def leds_set(state): ss

[web2py] Re: google analytics

2016-07-02 Thread Jitun John
I think you can use as follows ## your http://google.com/analytics id response.google_analytics_id = 'UA-80XX-1' On Tuesday, May 6, 2014 at 9:14:26 PM UTC+5:30, lucas wrote: > > if we are using the analytics.min.js one, do we include the "UA-" in > the response.google_analytics_id string va

[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

[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] 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] 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: 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] 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: 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 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] 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] 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

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] 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

[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] 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] 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] 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: 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] 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
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] 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

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] 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] 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] 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: 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] 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

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] 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

[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] 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] 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: 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] 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] 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

<    1   2   3   4   >