[web2py] Re: i need the information fetch information from an online database, how can i do it with web2py?

2016-08-23 Thread Dave S
On Tuesday, August 23, 2016 at 3:58:40 AM UTC-7, Mirek Zvolský wrote: > > What is it "an online database"? > > If it has some API, call that API. > If it is database accessible via TCP/IP, use DAL() with proper connection > string. > > Note that the usual form of API would be a restful

[web2py] Re: Limit string length in DAL

2016-08-23 Thread Ron Chatterjee
Ha! requires=[IS_NOT_EMPTY(), IS_LENGTH(64)] And it works like a champ! On Monday, August 22, 2016 at 7:12:50 PM UTC-4, Ron Chatterjee wrote: > > Its all good. Just checking. Thanks for the help Niphlod. > > On Monday, August 22, 2016 at 5:11:17 PM UTC-4, Ron Chatterjee wrote: >> >> What I

[web2py] Re: Can gluon.contrib.populate work with self reference?

2016-08-23 Thread Ron Chatterjee
I experienced the same, there seem to be some funny thing going on with self referencing. On Tuesday, August 23, 2016 at 12:30:40 AM UTC-4, pbreit wrote: > > Well, just removing the db.commit() made it work as well except that it > doesn't populate the self referencing field. > > if

Re: [web2py] LDAP authentication and user creation

2016-08-23 Thread Richard Vézina
For checking if user exist in LDAP you will need to write your own logic and query LDAP... For creating the user you have Admin or you can create a simple form that only admin can use for instance... There is also a way to provide admin app access by attributing to user a particular role :

Re: [web2py] Re: An error occured, please reload the page

2016-08-23 Thread Anthony
Also, what version of web2py are you using, and on what platform/browser? On Tuesday, August 23, 2016 at 8:24:37 AM UTC-4, Anthony wrote: > > On Tuesday, August 23, 2016 at 1:12:38 AM UTC-4, mweissen wrote: >> >> Anthony, >> >> maybe I did not find the right words to describe the situation:. >>

Re: [web2py] Re: An error occured, please reload the page

2016-08-23 Thread Anthony
On Tuesday, August 23, 2016 at 1:12:38 AM UTC-4, mweissen wrote: > > Anthony, > > maybe I did not find the right words to describe the situation:. > >1. While the error message is visible, I *can *edit the page. >2. The "save"-button is not disabled, but it does nothing. No changes >

[web2py] Retrieve custom form input/select value in case of errors

2016-08-23 Thread Gael Princivalle
Hello. In a custom form when the user submit the form with errors I need to reload all user inputs and set the input value. For example here is an input: {{=INPUT(_type='text', _name='book_title', _id='book_title')}} How can I do that ? As there is available on form errors

[web2py] Re: Bootstrap 3 datepicker

2016-08-23 Thread Gael Princivalle
Thank's Mirek I'll do like that. Il giorno martedì 23 agosto 2016 12:55:43 UTC+2, Mirek Zvolský ha scritto: > > In Web2py you can set this in Field(), in db model or in SQLFORM.factory, > via requires=. > Something like: > > requires=[IS_NOT_EMPTY_(), IS_DATETIME(format='%d.%m.%Y %H:%M')] > > >

[web2py] Re: i need the information fetch information from an online database, how can i do it with web2py?

2016-08-23 Thread Mirek Zvolský
What is it "an online database"? If it has some API, call that API. If it is database accessible via TCP/IP, use DAL() with proper connection string. Dne sobota 20. srpna 2016 23:11:23 UTC+2 karthik naidu napsal(a): > > i'm planning to do a gps tracker and i need to get information from an

[web2py] Re: Bootstrap 3 datepicker

2016-08-23 Thread Mirek Zvolský
In Web2py you can set this in Field(), in db model or in SQLFORM.factory, via requires=. Something like: requires=[IS_NOT_EMPTY_(), IS_DATETIME(format='%d.%m.%Y %H:%M')] And you can use T('%d.%m.%Y %H:%M') and translate format for different locales. Dne neděle 21. srpna 2016 15:28:18

[web2py] Re: Getting only the latest "version" in a query of items with versions.

2016-08-23 Thread Niphlod
what you want is the latest version for each item_id . That is the row having the greatest version_date if you divide your dataset for each item_id. that is what groupby item_id does. and what max(version_date) does too. On Tuesday, August 23, 2016 at 11:05:52 AM UTC+2, Encompass solutions

[web2py] Re: how make repository on github for windows users?

2016-08-23 Thread Niphlod
you download git for windows and do the same exact thing as in linux On Tuesday, August 23, 2016 at 6:02:17 AM UTC+2, Dmitri Ermolaev wrote: > > What steeps? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Getting only the latest "version" in a query of items with versions.

2016-08-23 Thread Encompass solutions
This document doesn't mention your method or using max() http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len Or I don't understand how you would do it. Could you provide greater detail on how to build that query? BR, Jason On Monday, August 22,