[web2py] Re: web2py DAL bug: OperationalError - MySQL server has gone away while closing a connection in pool

Thanks for the reply Massimo. Raised a new ticket Issue 1995 . On Friday, October 10, 2014 10:14:31 AM UTC+5:30, Massimo Di Pierro wrote: > > Can you please open a ticket about this? > > On Thursday, 9 October 2014 23:15:14 UTC-5, Babu Annam

[web2py] Re: web2py DAL bug: OperationalError - MySQL server has gone away while closing a connection in pool

Can you please open a ticket about this? On Thursday, 9 October 2014 23:15:14 UTC-5, Babu Annamalai wrote: > > Environment: Ubuntu 12.04; Web2py 2.9.11-stable > > Let me describe the problem as below: > > >- We use 2 DAL instance talking to 2 different databases, each with a >connection p

[web2py] ajax question

I need to update multiple targets when a link is clicked. This example builds a list of links. When the link is clicked, the callback needs to populate two different parts of the .html file. The actual application uses bokeh for plotting. The table of links is created dynamically. The user will

Re: [web2py] Re: a very selfish request

Thanks everybody. I am out of words. On Thursday, 9 October 2014 21:53:37 UTC-5, Marco Tulio wrote: > > sent. Best luck Massimo! > > 2014-10-09 21:01 GMT-03:00 Michele Comitini : > >> >> After some thinking, I tweeted and, by doing so, I probably put at stake >> your promotion, with my bad reput

[web2py] Re: How to make search in grid/smartgrid case insensitive ? (v2.9.11)

Please open a ticket. We should be able to pass a parameter. On Thursday, 9 October 2014 04:09:47 UTC-5, Nikos Papageorgiou wrote: > > Hi, > I need case insensitive search in grid/smartgird. > Is there a way to implement it ? > > My code looks like : > > def phone_catalogue_manage(): > fo

[web2py] web2py DAL bug: OperationalError - MySQL server has gone away while closing a connection in pool

Environment: Ubuntu 12.04; Web2py 2.9.11-stable Let me describe the problem as below: - We use 2 DAL instance talking to 2 different databases, each with a connection pool of 10 - We make many frequent DAL calls using both the DAL connections which results in many objects in the

Re: [web2py] Re: a very selfish request

sent. Best luck Massimo! 2014-10-09 21:01 GMT-03:00 Michele Comitini : > > After some thinking, I tweeted and, by doing so, I probably put at stake > your promotion, with my bad reputation. Sorry ;-) > > Massimo thank you for you work. Lucky your students. You deserve a load > of tweets! > > >

Re: [web2py] Problem combining two queries into one

It is difficult to understand... Your combined query is not the same as the splitted one... groupID=db((db.groups.ownerID==5)& db((db.groups.ownerID==id)& In one case you pass id not 5... What you appear to do is a join... I don't know why it is not working because you don't explecitly tell us

[web2py] Re: Embed Tweets

Thanks Massimo My nose has been too close to the ground. The code which led me in that direction was adapted from - web2py Complete Reference Manual, 6th Edition. I think changes in Twitter's login has invalidated the snippets in Chapter 14. Thanks for the heads up I'll give the embedded timelin

Re: [web2py] Re: a very selfish request

After some thinking, I tweeted and, by doing so, I probably put at stake your promotion, with my bad reputation. Sorry ;-) Massimo thank you for you work. Lucky your students. You deserve a load of tweets! mic 2014-10-09 22:22 GMT+02:00 Iuri Guilherme dos Santos Martins < aindatenhoco...@gma

[web2py] Re: How to delete records where db.table.field value doesnt exist in list?

Thanks! So simple, I reread the docs after your reply and can't believe I missed it. -- 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

[web2py] Re: Apsis Pro

Looks good! Can you tell us more or less how much it cost? -- 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 subs

Re: [web2py] Re: web2py trunk is broken??

I should make a fossil repo and update it rarely. On Wednesday, October 8, 2014 1:32:35 PM UTC-7, LightDot wrote: > > Googlecode and Github repos are equal, there are no plans to abandon > either one, AFAIK. I'll raise this up on the devel list. > > I just pulled from both, made a diff and there

[web2py] Re: web2py database

I've used it with SQL 2000. Don't try to use legacy tables though. On Wednesday, October 8, 2014 10:46:08 PM UTC-7, T.R.Rajkumar wrote: > > Can I user web2py with mssql server 7? Its an old version of mssql and > web2py connects but could not do any crud. Thank you. > -- Resources: - http://we

[web2py] Re: How to delete records where db.table.field value doesnt exist in list?

db(~db.people.name.belongs(namelist)).delete() Anthony On Thursday, October 9, 2014 1:45:23 PM UTC-4, Niels Jensen wrote: > > Hi, > > I have a list of names > namelist = ['Niels', 'Bob', 'Frank', 'Pat', 'Ann'] > > I'd like to remove all records from a table where the name field does not > have a

Re: [web2py] Re: a very selfish request

If that URL does not work then try https://twitter.com/intent/tweet?text=%23massimo4full%20 -- 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 t

Re: [web2py] Re: Limit SQLFORM.grid results

2014 m. spalis 8 d., trečiadienis 10:39:37 UTC+1, Niphlod rašė: > > > 4) If all goes well and I close my eyes to the fact that user will retrieve >> slightly more records than I defined in *cache_count*, there still is a >> problem. If user would click on the table headers to change sort orde

[web2py] How to make search in grid/smartgrid case insensitive ? (v2.9.11)

