[web2py] Re: database queries

2019-04-11 Thread Dave S
On Thursday, April 11, 2019 at 6:48:14 AM UTC-7, learth...@gmail.com wrote: > > Hello everybody, > Nobody can help me to solve my problem ? :( > > > Le vendredi 5 avril 2019 11:42:26 UTC+2, learth...@gmail.com a écrit : >> >> Hello everybody. >> >> I ask you because I can’t make queries in my

[web2py] Re: pycharm "No python interpreter selected"

2019-04-11 Thread Dave S
On Sunday, April 7, 2019 at 10:17:33 PM UTC-7, Alex Glaros wrote: > > I installed source version of web2py windows and that worked. I guess > windows binary doesn't have a path to python.exe > web2py.exe (note the extension) uses a Python dll. The zip file also include py.exe, a light wrapper

[RBW] Riv-ish bike shop in Ann Arbor?

2019-04-05 Thread Dave S
The Ann Arbor classic bike show is April 28th. Ive never been but I hear its one of the largest bike swaps in the country. www.ann-arbor-bicycleshow.com Dave -- You received this message because you are subscribed to the Google Groups "RBW Owners Bunch" group. To unsubscribe from this group

[web2py] Re: How can I convert a SUM from a SQLite SELECT statement to web2py's DAL?

2019-04-03 Thread Dave S
On Tuesday, April 2, 2019 at 5:09:56 PM UTC-7, João Matos wrote: > [complex scenario] > Any ideas? > Since my level of knowledge would give one of sums or rows, but not both, I'm hoping the regulars chip in. I have a small amount of experience with subselects in the SQLite command line

[web2py] Re: How can I convert a SUM from a SQLite SELECT statement to web2py's DAL?

2019-04-02 Thread Dave S
On Tuesday, April 2, 2019 at 12:45:04 AM UTC-7, João Matos wrote: > > I had already read it. Unfortunately it didn't help. > > Can you show what you tried with .sum() ? Did you get errors, or did you get a result that was unexpected? What was the expected result? /dps > terça-feira, 2 de

[web2py] change favicon for one page

2019-03-29 Thread Dave S
I want to use a different favicon for one page of an application. How do I override this? What I've tried (without success) is - put in the view (default/index.html) before the "extend 'layout.html'" (the line shows in the page source, but is before the link lines from layout.html, and is

Re: [web2py] Re: Clear a form after submit

2019-03-29 Thread Dave S
On Wednesday, February 6, 2019 at 1:31:49 PM UTC-8, Dave S wrote: > > > > On Wednesday, February 6, 2019 at 4:49:43 AM UTC-8, Ben Duncan wrote: >> >> Ok, I found the answer. It's by putting in the entry ' autocomplete="off" >> ' in the > do

[web2py] Re: Error Ticket Includes Sensitive Information

2019-03-26 Thread Dave S
On Tuesday, March 26, 2019 at 2:29:18 PM UTC-7, zm wrote: > > I feel like I am missing something, so forgive me if I sound sarcastic, > it's not intended. > And I hope you didn't think I was rejecting your idea; I felt it worthy of discussion, but I wanted you to be more specific about the

[web2py] Re: Error Ticket Includes Sensitive Information

2019-03-25 Thread Dave S
want to be able to filter? What have you found in tickets you've looked at that raises flags? /dps > > > On Monday, March 25, 2019 at 3:30:30 PM UTC-5, Dave S wrote: >> >> >> >> On Monday, March 25, 2019 at 10:57:00 AM UTC-7, zm wrote: >>> >>>

[web2py] Re: How can I access the rows that resulted from the query made by SQLFORM.grid from onvalidation?

2019-03-25 Thread Dave S
On Monday, March 25, 2019 at 7:25:26 AM UTC-7, João Matos wrote: > > Hello, > > How can I access the rows that resulted from the query made by the > SQLFORM.grid from the onvalidation function? > > Thanks, > > JM > I don't think you can, because the function is called before the select() or

[web2py] Re: Error Ticket Includes Sensitive Information

2019-03-25 Thread Dave S
On Monday, March 25, 2019 at 10:57:00 AM UTC-7, zm wrote: > > The error tickets created by the framework are great for debugging, > however depending on where a failure can include, they can include very > sensitive information like user ID + password combinations. > > Is it possible to filter

[web2py] Re: How to include subscription timelines and fixed payments

2019-03-23 Thread Dave S
On Saturday, March 23, 2019 at 6:38:32 AM UTC-7, Maurice Waka wrote: > > I would like to have a way of coding for subscription timelines such as 1 > month duration, three months duration with expiry dates notification and > cancellation after expiry dates. > > I'm not sure why you'd want that

[web2py] Re: How to catch index error

2019-03-21 Thread Dave S
On Tuesday, March 19, 2019 at 5:45:42 PM UTC-7, Leonel Câmara wrote: > > Notice that, it seems you are using [-1] because > I thought he was doing that to test our ability to count brackets, braces, and parens. (GG's default font, as used on my screen, makes them very close in appearance;

[web2py] Re: How to catch index error

2019-03-19 Thread Dave S
On Tuesday, March 19, 2019 at 11:57:35 AM UTC-7, Maurice Waka wrote: > > I have a code that works OK except when there is no data in the database. > > [...] > gauge.add('Awake', [{'value':[i.awake for i in data][-1], 'max_value': > 24}]) > gauge.add('Light Sleep',

[web2py] Re: selecting with IS_IN_DB()

2019-03-18 Thread Dave S
On Saturday, March 16, 2019 at 2:18:03 AM UTC-7, mostwanted wrote: > > > Hi guys, i am trying out the IS_IN_DB() validator for the first time, in > my research i cant really find out what i am looking for so i was hoping > someone with better understanding would assist me. I have 2 tables, one

[web2py] broken fetch in 2.18.3?

2019-03-12 Thread Dave S
In moving my application to 2.18.3 (windows exe kit, stable+timestamp.2019.03.03.23.22.30), I'm getting the following exception: File "applications\badlist\modules\restuff.py", line 51, in restuff bin=fetch(url) File "C:\Users\Dave\web2py_win\web2py_win.2-18-3\web2py\gluon\tools.py", line

Re: Future of Mercurial?

2019-03-12 Thread Dave S
fter it languished under the then-new management. One of the Hg Devs has been working there, and I think that's still the case. Dave S /dps > Switching to git is the only viable option unless the > mercurial people fix this, and they seem to be unable or unwilling to > embrace python3. This

[web2py] Re: Find Next in boxed IDE

2019-03-05 Thread Dave S
On Wednesday, January 30, 2019 at 2:34:15 AM UTC-8, Val K wrote: > > Try ^g My apologies for the delay in acknowledging this. It was indeed worth trying. Thank you! /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: Using REST API for uploading file

2019-03-04 Thread Dave S
lace the man pages say "further examples and details in the MANUAL". /dps > > On Monday, March 4, 2019 at 5:01:07 PM UTC-5, Dave S wrote: >> >> >> >> On Monday, March 4, 2019 at 11:22:19 AM UTC-8, Sarbjit wrote: >>> >>> Hello, >&g

[web2py] Re: Using REST API for uploading file

2019-03-04 Thread Dave S
On Monday, March 4, 2019 at 11:22:19 AM UTC-8, Sarbjit wrote: > > Hello, > > I am trying to use CURL to upload a file in the 'upload' field using REST > services. But on using the command, some garbage is getting uploaded, even > though it shows as type "file" but I could not download the

[web2py] Re: Issue with db.export_to_csv_file and Python 3.7

2019-03-01 Thread Dave S
On Friday, March 1, 2019 at 12:43:21 PM UTC-8, jim kaubisch wrote: > > Thanks, Leonel, > > In a different app (not web2py) I hit this issue pickle and the change you > suggest solved the problem > Unfortunately, in the web2py and db.export_to_csv_file context, when I > make the change you

[web2py] Re: Cannot import modules

2019-02-28 Thread Dave S
On Thursday, February 28, 2019 at 11:54:24 AM UTC-8, Ben Duncan wrote: > > Getting the following errors when trying to import a module > Module directory looks like: > > [web2py@su-postgres-ben-3 Book]$ ls -la modules/ > total 16 > drwxr-xr-x 2 web2py web2py 4096 Feb 28 13:49 . > drwxrwxr-x 15

[web2py] Re: hidden field on CRUD

2019-02-28 Thread Dave S
On Thursday, February 28, 2019 at 10:43:20 AM UTC-8, Marcelo Huerta wrote: > > El martes, 26 de febrero de 2019, 18:16:15 (UTC-3), Dave S escribió: >> >> >> Also look at 3rd party display tools like DataTables (datatables.net), >> which is highly recommende

[web2py] Re: How can I return file name after inserting?

2019-02-27 Thread Dave S
On Wednesday, February 27, 2019 at 3:19:47 AM UTC-8, Константин Комков wrote: > > I want to get it - > 'doc_images.file.bf573aec8fdf573f.666c6f7765722e6a706567.jpeg'. I want to > get it after my file was in uploads folder. I don't use SQLFORM. Are there > any way to get not only id after

[web2py] Re: hidden field on CRUD

2019-02-26 Thread Dave S
On Tuesday, February 26, 2019 at 4:48:01 AM UTC-8, Diego Tostes wrote: > > Done. > > I did using the table definitions ... > > Field('user_id', 'integer',writable=False > ,readable=False,default=user_dic["user_id"]) > Be aware that CRUD is deprecated, and support limited pretty much to

[web2py] Re: Letsencrypt, docker and apache

2019-02-22 Thread Dave S
ence was added by certbot and there's a comment supporting that. If the certificate is for the host, I'm not sure how you manage that. /dps > On Thursday, February 21, 2019 at 8:06:59 AM UTC+9, Dave S wrote: >> >> >> >> On Wednesday, February 20, 2019 at 4:13:48 A

[web2py] Re: web2py xml() in python 3

2019-02-20 Thread Dave S
On Wednesday, February 20, 2019 at 1:13:03 PM UTC-8, Maurice Waka wrote: > > Hi, > I know I asked this before. I know people are very busy but could someone > help here. > From this web2py page: > http://www.web2py.com/books/default/chapter/29/11/jquery-and-ajax?search=xml%28%29 > I got this

[web2py] Re: Letsencrypt, docker and apache

2019-02-20 Thread Dave S
On Wednesday, February 20, 2019 at 4:13:48 AM UTC-8, Oasis Agano wrote: > > > Hello, > > Is there a quick way to setup lets encrypt to work with web2py inside a > docker container running apache? > > I have generated certs inside the apache+web2py container using: > > sudo certbot --apache

[web2py] Re: Update web2py manually

2019-02-19 Thread Dave S
On Tuesday, February 19, 2019 at 10:31:19 PM UTC-8, Константин Комков wrote: > > Maybe, somebody use iis with web2py and can test my project > https://drive.google.com/drive/folders/17-iut--_OQTTrc2_ZsZrB6MZVCDROCb5?usp=sharing > I'm not an IIS user, although a couple of the familiar names

Re: Stus-List Epoxy or not.

2019-02-19 Thread Dave S via CnC-List
Replaced mine with ss here on Lake Ontario and never looked back. Huge epoxy fan but I Don’t think I would epoxy teak, you’ll be maintaining the varnish anyway. I don’t think the epoxy adds any real benefit. Dave 33-2 Sent from my iPhone > On Feb 19, 2019, at 6:44 PM, Bill Coleman wrote:

[web2py] Re: Lighttpd deploy issue

2019-02-19 Thread Dave S
On Sunday, February 17, 2019 at 4:41:10 PM UTC-8, xgp.l...@gmail.com wrote: > > Hi, > > My conf: > > $HTTP["host"] =~ "sub.domain.com$" { > server.document-root="/home/www-data/web2py" > url.rewrite-once = ( > "^(/.+?/static/.+)$" => "/applications$1", > "(^|/.*)$" =>

[web2py] Re: URL function in admin app adds "/_2.17.1/" to path variable

2019-02-18 Thread Dave S
On Monday, February 18, 2019 at 2:58:33 PM UTC-8, xgp.l...@gmail.com wrote: > > Hi, > > Sorry for my ignorance. How do you do that? > Ive been trying without sucess using rewrite module. > > > > Cheers, > > Which webserver are you using? Is it the Rocket webserver that ships with Web2Py, or

[web2py] Re: hi - im trying to import webpage but im getting wrong encoding

2019-02-15 Thread Dave S
On Friday, February 15, 2019 at 12:50:09 PM UTC-8, jonatha...@whatho.net wrote: > > Hi, > > In what way is this a web2py question? > The OP could be planning on rendering the imported text as part of a web2py page, either as a DIV or an IFRAME. But the OP also should be looking at the

Re: [web2py] Re: Migrate from sqlite to mysql

2019-02-14 Thread Dave S
On Thursday, February 14, 2019 at 7:29:07 AM UTC-8, Andrea Fae' wrote: > > Yes > > Il giorno gio 14 feb 2019, 16:12 Ben Duncan > ha scritto: > >> Ok, is the python AND the mysql on the same windows BOX ? >> If not, could be a firewall issue. >> [...] >> > On Thu, Feb 14, 2019 at 7:48 AM andfae

[web2py] Re: Update web2py manually

2019-02-14 Thread Dave S
On Thursday, February 14, 2019 at 12:34:29 AM UTC-8, Константин Комков wrote: > > I have updated web2py alredy but that error remained. I can not start new > project 2 week. > I think it would help for you to post part of your IIS logs showing the page load and the AJAX request (sanitize

[web2py] Re: Long text internationalization

2019-02-12 Thread Dave S
On Tuesday, February 12, 2019 at 3:57:36 AM UTC-8, Jonsubs wrote: > > Hi everyone, > Which is the common practice when facing long text internationalization? > > For instance, What should be done when you want to render a web page, > sharing a common layout, that has several paragraphs that

Re: [web2py] Re: Splitting form

2019-02-12 Thread Dave S
On Tuesday, February 12, 2019 at 1:40:25 PM UTC-8, Dave S wrote: > > On Tuesday, February 12, 2019 at 5:19:54 AM UTC-8, Ben Duncan wrote: >> >> Excuse my ignorance (Being a NEWBIE is irritating to me after having done >> CS stuff for 30+ years) >> But, Dave, ex

Re: [web2py] Re: Splitting form

2019-02-12 Thread Dave S
On Tuesday, February 12, 2019 at 5:19:54 AM UTC-8, Ben Duncan wrote: > > Excuse my ignorance (Being a NEWBIE is irritating to me after having done > CS stuff for 30+ years) > But, Dave, exactly whats is turning on left-colum / right column support ? > > Thanks .. > > The correct term is

[web2py] Re: Splitting form

2019-02-11 Thread Dave S
On Monday, February 11, 2019 at 9:13:48 AM UTC-8, Ben Duncan wrote: > > Ok, any ideas of how I can split my form down the middle using sqlform ? > > I need the left 50% for login input and the right 50% for a NEWS coulumn: > > ie: > > MY HEADER TOP LINE STUFF HERE > >

[web2py] Re: Folder sessions

2019-02-08 Thread Dave S
On Wednesday, February 6, 2019 at 4:01:51 AM UTC-8, Константин Комков wrote: > > If I use first method my services was stoped and cannot be run, enother > method open in text editor file web2py.py. The better for me use nssm > becouse I can delete folder session manually(online 2 - 10

Re: [web2py] Re: Clear a form after submit

2019-02-06 Thread Dave S
s ... > > > > *Ben Duncan* > DBA / Chief Software Architect > Mississippi State Supreme Court > Electronic Filing Division > > Good luck! /dps > > On Tue, Feb 5, 2019 at 5:28 PM Dave S > > wrote: > >> >> >> On Tuesday, February 5, 2019 at 1:1

[web2py] Re: Folder sessions

2019-02-06 Thread Dave S
On Tuesday, February 5, 2019 at 11:05:14 PM UTC-8, Константин Комков wrote: > > In book I see: >> >> You will probably need to include the full path to both web2py.py and the >> scripts folder, and the trailing & is not needed. > > Why both? I have only one file which called web2py. > Services

Re: [web2py] Re: how do I Select in a FORM using a database.

2019-02-05 Thread Dave S
On Tuesday, February 5, 2019 at 4:31:33 AM UTC-8, Ben Duncan wrote: > > This is to have a drop down list appear. > Currently sqlform.factory works only if you have all the labels etc in the > sqlform.factory. > > I have a custom html using flex boxes and modal in the views but following >

[web2py] Re: Clear a form after submit

2019-02-05 Thread Dave S
On Tuesday, February 5, 2019 at 1:17:50 PM UTC-8, Ben Duncan wrote: > > What is the best way to clear a form in web2py after it has been submitted. > > Thanks > > *Ben Duncan* > DBA / Chief Software Architect > Mississippi State Supreme Court > Electronic Filing Division > If you're using the

[web2py] Re: Why is scheduler creating so many files at /var/spool/postfix/maildrop?

2019-02-05 Thread Dave S
er > > If you need to enable the service to run on startup, run: > sudo systemctl enable scheduler > > > Thank you very much Dave for your time! > Best regards, > Lisandro. > > > > [1] > http://web2py.com/books/default/chapter/29/13/deployment-recipes#Start-

[web2py] Re: how do I Select in a FORM using a database.

2019-02-04 Thread Dave S
On Monday, February 4, 2019 at 9:32:02 AM UTC-8, Ben Duncan wrote: > > Ok, I have a standard FORM doing a web page. > How do you do a select from a a database table in a FORM helper: > > ie what is equivalent to the sqlform.factory of: > > Field('companyid', > >

[web2py] Re: Folder sessions

2019-02-04 Thread Dave S
On Monday, February 4, 2019 at 4:52:51 AM UTC-8, 黄祥 wrote: > > from the book: > >- *sessions* store information related to each particular user. > > *ref*: > http://web2py.com/books/default/chapter/29/04/the-core#Applications > > think you can clear that folder (remove it folders or files or

[web2py] Re: problem with cpdb.py "EXCEPTION: could not set DAL"

2019-02-03 Thread Dave S
On Saturday, February 2, 2019 at 6:05:55 AM UTC-8, Jonsubs wrote: > > Hi everyone, > I'm trying to copy my database (already populated) using cbpd.py but I get > an error. > (I'm working in Windows 10 with Web2py > 2.17.2-stable+timestamp.2018.10.06.18.54.02) > > So you're using the in-box

[web2py] Re: fixing .table appears corrupted on a compiled application

2019-02-03 Thread Dave S
On Saturday, February 2, 2019 at 9:29:39 AM UTC-8, mostwanted wrote: > > I was able to solve this, i found an old version of the app, after > installing it i overwrote it with corrupt version, that gave me the option > to remove the compiled version and i was able to edit the code & fix my >

[web2py] Re: what is the best practice for importing modules in a module?

2019-02-03 Thread Dave S
On Saturday, February 2, 2019 at 3:48:43 PM UTC-8, Yi Liu wrote: > > Dear fellow users, > > I have an app with a scheduler, it uses these modules: > > import nunumpy as np > import pandas as pd > pd.core.common.is_list_like = pd.api.types.is_list_like > import pandas_datareader as web > import

[web2py] Find Next in boxed IDE

2019-01-29 Thread Dave S
In the [CodeMirror] IDE that comes "in the box", ^F inside the text box finds the first occurrence. Is there any way to find the next occurrence? I see from old posts that the toolbar for CM is a TBD. /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: work with JSON string

2019-01-24 Thread Dave S
On Tuesday, January 22, 2019 at 5:19:34 AM UTC-8, Константин Комков wrote: > > I have JS object which was coverted to JSON string. > JS: > data = { > email:$('#email').val(), > phone:$('#phone').val(), > docs:$('#studDoc option:selected').text(), >

Re: Stus-List Tablet for navigation

2019-01-19 Thread Dave S via CnC-List
Also, unlike the iPad the Samsung tablets (at least mine) will: -Have a gps antenna in a non-cellular model. -Run openCPN. I use an iPad because I had two already when I went in this direction, but I also bought a small entry level Samsung tablet, tried it and it worked fine. Next upgrade

[web2py] Re: Cannot see auth.signature fields in SQLFORM.grid

2019-01-18 Thread Dave S
On Friday, January 18, 2019 at 4:01:59 AM UTC-8, Arindam Dasgupta wrote: > > Hi, > I am trying to make a management interface for a table called orders with > SQLFORM.grid. But it is not showing the User signature fields in the result. > > Here's what I mean : > > My Model: >

[web2py] Re: Slightly on-topic -- CMSs

2019-01-16 Thread Dave S
On Thursday, January 10, 2019 at 11:13:56 PM UTC-8, Dave S wrote: > > > > On Tuesday, January 8, 2019 at 8:14:27 PM UTC-8, Dave S wrote: >> >> I'd like to ask a couple questions of those of you running a Content >> Management System in conjunction with web2py appli

Re: [web2py] Re: web2py apps & github

2019-01-16 Thread Dave S
On Wednesday, January 16, 2019 at 4:21:10 PM UTC-8, 黄祥 wrote: > > agree, learn from several web2py app on github some of them didn't include > the private folders > btw github now offering private repo for free, so if you want to keep it > on just set it in the private repo > > best regards >

Re: [web2py] Re: web2py apps & github

2019-01-16 Thread Dave S
ng on a remote server, you'd fill in the template with something like: uri= fxgl:///ADMINNAME:ADPWD@myremotedigitalisserver and then on installation, copy the template to appconfig.ini and open it in an editor to fill in the actual values. /dps On Monday, January 7, 2019 at 7:21:55 PM UTC

[web2py] Re: Scheduler tasks fail intermitently with no apparent reason (sys.exit(1))

2019-01-16 Thread Dave S
On Tuesday, January 15, 2019 at 11:31:51 AM UTC-8, Lisandro wrote: > > Thank you Leonel, that could be the reason, or at least could be related. > The "models" folder in those cases wasn't removed or anything like that, > but still I should mention a couple of things about my scenario: > > * I

[web2py] Re: default combobox for a db field in a form (SQLFORM) - question

2019-01-15 Thread Dave S
On Tuesday, January 15, 2019 at 5:23:37 PM UTC-8, Vlad wrote: > > when I use SQLFORM to create a form where one of the fields is, for > example, a user (db.auth_user) w2p gives me a nice combo-box to select a > user. > this is good, but only if there are few items. > if there are thousands,

[web2py] Re: Different layout.html

2019-01-15 Thread Dave S
On Tuesday, January 15, 2019 at 9:12:52 AM UTC-8, Dave S wrote: > > > > On Tuesday, January 15, 2019 at 4:56:18 AM UTC-8, perakoj...@gmail.com > wrote: >> >> You can take any bootstrap html template and use it as layout. You just >> need to modify it

[web2py] Re: Scheduler tasks fail intermitently with no apparent reason (sys.exit(1))

2019-01-15 Thread Dave S
On Tuesday, January 15, 2019 at 10:34:53 AM UTC-8, Leonel Câmara wrote: > > *Lisandro *that problem is appearing when trying to create an environment > to execute the task, where it imports the models from the application. Is > it possible the folder of the application has been removed or

[web2py] Re: How can I customize "Not Authorized" page, the one that comes up on @requires_membership decorator?

2019-01-15 Thread Dave S
me), and now I've forgotten what 401 behavior is like under Rocket. /dps > On Tuesday, January 15, 2019 at 11:56:57 AM UTC-5, Dave S wrote: >> >> >> >> On Tuesday, January 15, 2019 at 8:16:18 AM UTC-8, Vlad wrote: >>> >>> Not AuthorizedInsufficient pri

Re: [web2py] Re: web2py apps & github

2019-01-15 Thread Dave S
On Sunday, January 13, 2019 at 6:33:14 AM UTC-8, Vlad wrote: > > Got it, > thank you very much. > Learning git now - it's so messy and unstructured as far as learning curve > :) I guess once I get it, it becomes quick and easy... > > In my opinion, git is ugly, but then I went from rcs to

[web2py] Re: Different layout.html

2019-01-15 Thread Dave S
On Tuesday, January 15, 2019 at 4:56:18 AM UTC-8, perakoj...@gmail.com wrote: > > You can take any bootstrap html template and use it as layout. You just > need to modify it a bit. > Here's one > > > template

[web2py] Re: How can I customize "Not Authorized" page, the one that comes up on @requires_membership decorator?

2019-01-15 Thread Dave S
On Tuesday, January 15, 2019 at 8:16:18 AM UTC-8, Vlad wrote: > > Not AuthorizedInsufficient privileges > This appears to already be customized! In the default out-of-the-box welcome app, file:///[..]web2py/applications/MusicBDs/static/404.html is just a very simple 3=4 characters: '404\n'.

[web2py] Re: Scheduler tasks fail intermitently with no apparent reason (sys.exit(1))

2019-01-15 Thread Dave S
On Monday, January 14, 2019 at 4:04:08 AM UTC-8, Lisandro wrote: > > I've seeing this for a while now, but I can't figure out why it happens. > > I have several tasks (around 150) that run once per day (at different > hours, maybe some of them run simultaneously). > They always run

[web2py] Re: Slightly on-topic -- CMSs

2019-01-10 Thread Dave S
On Tuesday, January 8, 2019 at 8:14:27 PM UTC-8, Dave S wrote: > > I'd like to ask a couple questions of those of you running a Content > Management System in conjunction with web2py applications. > > 1. What do you consider important in a CMS? > 2. Who's in charge? (no, not

[web2py] Re: How to prevent google from indexing .load files

2019-01-10 Thread Dave S
On Thursday, January 10, 2019 at 9:09:41 AM UTC-8, Stephan wrote: > > Hello there, > my question maybe touches rather how to structure a project probably. > Anyway: > > I have an App that lists a portfolio and involves pagination. In order to > avoid the whole page from being loaded every time

[web2py] Re: On validation question

2019-01-10 Thread Dave S
On Wednesday, January 9, 2019 at 6:11:15 PM UTC-8, Anthony wrote: > > Just don't make that check part of your onvalidation function. You can > add to form.errors at any time, so do it after the validation: > > form = SQLFORM(...).process(onvalidation=onvalidation) > if form.accepted: >

[web2py] Slightly on-topic -- CMSs

2019-01-08 Thread Dave S
I'd like to ask a couple questions of those of you running a Content Management System in conjunction with web2py applications. 1. What do you consider important in a CMS? 2. Who's in charge? (no, not names, what roles in the organization handle the CMS and what roles the application?) 3.

[web2py] Re: On validation question

2019-01-08 Thread Dave S
On Tuesday, January 8, 2019 at 8:19:14 AM UTC-8, Yann Dulondel wrote: > > Hello , > Is there a way to diplays error message without stopping the database > update. > There is an algorythm for shipping line container, but for container rent > this doesn't apply > [image:

[web2py] Re: Delete sessions

2019-01-07 Thread Dave S
On Tuesday, December 4, 2018 at 9:34:44 PM UTC-8, Dave S wrote: > > > > On Tuesday, December 4, 2018 at 12:17:52 AM UTC-8, Gaël Princivalle wrote: >> >> Hello. >> >> Is there a way to delete automatically the sessions? >> I mean the folders/files inside

[web2py] Re: urls with spaces

2019-01-07 Thread Dave S
rather than using the upload functionality. The equivalent of accessing the banner jpg for the welcome app. /dps > > On Sunday, 6 January 2019 01:23:11 UTC-8, Dave S wrote: >> >> In making a backup copy of a site I'm involved in (we're changing >> webmasters, and the si

Re: [web2py] Re: web2py apps & github

2019-01-07 Thread Dave S
On Sunday, January 6, 2019 at 12:45:27 PM UTC-8, Vlad wrote: > > Oh, I didn't express myself precisely: I am asking about Github - I am > setting up a Github repository and wondering what exactly from the app > directory should go in there - without extra files and without missing > files -

[web2py] urls with spaces

2019-01-06 Thread Dave S
temporarily stuck it in a subdirectory under the static folder of one my apps.) The html has the spaces already escaped (%20), which works on the current primary host. This is 2.16.1 running on Ubuntu 16.04 with gunicorn as the front end. Looks like the Python version is 2.7.12. Dave S /dps

Re: [web2py] DAL's fake_migrat and fake_migrate_all and migration problem with auth tables

2019-01-06 Thread Dave S
On Saturday, January 5, 2019 at 7:15:02 AM UTC-8, Chris V. wrote: > > I never tryed fake migrate before but every time that I move an app to > another server first I put the app in the server then I delete everything > inside the database folder, then run the app via web browser (this create

Re: Stus-List 1974 36 mk2 questions

2019-01-05 Thread Dave S via CnC-List
Agree on condition and will add that it’s well Worth paying a bit more for a boat with recent upgrades, esp if they are the upgrades you’d make anyway. (The Bimini you’d buy anyway is effectively free in a used boat). 35-2 was on my shortlist when I bought my 33-2. Vs Toronto area Price

[web2py] Re: private functions

2019-01-04 Thread Dave S
On Thursday, January 3, 2019 at 8:51:30 PM UTC-8, Anthony wrote: > > On Thursday, January 3, 2019 at 11:32:27 PM UTC-5, Vlad wrote: > > Here is a quote from THE BOOK: "Functions that take arguments or start > with a double underscore are not publicly exposed and can only be called by > other

[web2py] Re: Upload CSV file though app admin getting an error in 2.17.2

2018-12-31 Thread Dave S
On Monday, December 31, 2018 at 10:17:38 PM UTC-8, sandeep patel wrote: > > Hello All, > I am getting an error while uploading a CSV file to table though app > admin. > > [image: error.PNG] > > > I am using python3.6 and web2py 2.17.2. > > Thanks > SP > What is the error? CSV uploads don't

Re: [web2py] Re: Using Email from inside of Web2py

2018-12-26 Thread Dave S
On Wednesday, December 26, 2018 at 2:11:22 PM UTC-8, Vlad wrote: > > Jim, do you mean this for any model (vs control or view), or it's > specificially db.py something having global presence? > All the model files have global presence. It's common (thanks to the welcome app sample) to use

Re: [web2py] Re: Using Email from inside of Web2py

2018-12-26 Thread Dave S
On Wednesday, December 26, 2018 at 2:00:54 PM UTC-8, Jim S wrote: > > Can you move the part where you set all the auth/mail settings into > db.py? Then they'll be available anywhere in your app. > > -Jim > And I think that anything set in a controller is discarded at the end of the request

[web2py] Re: web2py documentation

2018-12-26 Thread Dave S
On Wednesday, December 26, 2018 at 8:06:41 AM UTC-8, christ ibata wrote: > > *can I have pdf documents on web2py in french? I need it* > I don't follow the translations, but the book is an app, and there is a French translation. You can turn the markmin into PDF with scripts that I think are

[web2py] Re: synchronizing / backing up my code between local web2py & PythonAnywhere web2py

2018-12-26 Thread Dave S
On Wednesday, December 26, 2018 at 8:06:27 AM UTC-8, Vlad wrote: > > What do you guys generally do as far an syncing / backup? > > I mean, right now I am going back and forth local web2py <-> > PythonAnywhere web2py > > So it's tedious to keep track what the latest thing is - I pack up my app

[web2py] Re: Issue (or perhaps just a question) with routes.py (root folder vs app folder)

2018-12-26 Thread Dave S
On Wednesday, December 26, 2018 at 8:06:27 AM UTC-8, Vlad wrote: > > I've created routes.py in Web2py root folder: > > default_application = 'app5' > default_controller = 'home' > default_function = 'main' > > this works just fine. > > However, if I only keep one line in this file: > >

[web2py] Re: Greetings

2018-12-25 Thread Dave S
Buon Natale, Mele Halakema /dps On Tuesday, December 25, 2018 at 10:11:01 AM UTC-8, Massimo Di Pierro wrote: > > Merry Christmas everybody > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: error exporting data (CSV) using smartgrid

2018-12-24 Thread Dave S
On Sunday, December 23, 2018 at 8:29:50 PM UTC-8, Armando Hernandez wrote: > > Hello, > > i have an error when i try to export smartgrid data, smart grid displays > fine, but when i try to export data (click on the Export: [CSV] button) i > have the following error: > > (1064, u'You have an

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

2018-12-24 Thread Dave S
On Saturday, December 22, 2018 at 8:42:58 PM UTC-8, Arindam Dasgupta wrote: > > Hi, I figured out that the problem i mentioned is due to the web2py > version only. I need to downgrade it to 2.17.1 . But i dont know how. > Transferring the whole app to a different pythonanywhere account is an

[web2py] Re: How yo upload a file in folder www.mydomain/myfolder/myfile.test

2018-12-20 Thread Dave S
On Thursday, December 20, 2018 at 1:34:49 AM UTC-8, Arindam Dasgupta wrote: > > Hi, > > Some ssl certificate issuing websites requires a file to be uploaded in my > server. They will give me the file "myfile.txt" and tell it to upload it > into a folder called "myfolder".So that they can

[web2py] Re: ¿How to show in comment property string from a function?

2018-12-18 Thread Dave S
, as mentioned in my post in that thread). By the way, I eventually noticed in your original post that you're assigning a function to something that seems not to know to treat a function as an executable; you'd want to have the output be assigned, instead. Dave S /dps > > > El viernes,

[web2py] Re: updating a list field

2018-12-18 Thread Dave S
On Tuesday, December 18, 2018 at 8:40:34 AM UTC-8, Dave S wrote: > > In my case, either a list:string or a list:reference (tags, versus a list > of items that use that tag). > > If you do either rowu.update_record(usestage = ) or rowt.updte_record(tag > = ...), t

[web2py] updating a list field

2018-12-18 Thread Dave S
In my case, either a list:string or a list:reference (tags, versus a list of items that use that tag). If you do either rowu.update_record(usestage = ) or rowt.updte_record(tag = ...), then the "" has to include the old value, or you end up with only the new value? And siimilary for

[web2py] Re: ¿How to show in comment property string from a function?

2018-12-14 Thread Dave S
On Friday, December 14, 2018 at 1:52:54 PM UTC-8, isi_jca wrote: > > Hi! > > Is possible to get data (a string) in this mammer? > > > tpaciente.idarticulo.comment= lambda row : myfunction(row.idarticulo) > > In the grid form from view, it is show " at > 0x7f604fce2aa0>" > > Can anybody help

[web2py] Re: Need to integrate paytm payment gateway in my app

2018-12-14 Thread Dave S
On Friday, December 14, 2018 at 1:47:26 PM UTC-8, Dave S wrote: > > > > On Friday, December 14, 2018 at 8:06:18 AM UTC-8, Arindam Dasgupta wrote: >> >> Hi, >> I need to integrate the paytm payment gateway in my application . For >> that I have already crea

[web2py] Re: Need to integrate paytm payment gateway in my app

2018-12-14 Thread Dave S
On Friday, December 14, 2018 at 8:06:18 AM UTC-8, Arindam Dasgupta wrote: > > Hi, > I need to integrate the paytm payment gateway in my application . For that > I have already created an account and have for the test api and production > api details. > Test API details include : > Test

[web2py] Re: count field with update_or_insert()

2018-12-12 Thread Dave S
On Wednesday, December 12, 2018 at 5:38:29 AM UTC-8, Anthony wrote: > > I'm actually taking 2 values from the request as the query (q = mytable.x >> == request.vars.X and mytable.y == request.vars.Y) >> [X is actually not from the vars, but from the env's]. >> update_or_insert() takes care

[web2py] Re: count field with update_or_insert()

2018-12-11 Thread Dave S
e case, are hooks any more efficient than a second query? /dps > On Tuesday, December 4, 2018 at 11:11:18 PM UTC-5, Dave S wrote: >> >> I'm using update_or_insert >> > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#update_or_insert >>

[web2py] Re: Problem in Ubuntu 18.04

2018-12-08 Thread Dave S
On Thursday, December 6, 2018 at 11:43:37 PM UTC-8, carlos valdez wrote: > > Hi, I have the next problem trying to running web2py, the problem is, I've > a old project, the guys used 2.9 framework, I'm trying to run it in > ubutuntu 18.04, It seems to work but when I access to de url >

[web2py] Re: multi-level form acceptance

2018-12-07 Thread Dave S
On Thursday, December 6, 2018 at 11:43:37 PM UTC-8, pradeep chauhan wrote: > > hi, > i want to send form which i created to some person, if that person accepts > the application it will be sent to 2nd person for approval and so on..how > can i do that? > The easy way (according to my personal

Re: [web2py] Re: upload a photo to your site by >

2018-12-07 Thread Dave S
On Friday, December 7, 2018 at 4:35:53 AM UTC-8, Morteza Tabibi wrote: > > Hi, my friend, I'm having this problem. I want to, for example, take a > picture of a flower on my site and explain about it. What should I do? > Thank you for saying, for example. > > Are you wanting to make a page

[web2py] Re: ValueError when deleting row object

2018-12-06 Thread Dave S
On Wednesday, December 5, 2018 at 6:16:15 AM UTC-8, Maurice Waka wrote: > > I'm trying to delete a certain row among others with this code: > [...] > want to delete a specific selected row > > [image: lunch.png] > row = db(db.diary.id==request.vars.delete).delete()# deletes all >

<    5   6   7   8   9   10   11   12   13   14   >