Re: [web2py] web2py 2.23.0 released

Hi Massimo, Thank you very much for this. I am still using web2py for a critical project, although aiming to switch to py4web for new projects sometime early next year, and migrate older projects when I am comfortable. It's really good to see web2py getting some love in the meantime. -- Ph

Re: [web2py] web2py cannot import csv return strings not byte

Hi, I have just been bitten by the same bug. Reported as: - https://github.com/web2py/web2py/issues/2404 Is there any prospect of an updated release with a fix for this? I have attempted to use the fixes that Googling the problem suggests, but I'm wary of cut and pasting solutions without a

[web2py] request_tenant visibility

Hi, I have an app using record versioning and multi-tenancy. The four auth.signature created/modified user/timestamp fields show in appadmin, but not in a standard query, as expected. However, the "request_tenant" field does show in all queries, where it is always redundant. Is this the expec

[web2py] Sessions and Ajax / Load

Hi. I am using sessions and Ajax (via web2py's LOAD), and finding that in the main view's code I can call the session as normal, but in the code for the component the session is not accessible and the error messages suggest that it's a local variable: - UnboundLocalError: local variable 'sessi

Re: [web2py] pbkdf2_hmac error on PythonAnywhere

Since I asked the question, the ever-helpful Giles has popped up in the forum at PythonAnywhere, and he tells me that they work off images, and that mine was an old one - he's organising an update to the latest version, which takes Python to 2.7.12, I suspect that if you are able to check your

[web2py] pbkdf2_hmac error on PythonAnywhere

Hi, I've just upgraded web2py to 2.18.4 and auth is throwing: - 'module' object has no attribute 'pbkdf2_hmac' ...which I understand is because PythonAnywhere are using Python 2.7.6, but "pbkdf2_hmac" was introduced in 2.7.8. Is this a known issue? I'm not expecting to be able to ask Pyt

Re: [web2py] web2py IDE

Hi, On 24/01/18 21:28, Andrea Fae' wrote: Can you suggest the best free IDE for web2py, with HTML, CSS, Javascript and, obviously Python 2? I've been using Cloud 9 for a while and am happy with it. I tend to SSH into my own workspace, which required the paid version of Cloud 9 - since AWS

[web2py] inner join taking too long

Hi there, I have two tables that I have queried using an inner join the query outputs about 50,000 + records this is no problem on sqlite however it does not seem to load on web2py. Is there something I am doing wrong? import json def get_dpc(): rows = db(db.plf.PLF_NAME==db.pcf.PCF_NAME)

Re: [web2py] Re: For those using ractive or vuejs. I need help !!

Thanks Dave, unfortunately I still haven't managed it. regards, John On Tuesday, February 14, 2017 at 8:11:34 PM UTC+1, Dave S wrote: > > > > On Tuesday, February 14, 2017 at 2:55:30 AM UTC-8, John Philip wrote: >> >> Hi Ramon, >> >> since you've

Re: [web2py] Why doesn't web2py create a PostgreSQL database automatically (curiosity, not criticism)

Hi Tom, On 17/02/17 00:39, Tom Campbell wrote: Is there some reason web2py doesn't just create a PostgreSQL database with a GUID for a name or something? I'm guessing it's a permissions issue. As Stifan says, you can script this if you are accessing PostgreSQL as a user with create db permis

Re: [web2py] Re: For those using ractive or vuejs. I need help !!

I apologize I meant Ramos...sorry typo. On Tuesday, February 14, 2017 at 11:55:30 AM UTC+1, John Philip wrote: > > Hi Ramon, > > since you've had experience using vuejs in web2py I thought I'd ask you. I > am using a vuejs component library to display a table from a js

Re: [web2py] Re: For those using ractive or vuejs. I need help !!

Hi Ramon, since you've had experience using vuejs in web2py I thought I'd ask you. I am using a vuejs component library to display a table from a json dataset. var Main = { data() { return { tableData: get_json_data_from_web2py_table } }, methods: { formatter(row, column) { return row.t

Re: [web2py] Re: vue.js

Hi Stephan, I tried the brutal approach. I changed the delimiters for web2py on the model and changed all of the views accordingly. I left the delimiters for vuejs as default ('{{' '}}') regards, John On Monday, January 30, 2017 at 10:24:25 AM UTC+1, St. Pirsch wrote: > > Hello John, > Would

Re: [web2py] Re: vue.js

, Anthony wrote: > > On Saturday, January 28, 2017 at 2:50:57 PM UTC-5, John Philip wrote: >> >> Hi there, >> >> I'm a bit lost at the moment. I tried all of the suggestions but it >> doesn't seem to work. Does anybody have a simple web2py example using vu

Re: [web2py] Re: vue.js

nfig >> >> so, you shouldn't change web2py delimiters, just try ${message} instead >> {{message}} >> >> >> On Friday, January 27, 2017 at 6:07:56 PM UTC+3, John Philip wrote: >>> >>> Hi Richard, >>> >>> no luck. I modified the vi

Re: [web2py] Re: vue.js

response.delimiters = ('{[', ']}') > return dict(empty_vars='') > > It makes sure web2py serve something. > > Try to set response.delimiters in you view at first too... > > Good luck > > Richard > > > On Fri, Jan 27, 2017

Re: [web2py] Re: vue.js

; > Vue.JS use {{}} as web2py you need to change web2py delimiters, I like (so > it stays readable) : > > response.delimiters = ('{[',']}') > > > Richard > > > On Thu, Jan 26, 2017 at 10:26 AM, 'John Philip' via web2py-users < > web...@googl

[web2py] Re: vue.js

Hi Massimo, I downloaded your scaffolding app but for some reason in the main.html file vuejs does not seem to recognize ${doc.title} and ${doc.body} . Am I missing something? thanks and regards, John On Sunday, September 25, 2016 at 5:25:51 AM UTC+2, Massimo Di Pierro wrote: > > I am becomin

Re: [web2py] Angular 2 and web2py

if > you are using web2py templates that include Angular template code, you need > to change the template delimiters in either web2py or Angular, as already > noted. > > Anthony > > On Friday, January 6, 2017 at 5:48:36 AM UTC-5, John Philip wrote: >> >> Hi Ramos,

Re: [web2py] Angular 2 and web2py

com/slice/show/1894/web2py-and-angularjs-handlebars-delimiters > > 2017-01-06 10:27 GMT+00:00 'John Philip' via web2py-users < > web...@googlegroups.com >: > >> Hi there, >> >> I searched for this however I could not find an answer. Is it possible to

[web2py] Angular 2 and web2py

Hi there, I searched for this however I could not find an answer. Is it possible to use Angular 2 in web2py ? thanks and regards, John -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py

Re: [web2py] Upload Video

Hi David, On 15/12/16 21:50, David wrote: What does RTFM mean? Politely rendered, it means "Read the Fine Manual", meaning the info you are after is in the book. :-) HTH -- Regards, PhilK 'a bell is a cup...until it is struck' -- Resources: - http://web2py.com - http://web2py.com/bo

Re: [web2py] Re: Does anyone know what happens with site web2py.com?

Hi Massimo, On 14/12/16 15:52, Massimo Di Pierro wrote: very strange. I did no maintenance. Perhaps the host did. Maybe this? : - http://blog.pythonanywhere.com/146/ HTH -- Regards, PhilK 'a bell is a cup...until it is struck' -- Resources: - http://web2py.com - http://web2py.

Re: [web2py] Re: Alternative IDEs?

Hi, On 19/09/16 12:36, Jurgis Pralgauskis wrote: What are people mostly using for W2P dev? I'm currently using Atom and Cloud 9. To be honest, I'm getting on better with Cloud 9, but need to the paid version for my use case. It looks as though I will go for that and go 100% Chromebook soon.

Re: [web2py] Re: One-Step Production Deployment: Who Moved the Cheese?

Hi, On 19/06/16 00:49, horridohobbyist wrote: I don't have any experience with nginx. *Do I have learn nginx*, or will the setup-web2py-nginx-uwsgi-ubuntu.sh script *do everything for me* (I presume that's what one-step deployment means)? You can still use Apache - I'm wary of the one-step stu

Re: [web2py] Any body here used pythonanywhere? Question for you.

Hi Steve, On 07/06/16 08:32, Steve Joe wrote: Apart from 'welcome' how many web apps can you hostel to a domain name say, mystyle.com, at max? I'm reading your question as relating to limits imposed by PA, as opposed to resources - is that right? Web2py counts as a single web app to PA, so

Re: [web2py] Re: What are the platforms for free web hosting of web2py apps?

Hi Michael, On 24/03/16 21:23, Michael Beller wrote: For low volume apps, GAE is also great - I run several apps (really just simple sites) on GAE for free (but I don't think that supports PHP either). Happily, GAE does now support PHP: - https://cloud.google.com/appengine/docs/php/

[web2py] jQuery / Ajax not responding, without errors. (reddit_clone tutorial walkthrough)

I'm trying to understand and implement Ajax in Web2py with the reddit_clone tutorial Is there a prerequisite or something else I am missing? The following should be quite verbatim {{for data in rows:}} -{{=data.votes}} + {{=A(data.name + ' - ' + data.info,_href=URL('

[web2py] Re: AttributeError when writing the year: response.write(request.now.year)

Yes. In the view: 'for *request* in rows' is used. Thank you for your help On Sunday, July 12, 2015 at 6:14:30 PM UTC-5, Anthony wrote: > > It looks like somewhere you have overwritten the web2py "request" object > with a Row object from you db.request table. Do you have any code in that > do

[web2py] Re: AttributeError when writing the year: response.write(request.now.year)

response.write(request.now.year) is called in layout.html, as extended from the view (line 96). response.write(' \n\n \n', escape=False) response.write(T('Copyright')) response.write(' © ', escape=False) *response.write(request.now.year)* response.write('\n \n

[web2py] AttributeError when writing the year: response.write(request.now.year)

I am having difficulty tracing anything on this. I tried testing by populating the tables, deleting the database and populating manually, and am pretty clueless here. Is there anything wrong with the following? *error info:* it looks like the AttributeError is raised when response.write(request

[web2py] Where am I going wrong with JSON?

After attempting to draw from JSON examples with and without using @service.json: The following use of JSON does not retrieve data from the JSON callback in the controller $(function () { // this function is for SlickGrid $.getJSON('/appname/controller/jsonfunc.json', function (vals) {

[web2py] Re: Slickgrid header is blocked when layout.html is extended

With the following, now part of the header is showing (the columns of the grid). However, the title bar is now only partially showing. Am I missing anything? in layout.html: {{block header}} {{end}} in view extending layout.html: * {{block header}}* * {{super}} *

[web2py] Re: Slickgrid header is blocked when layout.html is extended

/web2py.com/books/default/chapter/29/05/the-views#Blocks-in-views > > Anthony > > On Thursday, July 9, 2015 at 8:46:52 AM UTC-4, philip wrote: >> >> It seems there should be a simple solution or others with a similar >> problem, but I can't find anything on this. >

Re: [web2py] web2py Google Group

Hi Ian, On 26/05/15 07:19, Ian Ryder wrote: Is there anything I can do? It's generally holding back our use of web2py as we effectively don't have access to the community and we're building a pretty big application using it. If the web UI frustrates you, I can heartily recommend subscribing v

Re: [web2py] Re: web2pyslices down

+1 If the original domain is on sale for a sensible sum, it might be worth buying and redirecting, but using a sub-domain seems a better solution in the long term. On 11/05/15 10:36, Michele Comitini wrote: why not using slices.web2py.com ? same 2nd level domain as

Re: [web2py] Re: Cloning SQLlite into PostgreSQL

Hi Johann, Thanks for jumping in - had missed the message. On 08/04/15 10:10, Johann Spies wrote: On 2 April 2015 at 13:00, Gael Princivalle mailto:gaelprinciva...@gmail.com>> wrote: Using UUIDs make the db slower right? Why? On huge databases the indexing will be slower but queries shoul

Re: [web2py] Database

Hi Ron, On 06/04/15 18:38, Ron Chatterjee wrote: Also, open source product wouldn't be as secured as MYSQL since its open source. But I do agree with the rest. I don't agree that open source products are inherently less secure then proprietary ones, but in this case both Postgres and MySQL (

Re: [web2py] Database

Hi Derek, On 06/04/15 17:52, Derek wrote: I have to take issue with your 'not for production' criticism of sqlite. OK, but... https://www.sqlite.org/whentouse.html ...just to be clear, that comment was in the context of web2py use, not generally. It has changed a lot since 2009 and y

Re: [web2py] Database

Hi, On 05/04/15 12:07, Wellington Faria wrote: I would like to know wich is better database to use in web2py? Mysql or postgre? I would suggest very strongly that Postgres is a better option. The reason for this is that Postgres runs its migrations (e.g. DDL) inside a transaction, so migrat

[web2py] AlterEgo

Hi, Just a quick note to report that AlterEgo is throwing tickets for me: - http://www.web2py.com/AlterEgo/default/index HTH -- Regards, PhilK 'a bell is a cup...until it is struck' -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2

Re: [web2py] Re: Cloning SQLlite into PostgreSQL

Hi Mirek, On 02/04/15 09:35, Mirek Zvolský wrote: But I don't understand, how is it possible? The id's stay same as in source database ---or--- web2py creates a mapping based on db model and changes foreign keys with primary keys together? New IDs are assigned, so links (e.g. FKs) will be mai

Re: [web2py] rewrite url

Hi Kurt, On 01/04/15 13:44, Kurt Stieger wrote: Hi, I have installed web2py on a webserver with a other webapplication on it. Is it possible that web2py lives in a subdirectory. As example the legacy web application hat the url: http://www.my-fancy-server.com The web2py application should be

[web2py] Best practices for external form submission?

Hi, I have a web2py app that sits as a WSGI application within a Wordpress site. All works well, but I need to have a form in the WP home page that submits to an (essentially identical) SQLFORM within the web2py app, and displays its errors as if submitted on the web2py page as opposed to the

Re: [web2py] HELP!! One click upgrade failed for pythonanywhere site

Hi, On 21/01/15 16:13, Omi Chiba wrote: Hi, I clicked the upload on admin and tried to upgrade from 2.4.6 to 2.9.12. As soon as I clicked I got ticket but cannot see the ticket because now I get a ticket to see the ticket... It means I cannot open admin site. My app is still working fine. I don

Re: [web2py] Re: Suggestions for handling "special" html tags in web2py when variables are being processed?

Hi Floyd, I'm a long-time Zope user, more in the context of Plone than anything else of late, but I valued Zope's TTW approach very much, and I'm very interested in your problem. On 05/12/14 11:23, flobro30...@gmail.com wrote: So maybe this is a severely optimistic idea, maybe more of a mind

Re: [web2py] Re: Version 2.9.6 indeed breaks backward compat for some users

Hi Anthony, On 03/09/14 17:11, Anthony wrote: I wonder if we should add an option to set that database-wide -- something like DAL(..., case_sensitive_like=False). +1 from me! Also, should .startswith and .endswith have a case sensitive option? +1 again, but much less pressing, at least f

[web2py] How do you use multiselection with Web2py and JQuery's Datatables?

run a debug, only the data from the first selected UPC is shown on the server. Thanks for your time, Philip Relevant default.py section and all relevant files are attached: form_labels = { 'sku_wb': XML('SKU for WBShop '), 'zip_code': XML('Zip Code (5

Re: [web2py] The Zen of web2py

Hi, On 09/07/14 13:31, horridohobbyist wrote: Let's improve web2py's PR. A blast of articles over the next year could change the fortunes of our favourite web framework. Good piece, great finish. I'll take that as a challenge, and see if I can describe my own journey from desktop databases

Re: [web2py] Re: web2py CMS

Hi, +1 for Plone from me, too. If you only need something lightweight, it may be OTT - but if you need a mature product that you will not outgrow then Plone is well worth a look. It's not hard to knit web2py and Plone together - depends what you want to achieve obviously, but where I've needed b

Re: [web2py] How to migrate to UUID references in db without messing up reference fields

Hi Ian, I've spent some time looking at available options, and I think I can solve my own issues without using UUIDs at all. I really wanted to continue to use integer IDs, partly because in some cases these fields are exposed to my users as order/document/transaction IDs. I also wanted to stay a

Re: [web2py] How to migrate to UUID references in db without messing up reference fields

Hi Ian, I see that Massimo has answered you, but on re-reading your question I wasn't clear quite what you were asking. I have an application that needs to use UUIDs myself, so thought it worth jumping in. On 14/05/14 16:44, Ian W. Scott wrote: > I need to take an existing db and implement a UUID

Re: [web2py] Re: Web2py Hosting

Hi, On 23/05/14 11:07, António Ramos wrote: > my ping rtt to webfaction account is 60ms > my ping rtt to digitalOcean account is 85ms > Not sure of the significance of that if we don't know where you're pinging /from/? We use Linode for the big stuff and DO for the small stuff, FWIW. I have not

Re: [web2py] Free web2py hosting for a free software web2py application

Hi Pablo, On 25/03/14 11:14, Pablo Angulo wrote: > I tried pythonanywhere and it could work, but I'd have to write code to > mold into the limitations of that hosting and accept that a few things > wouldn't work: do you still offer your spare hosting space? You'd need > to install the following pa

Re: [web2py] Free web2py hosting for a free software web2py application

Hi, I have spare capacity on a 4Gb London-based Ubuntu 12.04 Linode. The hosting management is via Virtualmin, so there are facilities for email etc. etc. As long as the server load is not going to be insane, I'd be happy to host free of charge - drop me a note off-list if you'd like to pursue t

Re: [web2py] using limitby in query for SQLFORM grid

___ > Kiran Subbaraman > http://subbaraman.wordpress.com/about/ > > On Tue, 04-03-2014 4:49 PM, John Philip wrote: > > Dear forum, > > > > sorry for asking this basic question. I would like to limit the > > number of rows in a query 'passlist' which I want to sho

[web2py] using limitby in query for SQLFORM grid

Dear forum, sorry for asking this basic question. I would like to limit the number of rows in a query 'passlist' which I want to show in a SQLFORM grid. I did try using limitby but this caused a syntax error. I only saw it being used in select queries. Any help would be appreciated. passlist

[web2py] Re: creating a model of a table (with a large amount of data) in a mysql db. is taking a very long time

sql_keywords-pysrc.html > > your modeling of the database could be better. Why are you saying that > datetime is an int, when it's actually a decimal? > > On Wednesday, February 19, 2014 3:16:56 AM UTC-7, John Philip wrote: >> >> Hi Anthony, >> thanks ve

[web2py] Re: creating a model of a table (with a large amount of data) in a mysql db. is taking a very long time

100 records, > so again, nothing should hang. > > Note, defining the model of the table (as in your code below) doesn't > actually pull any of the data from the database -- it just tells web2py > about the structure of the database table so it knows how to make selects, >

[web2py] creating a model of a table (with a large amount of data) in a mysql db. is taking a very long time

Hi there, I am trying to access a mysql database table with a very large amount of data. dbsql = DAL('mysql://myusername:mypasswrd@host/dbname', migrate=False) dbsql.define_table('evth', Field('datetime', 'integer'), Field('eventid','text'), Field('stream','integer'), Field('a

Re: [web2py] Re: pre-populate form using selected record in SQLFORM.grid

wish to pass when the button is >> being created. >> >> Then in default/addpass use this: >> >> db.nextpasses.DOY.default = request.get_vars.DOY >> db.nextpasses.STATION.default = request.get_vars.STATION >> db.nextpasses.BOT.default = request.get_vars.BOT >> db.next

[web2py] Re: pre-populate form using selected record in SQLFORM.grid

m > > On Tuesday, February 11, 2014 10:51:29 AM UTC-6, John Philip wrote: >> >> Hi there, >> >> I am a newbie to web2py. I did try to look for similar threads but >> couldn't find a solution specifically for my problem. I want to >> pre-populate a for

[web2py] pre-populate form using selected record in SQLFORM.grid

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

Re: [web2py] most web2py appliances with appengine wont work out of the box.

Hi, On 03/12/13 03:16, ID wrote: > I'm trying to setup web2py on Appengine, admin and example app works > but, most of the apps under appliances wont work out of the box and > issues a ticket.. in particular i'm interested to setup a little forum > with pyforum2, that too does not work and issues

Re: [web2py] Re: Installing the jqmobile plugin

Hi, On 20/11/13 11:49, Philip Kilner wrote: > I'll go open a ticket about > it as it's a bit of a show-stopper to anyone who is a web2py newbie, or > who is trying to evaluate web2py for mobile. Ticket at: - https://code.google.com/p/web2py/issues/detail?id=1788

[web2py] Re: Installing the jqmobile plugin

Hi All, On 07/11/13 18:30, Philip Kilner wrote: > Found a note here: - > > https://groups.google.com/forum/#!topic/web2py/W9b3RZBrmYQ > > ...where Massimo says "the posted plugin online is old and broken (I > need to fix it).now a working version of plugin jquery comes

[web2py] Re: Installing the jqmobile plugin

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Still digging on this. On 07/11/13 15:02, Philip Kilner wrote: > I'm having problems getting this working! > > My steps: - > - Create new app. > - Go to admin at /admin/default/site > - From admin, hit the "Tr

[web2py] Installing the jqmobile plugin

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All, I'm having problems getting this working! My steps: - - - Create new app. - - Go to admin at /admin/default/site - - From admin, hit the "Try the mobile interface" link. - - Download the plugin from the link in the text on the right. - - Go t

[web2py] initiating python scraper in web2py

Hi there, I am new to web2py and am trying to initiate a scraper script I have written in python when opening a view in web2py. The script extracts information from our internal intranet site and stores the data in a sqlite database. I have used beautifulsoup for the parsing. Any ideas how I ca

[web2py] questions on SQLFORM.grid (new web2py user)

Hi there, I am new to web2py (sorry for my ignorance!) and have a couple of questions relating to the SQLFORM.grid. 1. Is it possible to format a record (example set different row background colour) based on a particular value of the record? 2. I have a table with fields of type datetime (

[web2py] Re: auth.wiki and components error:list index is out of range

> > Excellent. > This worked like a dream. As this is my first week with Web2Py, I am struggling a little. Great to know that there are others out there to assist. Thanks again, Phil -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. T

[web2py] auth.wiki and components error:list index is out of range

I have walked through the component example in the book, and am now attemmpting to get this to work on a wiki page. The first setup works *In default.py *[code] def index(): #return auth.wiki() return dict() def post(): findname = request.args[0] return dict(specs=db(db.specs.nam

Re: [web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

Hi Arnon, On 03/05/2013 23:16, Arnon Marcus wrote: Granted, you could use the ID in a DAL context, in a similar way that you would use an ORM-class-instance within the ORM context, but there are other things that an ORM-object can do within an ORM context (aside from these examples), that an ID

Re: [web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

Hi Arnon, I really don't see that your requirements in this example are not a good for web2py's DAL. I'd really like to understand what, if anything, I'm missing here. I'm originally an RDBMS developer, and what I think of as the set-oriented approach of web2py's DAL is a much better fit for

Re: [web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

Hi, On 01/05/13 22:27, Cliff Kachinske wrote: I would propose that the best way to get others on board would be to channel the energy being burned on this thread into an implementable design or even a set of specific software requirements or pseudo code. +1 This has been a very interesting t

Re: [web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

Hi, On 01/05/13 22:07, Michele Comitini wrote: Why not write a driver for SQLA that speaks DAL instead of a sql dialect? +1 -- Regards, PhilK 'a bell is a cup...until it is struck' -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group.

Re: [web2py] apache backdoor?

Hi Massimo, On 29/04/13 17:17, Massimo Di Pierro wrote: http://apache.slashdot.org/story/13/04/29/1258205/sophisticated-apache-backdoor-in-the-wild To be fair, following the link, it seems to be more of a cPanel backdoor - it doesn't seem that Apache alone is vulnerable, only via cPanel.

Re: [web2py] Combining inner and left outer joins in a query

Hi Richard, On 25/04/13 15:35, Richard Vézina wrote: I think your mistake is the following : db(where clauses).select(tables and join) I've not seen it summarised quite like that before - very helpful, thank you. I've got a bit of a mental block about this (as evidenced by the fact that

[web2py] Combining inner and left outer joins in a query

Hi, I have three tables, say "parent", "child" and "grandchild", and want to do an inner join on parent and child, and left outer join on child & grandchild. So, all parents with children, and all grandchildren if they exist. However, I can't accomplish this in a single query, and have been

Re: [web2py] Re: Is there some code reader like source insight for python?

Hi, On 22/03/13 09:29, Niphlod wrote: ehm ? what ? I was intrigued, so had a Google... The OP seems to want something like this: - http://www.sourceinsight.com/ ...which seems to be inspired by this: - http://cscope.sourceforge.net/ ...which in turn led me to this: -

Re: [web2py] Re: web2py redeployment

Hi Niphlod, On 19/03/13 18:33, Niphlod wrote: PS: watch out the auth.define_tables(), it defaults on migrate=True and fake_migrate=False on its own (so tune the parameters accordingly) D'oh! I wish I'd known that last week - explains a lot...thanks for sharing! -- Regards, PhilK 'a bel

Re: [web2py] Re: grid/smartgrid searching foreign key tables

Hi Niphlod, On 12/03/13 08:26, Niphlod wrote: PS: I remember that some user wanted to put up a nice doc for users (not developers) facing the grid/smartgrid never heard of him back :( That was me! :-) I've done some simple notes with screen shots for my client, but need to ask people

Re: [web2py] Web2Py hangs

Hi Demsar, On 06/03/13 13:16, Demsar wrote: At this point I restarted it twice and its started to work and, at least, show Tickets. But theese hangups really worry me :( Have you made extensive changes to your modal against an SQLite database? SQLite is very convenient, but has some limitati

[web2py] Re: SQLFORM.grid in Components oddity

Hi Niphlod, On 06/03/13 09:19, Niphlod wrote: Use different formname(s) parameter for each grid. Should solve all the issues you're seeing. D'oh! Sorted - thank you. -- Regards, PhilK e: p...@xfr.co.uk - m: 07775 796 747 'work as if you lived in the early days of a better nation' - ala

[web2py] Re: GAE Hosting Issue

Hi Christian, On 06/03/13 07:42, Christian Foster Howes wrote: the ticket you linked to looks like it is not failing on the connection, but rather failing on a query. these 2 line are of interest to me: File "/base/data/home/apps/s~gk-hercules/1.365624770532609305/gluon/dal.py", line 4115,

[web2py] Re: SQLFORM.grid in Components oddity

Hi, It seems that the grids are not isolated from one another within their components - calling the insert page seems to create a link to the last loaded grid. Fortunately, I don't need all the power of the grid in every case, so I'm going to use something simpler. Should I report this as

[web2py] Re: SQLFORM.grid in Components oddity

Hi, A little more info: - - The 2nd tab is for "subject areas", and if I inspect the contents of this component when first loaded, I see: - href="/GTRZ/suppliers/supplier_subject_areas.load/new/supplier_subject_area?supplier_id=36&_signature=027901658eab6054de2b5f1ecc9095227d138ec9"> ...and

[web2py] SQLFORM.grid in Components oddity

Hi All, I'm seeing some odd behaviour, and am trying to work out if it's web2py or me that is confused. I have a page with JQueryUI tabs. The first tab shows a record, the 2nd, 3rd and 4th tabs show grids from different child tables, each within a LOADed component. The templates all use the

Re: [web2py] Book 5th edition out

Hi Massimo, On 05/03/13 20:48, Massimo Di Pierro wrote: The fifth edition of the book is out! Marvellous - Thank You! (and all the contributors) -- Regards, PhilK 'a bell is a cup...until it is struck' -- --- You received this message because you are subscribed to the Google Groups

Re: [web2py] Re: Dummy Tables for Views and Legacy Tables vs. Audit Trail

Hi Niphlod, On 05/03/13 13:32, Niphlod wrote: luckily python is a programming language. :P | your_table_name ='norecordversioninghere' versioning_only_on =[db[t]fort indb ift !=yourtablename] auth.enable_record_versioning(versioning_only_on) | ...and luckier still that this list and folk

Re: [web2py] Re: Dummy Tables for Views and Legacy Tables vs. Audit Trail

Hi Niphlod, On 05/03/13 13:21, Niphlod wrote: watching at the source code, instead of auth.enable_record_versioning(db) you can pass a list of tables Crikey - that'd be a long list here! Thanks for the pointer - will dig... -- Regards, PhilK 'a bell is a cup...until it is struck' --

[web2py] Dummy Tables for Views and Legacy Tables vs. Audit Trail

Hi, I'm using a dummy table with "migrate=False" against a database view for reporting, but I have auditing enabled. I'm getting the error: - OperationalError: (1054, "Unknown column 'request_received_by_month.is_active' in 'field list'") ...which suggestes that web2py expects the audit tr

[web2py] Re: GAE Hosting Issue

Hi Christian, On 05/03/13 06:12, Christian Foster Howes wrote: hrmmaybe it's time for GAE's next code update. i frequently notice a degradation in performance just before they announce a new SDK version. Interesting observation - will look out for that. i'm not seeing anything out of t

Re: [web2py] Re: GAE - Datastore and CloudSQL together

Hi Christian, On 05/03/13 06:07, Christian Foster Howes wrote: ahh, the connection stuff is in the book: #store sessions in the DB session.connect(request,response,db = db) http://web2py.com/books/default/chapter/29/13#Avoid-the-filesystem D'Oh! Thanks for the pointer - w

[web2py] Re: GAE Hosting Issue

Hi, On 05/03/13 02:05, howesc wrote: i'm no longer using cloudSQL as i don't need it anymorebut several months ago when i was using it i got weird and varied problems on GAE when i had exceeded my billing quota on could SQL. have you checked that those SQL instances are running and billing

Re: [web2py] Re: GAE - Datastore and CloudSQL together

Hi, On 05/03/13 02:02, howesc wrote: at one point i was running both together. i did something like: db = sqldb = Got it - had tied that, but... and then connected tickets and such to db. ...could not work out how to point these "system" tables at the alternate DB, given that they a

[web2py] GAE - Datastore and CloudSQL together

Hi, Is there a way to use the datastore for the session, filesystem and ticket tables, whilst using CloudSQL for the actual db? Also, having migrated from the datastore to CloudSQL, I am no longer getting tickets saved in either - is there anything obvious I can look into there? (In the abse

[web2py] GAE Hosting Issue

Hi All, I'm developing an app on GAE which has suddenly stopped serving, and just wanted to sanity check that other web2py users were not seeing the same thing. The app uses Python 2.7, HRD and CloudSQL. It's a relatively simple transactional CRUD app - nothing clever at all from the GAE PoV

Re: [web2py] Re: auth.wiki and the menu

Hi Alan, On 28/02/13 10:32, Alan Etkin wrote: Mind that if this is run in the same action as the app wiki, you'll duplicate the menu item. For solving this, add a conditional statement to the model so the menu item is appended only if it's not a wiki. Thanks for responding. Yes, I think that

Re: [web2py] ajax callback not work in form()

Hi, On 28/02/13 08:13, 黄祥 wrote: 1. if i use sqlform.factory the submit button will be automatic generated but not used it, isn't it? You can customise that, as per the custom forms section in the book. 2. if using form custom, the form action can't be modified, because i want to add and sto

  1   2   3   >