[web2py] markmin as separate package

2015-06-01 Thread Gour
Hello, for simply web sites I want to use Nikola - Python-powered static-site-generator (http://getnikola.com) which supports writing content by using many different markup languages. Yesterday, while chatting on IRC with main developer, I asked him about adding support for markin and he replied

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-06-01 Thread Johann Spies
On 28 May 2015 at 15:28, Anthony abasta...@gmail.com wrote: On Thursday, May 28, 2015 at 6:33:25 AM UTC-4, Johann Spies wrote: Does the db.isi_alt_names.code field contain unique values? If not, I don't think your pagination is guaranteed to work (i.e., you could get back different orderings

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-06-01 Thread Anthony
Just to be clear, the old behavior was a bug (and a particular problem when the user sorted on a column within the grid, which overrides the original orderby). Pagination is a fundamental feature of the grid, so it ought to just work. Note, we cannot leave it up to the developer to explicitly

[web2py] Re: _before_insert / update question

2015-06-01 Thread Ian Ryder
Done - thanks for your help On Friday, May 29, 2015 at 11:48:38 PM UTC+2, Anthony wrote: Yes, this is a bug in bulk_insert -- it calls the _listify method *before* running the _before_insert callbacks instead of after (_listify changes the format from a dictionary to a list of (field,

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-06-01 Thread Johann Spies
After reading the discussion Anthony referred to, I would like to state that I prefer the behaviour of the DAL/Grid query to result in the same outcome as if I would have done with a raw query in PostgreSQL. I test my queries in PG before I implement them in web2py because I work with fairly large

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-06-01 Thread Johann Spies
Thank you for the sermon :) Regards Johann -- 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

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-06-01 Thread Johann Spies
On 1 June 2015 at 13:38, Anthony abasta...@gmail.com wrote: Just to be clear, the old behavior was a bug (and a particular problem when the user sorted on a column within the grid, which overrides the original orderby). Pagination is a fundamental feature of the grid, so it ought to just

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-06-01 Thread Niphlod
just to clarify: the fact that a query in pgadmin returns a somewhat ordered resultset that you're good with, that you test queries in raw postgresql before you implement and that web2py shows the same result with auto_pagination=False is not in ANY scenario an assurance of the fact that your

[web2py] Re: MARKMIN problem with email addresses

2015-06-01 Thread David Manns
Well, yes, interesting. But in the context of email including a '.' at the end of an email address at the end of the address in mailto: does NOT work. RFC 2821 (SMTP) does not seem to address this issue. In practice, it seems that most email servers will not accept the trailing '.' and messages

[web2py] Re: update_record not working but not failing.

2015-06-01 Thread Ian Ryder
I can't give specifics as I had to workaround it but I was having a similar issue last week with update_record. I'm using it everywhere without issue but one particular method wouldn't update and didn't show any error...if I see it again I'll post up and not work around it (I was having trouble

[web2py] Re: update_record not working but not failing.

2015-06-01 Thread peter
Yes, I remember there was a thread about output_record always not working. Here it works most of the time, but very occasionally fails. Peter On Monday, 1 June 2015 16:13:11 UTC+1, Ian Ryder wrote: I can't give specifics as I had to workaround it but I was having a similar issue last week

Re: [web2py] Re: Is there a working bootstrap3 formstyle for auth?

2015-06-01 Thread Richard Penman
Thanks, got it working. I found needed to update web2py to latest version - couldn't just copy this bootstrap3 formstyle function into my current install. On Wednesday, May 27, 2015 at 3:45:25 AM UTC+8, Niphlod wrote: ok, rephrasing... why is it fine in the scaffolding app and not in yours

[web2py] Web2py mobile app using Kivy

2015-06-01 Thread Joe
I developed a web app with Web2py. It works great, I thing Web2py is fantastic. I want to create a mobile app from my web app and I am not sure what is the best approach. Does anyone have any experience using Kivy? Does it work with Web2py? Or, is there a alternative solution to Kivy? --

[web2py] Re: update_record not working but not failing.

2015-06-01 Thread peter
Here is the routine. The emails both before and after get sent fine.. The software sends an email to spinjazzticke...@gmail.com so we have a record of bookings in case of a database meltdown. def paypal_complete_a(): import datetime from paypal import PayPal paypal = PayPal()

[web2py] Re: Field decimal default widget

2015-06-01 Thread Anthony
You can create a custom widget and then do: Field(..., widget=my_custom_widget) Alternatively, if you want to change all decimal widgets generated by SQLFORM without having to bother specifying a custom widget for each field, you could monkey patch gluon.sqlhtml.DecimalWidget or

[web2py] Re: update_record not working but not failing.

2015-06-01 Thread Anthony
And the problem only happens intermittently? If so, is it frequent enough that you could do some logging to figure out what is happening in the cases of failure? If you can do some logging, maybe check things like db._lastsql, transaction.update_record.colset, and transaction.update_record.id

[web2py] My son made a new web2py logo

2015-06-01 Thread Massimo Di Pierro
Time to revamp the web site? -- 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 Groups

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-06-01 Thread Anthony
Thanks Anthony. Correct. I do not want it in all cases. After reading up on it I came accross this link ( http://chrisdone.com/posts/postgresql-pagination) where the author illustrates just how slow PostgreSQL's OFFSET can be which is probably part of my problem in this case. I will

[web2py] Re: support

2015-06-01 Thread Jim S
If you could describe the issue you're having, including the relevant code, we'd be happy to help out. -Jim On Monday, June 1, 2015 at 1:04:20 PM UTC-5, PAWAN RERU wrote: hi please reply me back I need ur help -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Static per template

2015-06-01 Thread Anthony
Why don't you do /static/template1 and /static/template2? On Monday, June 1, 2015 at 2:04:23 PM UTC-4, i...@softmanufacture.com wrote: Hello all, Thanks for the great framework. I have a question: How would I achieve the setup, assume we have different templates: /views/template1

[web2py] Static per template

2015-06-01 Thread info
Hello all, Thanks for the great framework. I have a question: How would I achieve the setup, assume we have different templates: /views/template1 /views/template2 ... so I can switch between templates just passing variable of the template name. (ex: current.config.template_folder) How

Re: [web2py] Reportlab, Platypus and tables

2015-06-01 Thread Felix Penetrante
Thanks for sharing your code. It gave me a clue on how to append tables in the pdf file. I also found a web post (http://www.blog.pythonlibrary.org/2010/09/21/reportlab-tables-creating-tables-in-pdfs-with-python/) that elaborates the use and manipulation of table styles. I incorporated

[web2py] Field decimal default widget

2015-06-01 Thread Pavel Tyurikov
Is it possible to make SQLFORM default widget for decimal field like this: Field('quantity', 'decimal(5,2)', label = 'Price') input type=number step=0.01 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Re: Examples of customizing SQLFORM.grid add/edit/view screens?

2015-06-01 Thread Felix Penetrante
Thanks. This code is so helpful. It worked perfectly. On Thursday, January 30, 2014 at 5:28:49 AM UTC+8, Jim S wrote: Here is what I would do. def manage_employees(): company_id = 1 employees_for_company1 = db().select(db.employees.company_id == company_id) if request(0)

[web2py] Re: Web2py mobile app using Kivy

2015-06-01 Thread eric cuver
good question I am also interested in the answer Le lundi 1 juin 2015 16:19:56 UTC+2, Joe a écrit : I developed a web app with Web2py. It works great, I thing Web2py is fantastic. I want to create a mobile app from my web app and I am not sure what is the best approach. Does anyone have

[web2py] support

2015-06-01 Thread PAWAN RERU
hi please reply me back I need ur help -- 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

[web2py] Recaptcha on pythonanywhere.com https error

2015-06-01 Thread icodk
My recaptcha works fine on an http site but moving it to pythonanywhere.com that uses https break it in the browser(Chrome) As far as I can see the web2py selscts the wrong url (http instead of https) to the google captcha api server. The specific error I get is: Mixed Content: The page at

[web2py] changing grid formname -- response.flash ?

2015-06-01 Thread LoveWeb2py
Hello, Lets say I have grid=SQLFORM.smartgrid(db.table, formname=mytablename) return dict(grid=grid) When I change the form name do I lose the ability to set response.flash? I changed the formname to one of my grid's and when users add a record now they don't get the response that a record

[web2py] Re: My son made a new web2py logo

2015-06-01 Thread Robert Porter
You could almost combine the / / of the W with the II and the pi symbol into one character. On Monday, 1 June 2015 11:06:16 UTC-7, Massimo Di Pierro wrote: Time to revamp the web site? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: My son made a new web2py logo

2015-06-01 Thread Massimo Di Pierro
yes but that's WWII. We only have one W (or 3, but not 2). On Monday, 1 June 2015 14:56:59 UTC-5, Robert Porter wrote: Then again, combining a capital W and the roman numeral II has a pretty specific meaning for most of the world. On Monday, 1 June 2015 11:06:16 UTC-7, Massimo Di Pierro

[web2py] Re: changing grid formname -- response.flash ?

2015-06-01 Thread LoveWeb2py
Thank you for the reply, Massimo! How can I make it say Record Added! when the SQLFORM.grid is processed? I know how to do it for SQLFORM, but not sure how to do it for the grid? On Monday, June 1, 2015 at 4:04:22 PM UTC-4, Massimo Di Pierro wrote: This should not be the case. they logic is

[web2py] How to display Google Maps (iFrame?)

2015-06-01 Thread Robert Porter
I've been beating my head against this for two days, so I'm sorry if it's a dumb question, but I'm really lost. I have googleplaces working and giving me lat/lon data without any problem. Now I want to display this data on a Google Map using web2py. Am I forced to use something like

[web2py] Re: DePy 2015

2015-06-01 Thread Ron Chatterjee
If anyone is interested, the videos are posted here: http://pyvideo.org/ On Wednesday, March 11, 2015 at 4:54:26 PM UTC-4, Massimo Di Pierro wrote: For sponsors: http://mdp.cdm.depaul.edu/DePy2015/default/sponsor_form On Thursday, 26 February 2015 17:39:28 UTC-6, Massimo Di Pierro wrote:

[web2py] Re: changing grid formname -- response.flash ?

2015-06-01 Thread Massimo Di Pierro
This should not be the case. they logic is unrelated. Something else is going on. On Monday, 1 June 2015 14:21:50 UTC-5, LoveWeb2py wrote: Hello, Lets say I have grid=SQLFORM.smartgrid(db.table, formname=mytablename) return dict(grid=grid) When I change the form name do I lose the

Re: [web2py] Re: My son made a new web2py logo

2015-06-01 Thread Richard Vézina
@Robert, you mean War 2... He will surely be a great programmer as his father!! :D Richard On Mon, Jun 1, 2015 at 3:39 PM, Robert Porter fro...@gmail.com wrote: You could almost combine the / / of the W with the II and the pi symbol into one character. On Monday, 1 June 2015 11:06:16

[web2py] Re: My son made a new web2py logo

2015-06-01 Thread LoveWeb2py
It's a nice logo, Massimo. Maybe it could be re-worked a little? I think the current logo looks more polished. On Monday, June 1, 2015 at 2:06:16 PM UTC-4, Massimo Di Pierro wrote: Time to revamp the web site? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: My son made a new web2py logo

2015-06-01 Thread Robert Porter
Then again, combining a capital W and the roman numeral II has a pretty specific meaning for most of the world. On Monday, 1 June 2015 11:06:16 UTC-7, Massimo Di Pierro wrote: Time to revamp the web site? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: markmin as separate package

2015-06-01 Thread Massimo Di Pierro
Feel free to fork and we'll keep it in sync or use your as a subpackage. Anyway, I strongly recommend https://github.com/mdipierro/markmin.js/tree/master instead of the python based markmin. They are not 100% compatible and the latter does a little more but the former does it better. In

[web2py] Re: My son made a new web2py logo

2015-06-01 Thread Massimo Di Pierro
Anyway, I am not suggesting a new logo. I am thinking if anybody wants to submit a new more polished examples app that preserves the content, I am all for it. On Monday, 1 June 2015 14:57:03 UTC-5, Robert Porter wrote: You could almost combine the / / of the W with the II and the pi symbol

Re: [web2py] Re: My son made a new web2py logo

2015-06-01 Thread Richard Vézina
Yes that my point not WII but WII... Anyway, it nice! :) Richard On Mon, Jun 1, 2015 at 4:07 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Anyway, I am not suggesting a new logo. I am thinking if anybody wants to submit a new more polished examples app that preserves the content,

[web2py] Re: Syntax for exiting grid function

2015-06-01 Thread Massimo Di Pierro
Sorry I am very slow today. Can you make a concrete example? On Sunday, 31 May 2015 17:30:57 UTC-5, Alex Glaros wrote: I want to return FROM the grid with a value. The way we normally do using row.id, but in this case, instead of the grid being called outside of the parent function, it is

[web2py] Re: Syntax for exiting grid function

2015-06-01 Thread Alex Glaros
From a view, I call def assign_person_to_role which calls find_people_to_add_roles_and_relationships. User selects a person in the grid find_people_to_add_roles_and_relationships. Then I want to pass that value to assign_person_to_role def find_people_to_add_roles_and_relationships(): #

Re: [web2py] Re: update_record not working but not failing.

2015-06-01 Thread peter hutchinson
I use the ipn_handling from Paypal to check the database. As I do not know why the update_record fails, I am not certain that several fails could not happen in a row. It only happens rarely so I cannot log it. If things go wrong punters turn up to the jazz club having paid and not having a seat,

[web2py] Re: DePy 2015

2015-06-01 Thread Massimo Di Pierro
http://www.pyvideo.org/category/67/depy2015 not all of them yet. On Monday, 1 June 2015 15:03:52 UTC-5, Ron Chatterjee wrote: If anyone is interested, the videos are posted here: http://pyvideo.org/ On Wednesday, March 11, 2015 at 4:54:26 PM UTC-4, Massimo Di Pierro wrote: For

Re: [web2py] Re: My son made a new web2py logo

2015-06-01 Thread Massimo Di Pierro
I think WII and Wii are different enough. On Monday, 1 June 2015 15:11:55 UTC-5, Richard wrote: Yes that my point not WII but WII... Anyway, it nice! :) Richard On Mon, Jun 1, 2015 at 4:07 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Anyway, I am not suggesting a new

Re: [web2py] Re: My son made a new web2py logo

2015-06-01 Thread Carlos Costa
A little off now but I waited for a moment to say that. IT IS ONLY AN OPINION. Maybe the only thing I do not like in Web2py is its name. I really love Web2py and use it and advocate it but this name is not a strength. Many frameworks have better sounding names. I would consider rename it in the

[web2py] RuntimeError: no driver available Sybase

2015-06-01 Thread EF
Hi, I'm new to web2py and trying to test the connectivity to Sybase. I tried testing this on Linux: db = DAL('sybase://myuserid:mypswd@mysybaseserver/mydbname') (please note that I used dummay names in the above statement, but the correct ones when testing.) I got the following error:

[web2py] Validating jQuery disabled form fields?

2015-06-01 Thread Narūnas
def tst() def validate_form(form): err = form.errors if form.vars.SearchType == typeMonthly: form.errors = { k:v for k,v in err.items() if k in [ monthlyMonth,] } elif form.vars.SearchType == typeWeekly: form.errors = { k:v for k,v in

[web2py] Re: changing grid formname -- response.flash ?

2015-06-01 Thread Massimo Di Pierro
if grid.create_form and grid.create_form.accepted: response.flash = 'record created' elif grid.update_form and grid.update_form.accepted: response.flash = 'record updated' this should really go in the book On Monday, 1 June 2015 15:11:28 UTC-5, LoveWeb2py wrote: Thank you for the

[web2py] Silly out of band question about deploying web2py

2015-06-01 Thread Tom Campbell
I am building a SaaS business and am not yet able to hire someone to do the hard stuff (which is everything but the programming). Is there some kind of managed solution I should be looking at, maybe GAE? This message by Lewis

Re: [web2py] Re: Web2py mobile app using Kivy

2015-06-01 Thread Jason (spot) Brower
The best thing to do here is abstract your interface. Web2py does a fine job of it. Most likely your wanting to make the app and then communicate over json objects in post requests. With Kivy you should be able to make something pretty interesting and you can use the same skills you have learned

[web2py] Re: How to display Google Maps (iFrame?)

2015-06-01 Thread 黄祥
just an idea, why not use components for google maps? best regards, stifan -- 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

Re: [web2py] Re: many to many with SQLFORM.grid

2015-06-01 Thread Ben Lawrence
Thanks, so the use of field_id is important! I tried your first test which can be written with the proper field_id *m.id.* This Works: def test1(): id_company = 1 m, cm = db.meeting, db.co_meet q = cm.ref_company == id_company q = q (m.id == cm.ref_meeting) grid =

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-06-01 Thread Derek
Yeah, I had to explain that to a few of my coworkers once. If it's faster to give you your data unordered, and you didn't specify an order, you're going to get it in any kind of order. Like if another query before yours returns the exact same data but it's reverse ordered... well, if you do

[web2py] Re: My son made a new web2py logo

2015-06-01 Thread JorgeH
that logo is soo dull and boring... ps. no ofense. On Monday, June 1, 2015 at 1:06:16 PM UTC-5, Massimo Di Pierro wrote: Time to revamp the web site? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Re: update_record not working but not failing.

2015-06-01 Thread Anthony
I am still bemused that update_record can not know that it has failed and return a result reflecting this. This is standard practice in computing. Maybe this is just a weakness of sqlite I do not know. Well, we don't know where the failure is yet, so hard to say it is the fault of

[web2py] Re: changing grid formname -- response.flash ?

2015-06-01 Thread Anthony
Haven't tried it, but something like this might also work: grid = SQLFORM.grid(..., oncreate=lambda f: response.update(flash='Record Added!'), ...) There's also an onupdate argument. Anthony On Monday, June 1, 2015 at 6:11:04 PM UTC-4, Massimo Di Pierro wrote: if grid.create_form and