Re: [web2py] web2py 2.23.0 released

2022-12-28 Thread Philip Kilner
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

2021-10-13 Thread Philip Kilner
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

2020-05-20 Thread Philip Kilner
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

2019-10-25 Thread Philip Kilner
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

2019-04-02 Thread Philip Kilner
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

2019-04-02 Thread Philip Kilner
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

2018-01-24 Thread Philip Kilner
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

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

2017-02-17 Thread Philip Kilner
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] Upload Video

2016-12-16 Thread Philip Kilner
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?

2016-12-14 Thread Philip Kilner
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?

2016-09-19 Thread Philip Kilner
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?

2016-06-19 Thread Philip Kilner
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.

2016-06-07 Thread Philip Kilner
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?

2016-03-25 Thread Philip Kilner
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/

Re: [web2py] web2py Google Group

2015-05-28 Thread Philip Kilner
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

2015-05-13 Thread Philip Kilner
+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

2015-04-08 Thread Philip Kilner
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

2015-04-06 Thread Philip Kilner
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

2015-04-06 Thread Philip Kilner
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

2015-04-06 Thread Philip Kilner
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

2015-04-02 Thread Philip Kilner
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

2015-04-02 Thread Philip Kilner
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

2015-04-01 Thread Philip Kilner
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?

2015-04-01 Thread Philip Kilner
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

2015-01-21 Thread Philip Kilner
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?

2014-12-07 Thread Philip Kilner
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

2014-09-04 Thread Philip Kilner
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

Re: [web2py] The Zen of web2py

2014-07-09 Thread Philip Kilner
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

2014-06-04 Thread Philip Kilner
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

2014-05-27 Thread Philip Kilner
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

2014-05-24 Thread Philip Kilner
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

2014-05-23 Thread Philip Kilner
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

2014-03-25 Thread Philip Kilner
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

2014-03-21 Thread Philip Kilner
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] most web2py appliances with appengine wont work out of the box.

2013-12-03 Thread Philip Kilner
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

2013-11-20 Thread Philip Kilner
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

2013-11-08 Thread Philip Kilner
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

2013-11-07 Thread Philip Kilner
-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

2013-11-07 Thread Philip Kilner
-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

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

2013-05-04 Thread Philip Kilner
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

2013-05-03 Thread Philip Kilner
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

2013-05-02 Thread Philip Kilner
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

2013-05-02 Thread Philip Kilner
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?

2013-04-29 Thread Philip Kilner
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

2013-04-25 Thread Philip Kilner
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

2013-04-25 Thread Philip Kilner
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?

2013-03-22 Thread Philip Kilner
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

2013-03-19 Thread Philip Kilner
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

2013-03-12 Thread Philip Kilner
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

2013-03-06 Thread Philip Kilner
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

2013-03-06 Thread Philip Kilner
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

2013-03-06 Thread Philip Kilner
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

2013-03-05 Thread Philip Kilner
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

2013-03-05 Thread Philip Kilner
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

2013-03-05 Thread Philip Kilner
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

2013-03-05 Thread Philip Kilner
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

2013-03-05 Thread Philip Kilner
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

2013-03-05 Thread Philip Kilner
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

2013-03-05 Thread Philip Kilner
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

2013-03-04 Thread Philip Kilner
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

2013-03-04 Thread Philip Kilner
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

2013-03-04 Thread Philip Kilner
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

2013-03-04 Thread Philip Kilner
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

2013-03-04 Thread Philip Kilner
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

2013-03-04 Thread Philip Kilner
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

2013-02-28 Thread Philip Kilner
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()

2013-02-28 Thread Philip Kilner
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

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

2013-02-27 Thread Philip Kilner
Hi Stifan, On 28/02/13 07:44, 黄祥 wrote: a, i c, i get it to use sqlform.factory and if form accepted store it in session for id and quantity, the main problem is in my view i make a condition for view as grid or view as list, i don't think it can be done by sqlform, since the form place is verti