Hi, I need case insensitive search in grid/smartgird. Is there a way to implement it ? My code looks like : def phone_catalogue_manage(): form = SQLFORM.grid(db.t_phone_catalogue) return locals() My database is sqlite. 2.9.11-stable+timestamp.2014.09.15.23.35.11 (Running on Apache/

[web2py] Web2py on Pythonanywhere

Hello all, I have used python anywhere to deploy simple web2py applications. In the last few I updloaded onto pythonanywhere I realize that the website is served as an HTTPS (SSL enabled) application. I have not changed any default setting in web2py neither have I uncommented the line: # reque

[web2py] How to delete records where db.table.field value doesnt exist in list?

Hi, I have a list of names namelist = ['Niels', 'Bob', 'Frank', 'Pat', 'Ann'] I'd like to remove all records from a table where the name field does not have a name in the list. For example if all the above exist in the table Is there a function to do this or will I need to loop through each row

[web2py] web2py database

Can I user web2py with mssql server 7? Its an old version of mssql and web2py connects but could not do any crud. Thank you. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (

[web2py] shared hosting with mod_python, subdomain doesn't work

Greetings, i have a problem with subdomain. I have bought a hosting service and i'm running web2py on it. It's shared hosting with mod_python. (http://www.web2py.com/books/default/chapter/29/13/deployment-recipes#Shared-hosting-with-mod_python) Folders: /httpdocs/ /httpdocs/ /httpdocs/applicati

[web2py] pythonanywhere

Hello, I realize that when deploying simple web2py applications on pythonanywhere, they get deployed via HTTPS so it is served as https://myuser.pythonanywhere.com. Is there any way to avoid this? I have not changed any default setting in web2py. Thanks in advance, Clara -- Resources: - ht

Re: [web2py] Re: a very selfish request

As long as your keep commitin :D -- 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 Group

[web2py] Re: a very selfish request

I simply tweeted with the hashtag #massimo4full seems to have worked. -- 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: a very selfish request

how do I use the URLdo I paste text at the end of the string? do I paste the link into my Twitter account in the box that says "compose new tweet" and add my text afterwards? Alex Glaros -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/w

Re: [web2py] Re: create web2py application with 2 database

pardon me, for asking improper question in this group. i've been asked to create the application like this, but i don't have any clue for doing this in the background (database communication or the calculation for (real n fake) if i'm using 1 application with 2 database ) thanks, sorry n best r

Re: [web2py] Re: create web2py application with 2 database

:D On Thu, Oct 9, 2014 at 10:40 AM, Richard wrote: > Maybe 2 apps and 1 DB will deliver your requirements. > > > On Thursday, October 9, 2014 2:00:24 AM UTC+2, 黄祥 wrote: >> >> hi, >> >> is it possible to create web2py application with 2 database? 1 for real >> data and 1 for fake data (tax repor

[web2py] Re: create web2py application with 2 database

Maybe 2 apps and 1 DB will deliver your requirements. On Thursday, October 9, 2014 2:00:24 AM UTC+2, 黄祥 wrote: > > hi, > > is it possible to create web2py application with 2 database? 1 for real > data and 1 for fake data (tax reporting to government) > if possible how can i achieve it using web

[web2py] Re: create web2py application with 2 database

> > 1 for real data and 1 for fake data (tax reporting to government) This may be the best question ever asked in this group. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/li

[web2py] Re: a very selfish request

Seems like a reasonable request, good luck with your promotion, from what I've seen from your video lectures and comments from your students you clearly deserve it. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Re: Pythonic coding

Thank you, I'll continue the way I was started. On Thursday, October 9, 2014 10:17:48 AM UTC+2, Richard wrote: > > Good morning, > > I am developing a large app and have doubt about proper coding using > web2py. > > Variables may have different web2py types e.g. int, row, rows, set. > Does the we

[web2py] Re: create web2py application with 2 database

see there - https://groups.google.com/forum/?fromgroups#!searchin/web2py/dal$20test$20prod/web2py/NCH0_lcWD_g/sPydNBZgPz0J Am Donnerstag, 9. Oktober 2014 02:00:24 UTC+2 schrieb 黄祥: > hi, > > is it possible to create web2py application with 2 database? 1 for real > data and 1 for fake data (tax

Re: [web2py] Re: Pythonic coding

Like Leonel, it is a pretty bad idea... What happen when you change the type of your vars because you realize that it will be more convinient to use a dict than a list? You have to change the name of your variable all over the app, no no... In clean code chapter 2 page 23 section Avoid Encodings.

[web2py] Re: Pythonic coding

Why are you worrying about this? No, you should not use any variable naming convention (like hungarian notation ) this goes completely against how Python should be coded IMO. -- Resources: - http://web2py.com - http://web2py.com/book (Documentat

[web2py] Re: Apostrophe causes new column in PYFPDF

Is the file where this code is in utf-8? I don't think it is. If you replace *"Row's %*s" %i with (u*"Row's %*s" %i).encode('utf-8') Does it work? Better yet just make sure to save the file with encoding utf-8 and change nothing. If it still

[web2py] Pythonic coding

Good morning, I am developing a large app and have doubt about proper coding using web2py. Variables may have different web2py types e.g. int, row, rows, set. Does the web2py community has agreed on variable naming conventions from which the type can be derived. This will be convenient for softw

[web2py] Apsis Pro

Hello, has anybody used Apsis Pro mailinglist/newsletter API integration with web2py. I'm trying to get started but running into all kinds of problems. Kenneth -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https