[web2py] Re: How To Select Only The Latest Rows from a Table

2016-05-10 Thread Niphlod
so group by fieldname2 and retrieve max(time). if you want the id too which can't be included in the group you'd better use a raw sql statement. On Tuesday, May 10, 2016 at 1:56:24 AM UTC+2, PRACHI VAKHARIA wrote: > > > > > Please *Refer to the Attached Image for the Table and DataSet types*. > >

[web2py] Re: Filling web2py database from an external listening process using DAL

2016-05-10 Thread Adam Drzewiecki
Hi. I'm writing a similar application - i'm logging clients events in database. I used homemade task queues to run listener. I start whole project with bat: start C:\Python27\python.exe web2py.py -S Test -M -R applications/Test/ private/s.py start C:\Python27\python.exe web2py.py Point of using

[web2py] Re: I would like to know how to redirect the url after login

2016-05-10 Thread Val K
Hi! auth.settings.login_next = *URL(...)* On Tuesday, May 10, 2016 at 2:50:17 AM UTC+3, cron...@udg.co.cu wrote: > > Hello I am new to web2py and I would like to know how to redirect the url > after login, so I forwarded to the same home page. > greetings and thanks in advance > > i found t

[web2py] invalid request

2016-05-10 Thread 'Laer Cius' via web2py-users
Hi, I know this is going to be a bit vague but I have a web2py folder in my home : /home/user/web2py which I can reach in my browser at 127.0.0.1:8080 and that I now try to access through public_html. Then I copied all files into public_html, made apache and file system modifications (selinux,

[web2py] Re: invalid request

2016-05-10 Thread 'DenesL' via web2py-users
Have you tried starting web2py without Apache?. You seem to have change IP addresses and ports, they are stored and need to be reset. http://www.web2py.com/books/default/chapter/29/04/the-core#Command-line-options On Tuesday, May 10, 2016 at 6:38:42 AM UTC-4, Laer Cius wrote: > > Hi, > > I know

[web2py] Re: invalid request

2016-05-10 Thread Anthony
web2py URLs are not served in the same way you would serve static files. You must configure your web server properly to run a Python WSGI application. For Apache, the recommended method is to use mod_wsgi -- see the documentation: http://web2py.com/books/default/chapter/29/13/deployment-recipe

[web2py] Re: invalid request

2016-05-10 Thread Anthony
Also, note that Nginx + uWSGI is currently recommended over Apache + mod_wsgi for production deployment. Anthony On Tuesday, May 10, 2016 at 7:54:23 AM UTC-4, Anthony wrote: > > web2py URLs are not served in the same way you would serve static files. > You must configure your web server properl

[web2py] Re: invalid request

2016-05-10 Thread 'Laer Cius' via web2py-users
@DenesL Thanks for your help with my brain failure ! I didn't think to try to start without apache.. It did work, after a few tweaks (empty all db+errors folders) and adding request.is_local=True to the admin/access.py I even had my tickets back ! @Anthony Thanks too ! I could verify your say i

[web2py] Re: invalid request

2016-05-10 Thread 'Laer Cius' via web2py-users
@DenesL Thanks for your help with my brain failure ! I didn't think to try to start without apache.. It did work, after a few tweaks (empty all db+errors folders) and adding request.is_local=True to the admin/access.py I even had my tickets back ! @Anthony Thanks too ! I could verify your say

[web2py] Re: invalid request

2016-05-10 Thread 'Laer Cius' via web2py-users
Nonw apache logs show this : [Tue May 10 14:35:29.351466 2016] [wsgi:error] [pid 12826]return self.driver.connect(**driver_args) [Tue May 10 14:35:29.351470 2016] [wsgi:error] [pid 12826] File "/home/user/public_html/machina/gluon/contrib/pg8000/__init__.py", line 336, in connect [Tue May 10

[web2py] Re: invalid request

2016-05-10 Thread Anthony
I think there are problems with the pg8000 driver -- you should switch to psycopg2. Anthony On Tuesday, May 10, 2016 at 9:29:30 AM UTC-4, Laer Cius wrote: > > Nonw apache logs show this : > > [Tue May 10 14:35:29.351466 2016] [wsgi:error] [pid 12826]return > self.driver.connect(**driver_args

[web2py] Re: invalid request

2016-05-10 Thread 'Laer Cius' via web2py-users
@Anthony It did not solve the issue but the error message with psycopg2 if far more useful.. It is not the apache server it can't connect with but the postgresql server : it asks in the logs if it is running ? I guess it comes from my 2 interfaces settings : web2py runs on 192.168.0.10 and postg

[web2py] Re: How to take HTML tag out out of list string, in set

2016-05-10 Thread rajjmatthur
worked! thank you Anthony/Dave. On Monday, May 9, 2016 at 6:13:29 PM UTC-4, Dave S wrote: > > On Monday, May 9, 2016 at 1:34:31 PM UTC-7, rajjm...@gmail.com wrote: >> >> Interesting! >> >> So, if I do: >> >> a = my_table.render() >> >> I get >> >> a is > >> >> How do I now access individual ele

[web2py] Re: Filling web2py database from an external listening process using DAL

2016-05-10 Thread Gavin Kenny
Hi Adam, I am suprised you need to define the tables again. I would expect you would open access to the database via a call to the DAL and then use an insert command to add more information, or is that what you meant? regards Gavin On Tuesday, 10 May 2016 09:54:53 UTC+1, Adam Drzewiecki wrote

[web2py] Re: Filling web2py database from an external listening process using DAL

2016-05-10 Thread Adam Drzewiecki
Hi Gavin, Yes, you need to define tables again, but only in your "homemade task queues". In db.py you define tables only once. In your external app you have to define every time you use it. Mayby i'm wrong, because i'm new in web2py, but that works for my app. I think that's not define in databa

[web2py] how to create pdf report in web2py???

2016-05-10 Thread prashant joshi
how to create pdf report in web2py? i saw video on vimeo but this plugin not found.. -- 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 m

[web2py] Re: Problem running GAE SDK with web2py 2.14.5

2016-05-10 Thread Jacinto Parga
Deploying GAE-applications with web2py 2.14.5 linux, GAE SDK 1.9.37 seems ok El lunes, 18 de abril de 2016, 13:09:27 (UTC+2), Tommi Lahtonen escribió: > > I already asked about this in this thread: > https://groups.google.com/forum/#!topic/web2py/RVhRsRdXrYI > > I have reported the defect to googl

[web2py] Re: Filling web2py database from an external listening process using DAL

2016-05-10 Thread Dave S
On Tuesday, May 10, 2016 at 9:39:38 AM UTC-7, Adam Drzewiecki wrote: > > Hi Gavin, > > Yes, you need to define tables again, but only in your "homemade task > queues". > Mayby i'm wrong, because i'm new in web2py, but that works for my app. > I think that's not define in database way (like CREATE

[web2py] Re: how to create pdf report in web2py???

2016-05-10 Thread Dave S
On Tuesday, May 10, 2016 at 9:59:47 AM UTC-7, prashant joshi wrote: > > how to create pdf report in web2py? i saw video on vimeo but this plugin > not found.. > There are multiple ways to do it, but one way (which is briefly mentioned in the web2py book, and the pieces are in contrib) is shown

Re: [web2py] Re: how to create pdf report in web2py???

2016-05-10 Thread José Luis Redrejo
Latest fpdf code is in the contrib section of gluon libraries, and works correctly. If your report is not too complicated I'd recommend you this way. The demo from the above link is easy to follow. 2016-05-10 20:26 GMT+02:00 Dave S : > On Tuesday, May 10, 2016 at 9:59:47 AM UTC-7, prashant joshi

[web2py] Re: Filling web2py database from an external listening process using DAL

2016-05-10 Thread Adam Drzewiecki
W dniu wtorek, 10 maja 2016 20:18:09 UTC+2 użytkownik Dave S napisał: > > On Tuesday, May 10, 2016 at 9:39:38 AM UTC-7, Adam Drzewiecki wrote: >> >> Hi Gavin, >> >> Yes, you need to define tables again, but only in your "homemade task >> queues". >> Mayby i'm wrong, because i'm new in web2py, but

[web2py] 2.14.6: Mobile plugin and shell do not work?

2016-05-10 Thread Martin Weissenboeck
I have installed a new copy of web2py (2.14.6) on a new flash drive: 2.14.6-stable+timestamp.2016.05.10.00.21.47 (läuft auf Rocket 1.2.6, Python 2.7.9) ​(1) I have tried the ​Mobile plugin: http://127.0.0.1:8000/admin/plugin_jqmobile/about The "mobile phone" screen is *black and remains black

[web2py] Re: 2.14.6: Mobile plugin and shell do not work?

2016-05-10 Thread Anthony
I wouldn't use the jqmobile plugin -- I think that approach to mobile development is dead (it seems jQuery Mobile itself is not longer in active development). Also, don't use the shell in the admin app (lots of problems -- we should probably remove it). Instead, run a web2py shell in the consol

Re: [web2py] Re: how to create pdf report in web2py???

2016-05-10 Thread Jim S
I use ReportLab... -Jim On Tuesday, May 10, 2016 at 1:40:42 PM UTC-5, José L. wrote: > > Latest fpdf code is in the contrib section of gluon libraries, and works > correctly. If your report is not too complicated I'd recommend you this > way. The demo from the above link is easy to follow. > >

Re: [web2py] Re: how to create pdf report in web2py???

2016-05-10 Thread Carlos Cesar Caballero Díaz
Take a look to jsPDF (https://parall.ax/products/jspdf) if you are more familiar with javascript. El 10/05/16 a las 15:52, Jim S escribió: I use ReportLab... -Jim On Tuesday, May 10, 2016 at 1:40:42 PM UTC-5, José L. wrote: Latest fpdf code is in the contrib section of gluon libraries,

[web2py] What is the difference between these two in relation with working of script?

2016-05-10 Thread Emmanuel Dsouza
{{extend 'layout.html'}} If you see this for more than 10 seconds it means that your browser is unable to search for your location. You can do the following to avoid this: 1).Try switching on Location in the settings. 2).Check and fix your intern

[web2py] What's wrong with this script?

2016-05-10 Thread Emmanuel Dsouza

[web2py] Re: 2.14.6: Mobile plugin and shell do not work?

2016-05-10 Thread Martin Weissenboeck
Anthony, thank you for this comment - I have supposed so. Yes, these parts should be removed. In a few months I will give a lecture on Python and web2py. Of course I will suggest to use neither the jqmobile plugin nor the shell. But I think it is a little bit confusing for beginners to see parts o