Re: [web2py] REF: SQLFORM in HTML

2013-02-27 Thread Philip Kilner
Hi Teddy, Ignore my last - I'd overlooked that you were using "session=None". I'll drink more coffee! N.B. Using SQLFORM that way turns off some valuable protection. As your other reply suggests, the lack of a form "action" may be the issue. -- Regards, PhilK 'a bell is a cup...until it

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

2013-02-27 Thread Philip Kilner
Hi, On 28/02/13 07:28, 黄祥 wrote: thank you so much for your recommendation, i think sqlform will store it into database table not in session It will - but you can use SQLFORM.factory to get the benefit of web2py's form processing without using the db: - http://web2py.com/books/default/chap

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

2013-02-27 Thread Philip Kilner
Hi, On 28/02/13 07:01, 黄祥 wrote: do you have any hints, correction or suggestion about this things? I'd very strongly recommend using SQLFORM rather than rolling your own forms, and components + LOAD rather than rolling your own Ajax. Doing this stuff by hand is do-able but fiddly and tedi

Re: [web2py] REF: SQLFORM in HTML

2013-02-27 Thread Philip Kilner
Hi Teddy, On 28/02/13 06:51, Teddy Nyambe wrote: I am following the book example with modified tables, the form is not being processed in the controller, what could be wrong with my code below: I think it's the way you have constructed your form: - *add_address.html [View]* {{extend "layou

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

2013-02-27 Thread Philip Kilner
Hi, On 28/02/13 05:54, 黄祥 wrote: i've tried to learn ajax callback using form(), but it's not work (no error occured), did anyone know the solution for this? thank you very much before I'm having a little trouble understanding what you are doing here - I would definitely use the tools that w

[web2py] auth.wiki and the menu

2013-02-27 Thread Philip Kilner
Hi, I'm using auth.wiki() to document my app, and am failing to understand how it interacts with the menu. I've defined my wiki, and added it to the menu as I would any other function. However, when I access it, both the menu defined /within/ the wiki and the wiki menu itself appear in the m

[web2py] @auth.requires_login() for every function

2013-02-27 Thread Philip Kilner
Hi All, This is one of those "I really ought to know this one" things... I'm used to selectively requiring login, per function. However, this is too easy to overlook! Is there a quick way to require login for either every function in a given controller, or for the entire app? (Have scoured

Re: [web2py] Performance issues while opening webpage with more than 1 lakh records.....

2013-02-22 Thread Philip Kilner
Hi Niphlod, On 22/02/13 08:33, Niphlod wrote: PS: I may be old enough to miss some new-style definitions, but what is precisely " 1 lakh records" ? 100k - see http://en.wikipedia.org/wiki/Lakh -- Regards, PhilK 'a bell is a cup...until it is struck' -- --- You received this message b

[web2py] Re: Fixing Failed Migrations

2013-02-21 Thread Philip Kilner
Hi Niphlod, Thanks for the quick reply. On 21/02/13 13:18, Niphlod wrote: I'll explain the normal behaviour, don't know if it applies to google cloud sql. I think its behaviour is that of MySQL. web2py receives a request. that request execute models. in models you have the db definition.

[web2py] Fixing Failed Migrations

2013-02-21 Thread Philip Kilner
Hi All, I have a failed migration (on Google Cloud SQL, so MySQL, near enough). Looking at the web2py boo, it suggests using: - db.define_table(,migrate=False,fake_migrate=True) ...to find the problem table - done. I then says "This will rebuild web2py metadata about the table according

Re: [web2py] Re: Customising SQLFORM.grid

2013-02-21 Thread Philip Kilner
Hi Niphlod, On 21/02/13 09:47, Niphlod wrote: - I'd like to move the pagination control to the top. Use css rules, or js. Let it be flexible, grid's markup is still experimental (i.e. could change in future versions) OK - is there a decent example of this anywhere? Will roll my sleeves u

[web2py] Customising SQLFORM.grid

2013-02-21 Thread Philip Kilner
Hi, I'm making a lot of use of SQLFORM.grid, which is a great tool, and has saved me an enormous amount of time. Now that I have my application running, I'd like to customise some aspects of it, and wondered if there was a "howto" somewhere, or if anyone has any suggestions about the best way

Re: [web2py] Re: Forcing SSL mode (on GAE)

2013-02-06 Thread Philip Kilner
Hi, On 06/02/13 20:45, howesc wrote: if you want all requests in SSL it sounds like the best thing to me. Yes, it's working very well from my PoV - but my needs are very simple in that I want to force SSL for everything. I'm used to doing this in Apache, so haven't previously had to think a

[web2py] Forcing SSL mode (on GAE)

2013-02-05 Thread Philip Kilner
Hi All, Am just about to test using "request.requires_https()" to force my GAE sessions into SSL mode. Is this the best way to do it (a) generally or (b) on GAE in particular? -- Regards, PhilK 'a bell is a cup...until it is struck' -- --- You received this message because you are sub

Re: [web2py] Interesting about JSON license...

2013-01-30 Thread Philip Kilner
Hi Angelo, On 30/01/13 10:31, Angelo Compagnucci wrote: Please see in Debian the software Douglas Crockford has polluted with that clause! http://codesearch.debian.net/search?q=The+Software+shall+be+used+for+Good%2C+not+Evil Very sad ... I agree, but this: - http://dev.hasenj.org/p

Re: [web2py] Re: GAE Email Sending Issue

2013-01-30 Thread Philip Kilner
Hi Alan, On 30/01/13 13:43, Alan Etkin wrote: > I had understood that web2py detected the server automagically (for mail > as it does for the db) so IOW I believe that "server='gae'" is set in > code, and my working hypothesis is that it is this detection which is > somehow failing. Now I'v

Re: [web2py] Re: GAE Email Sending Issue

2013-01-30 Thread Philip Kilner
Hi Niphlod, On 30/01/13 13:09, Niphlod wrote: try with mail.settings.server = 'gae' Aargh! That did it, and Googling that line took me straight to: - http://stackoverflow.com/questions/2656068/sending-email-from-an-web2py-on-gae ...which I should have found at 8:30 this morning if my Goog

Re: [web2py] Re: GAE Email Sending Issue

2013-01-30 Thread Philip Kilner
Hi Alan, On 30/01/13 12:53, Alan Etkin wrote: I may be wrong, but It seems to me that when creating the mail object in the model, you need to pass explicitly the server='gae' argument. (the class docstring says it so in trunk at least) Perhaps you can test that mail.settings.server is 'gae' bef

Re: [web2py] Re: GAE Email Sending Issue

2013-01-30 Thread Philip Kilner
Hi, On 30/01/13 12:31, Philip Kilner wrote: The more I think about it the more I wonder if the use of the router is an issue Just to close the loop on that, disabling routing made no difference. I've just created a clean app to test, with the following settings for auth and

Re: [web2py] Re: GAE Email Sending Issue

2013-01-30 Thread Philip Kilner
Hi Alan, Thanks for responding! On 30/01/13 12:01, Alan Etkin wrote: Have you updated your app's code before the issue? Yes, I'm in the process of commissioning this app, and have had to make many changes to the model as I import real world data, but none in the relevant period to the appl

[web2py] GAE Email Sending Issue

2013-01-30 Thread Philip Kilner
Hi All, Am trying to resolve an issue with sending email on App Engine. My application throws an "Unable to send email" error, and the logged error is: - 2013-01-30 09:06:16.409 Mail.send failure:The API package 'remote_socket' or call 'Resolve()' was not found. Running locally mail is sen

Re: [web2py] Re: autoroutes.py and static files on GAE

2013-01-24 Thread Philip Kilner
Hi Jonathan, On 24/01/13 15:27, Jonathan Lundell wrote: Have you disabled static file mapping in app.yaml? I hadn't, no - only the app name and the Python version are changed there. -- Regards, PhilK 'a bell is a cup...until it is struck' --

[web2py] Re: autoroutes.py and static files on GAE

2013-01-24 Thread Philip Kilner
Hi, I couldn't make any sense of the issue with autoroutes.py, so had a look in the cookbook, only to find that the functionality I was after (map a host-name to an app) is in the "normal" parameter-based router, and have tested and confirmed that this works as expected on GAE. If I can help

[web2py] autoroutes.py and static files on GAE

2013-01-24 Thread Philip Kilner
Hi All, I'm deploying an app to GAE, and am exploring the routing options. Because my needs are simple (just need to map to app based on hostname) auroroutes.py would be my preferred option. I've used auroroutes.py before behind Apachge without problems, but on GAE my pages work but the CSS,

[web2py] Re: How to use maps in plugin_wiki

2012-09-17 Thread Philip Kilner
Hi Margaret, On Monday, 17 September 2012 21:36:47 UTC+1, greaneym wrote: > > Here is a copy of my model, controller and view files where I got it to > work. > Great, thanks - just what I needed. > You need to obtain a key from google because if more than a default number > of people visit yo

[web2py] Re: How to use maps in plugin_wiki

2012-09-17 Thread Philip Kilner
Hi, Having dug a bit deeper into the options available, it doesn't look like much of a chore to roll my own Google Maps integration. Looking at my choices this one: - http://code.google.com/p/jquery-ui-map/ ...looked promising, but i wondered what others were using? However, I'm now curious

[web2py] How to use maps in plugin_wiki

2012-09-17 Thread Philip Kilner
Hi, I'd like to embed a map in a view, and am trying to use plugin_wiki. I have plugin_wiki installed, and when I use a simpler function, like the YouTube example: - {{=plugin_wiki.widget('youtube',code='l7AWnfFRc7g')}} ...all is well. However, if I try to embed a map, I get a ticket with: -

[web2py] Accessing id in SQLFORM.process()

2012-09-05 Thread Philip Kilner
Hi, I'm trying to wean myself of CRUD and am doing an insert with SQLFORM.process(). I want to redirect on success to view the newly inserted record. How can I access the ID of the new record in this context? Hoped I could do something like: - SQLFORM(db.t_account).process(next=URL(c='accoun

Re: [web2py] New HackerNews discussion about python frameworks - web2py is not getting enough love

2012-03-28 Thread Philip Kilner
Hi, On 28/03/2012 15:08, nick name wrote: Come say the good things you have to say about web2py on http://news.ycombinator.com/item?id=3765610 Late catching up here because I've been following that! Had to call the Django guy out on his (completely unsupported) statement that web2py is "a fu

Re: [web2py] Installing PIL for creating thumbnails in windows7 environment

2012-03-13 Thread Philip Kilner
Hi Praveen, On Tue 13 Mar 2012 17:25:54 GMT, praveen krishna wrote: I treid to install from http://www.pythonware.com/products/pil/ but it is asking to register python 2.7 I tried to register using the script given in link http://effbot.org/zone/python

Re: [web2py] Re: Resources for setting up for development

2012-01-16 Thread Philip Kilner
Hi, On 16/01/2012 01:25, pbreit wrote: My sense is that few Python programmers use IDEs (I don't know any that do). If it's a brief talk, I'd suggest just using the file system and a good text editor and moving quickly to some of the great features of Web2py. If someone complains about code comp

Re: [web2py] Re: Resources for setting up for development

2012-01-15 Thread Philip Kilner
Hi Alan, On Sun 15 Jan 2012 12:37:26 GMT, Alan Etkin wrote: An open source integrated software for development with RAD and support for web2py is being developed by M. Reingart here: http://code.google.com/p/rad2py .He participates in this group, so maybe he can explain in more detail the featur

  1   2   >