Re: [web2py] Re: How to serve multiple domains and multiple applications on nginx using pattern-based route

2013-10-08 Thread IVINH
It work with web2py 2.6.4. Pls review your routes file. Vào 23:36:13 UTC+7 Thứ hai, ngày 07 tháng mười năm 2013, Tito Garrido đã viết: > > This route didn't work for me... > routes_in = (( > (('.*http://demo.ivinh.com.* /*', '/demo')), > (('.*http://demo1.ivinh.com.* /*', '/demo1')) > )) > > Not

Re: [web2py] Re: Why does Web2py add 'orderby' to grid queries?

2013-10-08 Thread Johann Spies
On 7 October 2013 14:45, Tim Richardson wrote: > I'll put this in the book. > > Thanks! Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://githu

[web2py] Re: one more web2py e-commerce app :)

2013-10-08 Thread Gael Princivalle
Hi Adi. Congratulations for this website. I also need to build an e-commerce website and I want to make it with web2py. Can you give me some suggestions ? Il giorno lunedì 16 settembre 2013 16:30:19 UTC+2, Adi ha scritto: > > Just completed a core system at nammuhats.com. Can't praise enough how

Re: [web2py] Re: Why does Web2py add 'orderby' to grid queries?

2013-10-08 Thread Michele Comitini
> db.table(id=3) is for returning the sole matching record, so you don't > have to worry about the database's arbitrary ordering of results. But when > using limitby to return a particular subset of records (e.g., when doing > pagination), don't you need to specify an orderby to guarantee that the

[web2py] DAL query: include aggregate in a SQLFORM.grid column .. no can do?

2013-10-08 Thread Tim Richardson
It seems that I can't use aggregate functions to create a column in a SQLFORM.grid (because I can specify only a query, not a set) Is this correct? I want to select patients with max visit date in a certain date range, this I can do with 'having', but I also want to show that max visit date in

Re: [web2py] Re: Why does Web2py add 'orderby' to grid queries?

2013-10-08 Thread Anthony
> db.table(id=3) is for returning the sole matching record, so you don't >> have to worry about the database's arbitrary ordering of results. But when >> using limitby to return a particular subset of records (e.g., when doing >> pagination), don't you need to specify an orderby to guarantee t

[web2py] grid layout problem

2013-10-08 Thread stefaan
Hello all, I noticed the following when using a grid with some "links" (custom buttons) put at the left, using the default layout (and using ui-style "web2py"): - when the grid is on a large screen, the custom button column takes too much space - on a small screen, the custom buttons overlap wi

Re: [web2py] Re: one more web2py e-commerce app :)

2013-10-08 Thread Adnan Smajlovic
hmm... it's a broad question, so please ask anything more specific and i'll be glad to answer. Here are some of my observations... What was important to me, were speed, mobile readiness (bootstrap responsive design), sending scheduled notification e-mails through scheduler, rather than real-time,

Re: [web2py] Re: Why does Web2py add 'orderby' to grid queries?

2013-10-08 Thread Niphlod
the smartest thing to do would be to avoid orderby when there are less records than paginate. However, it's unusual to have a query misbehaving for a couple hundreds records, and I really don't see the point on using grid with paginate=1. Given that pagination is 99% of the time required, we

[web2py] Re: onselect ajax...

2013-10-08 Thread Avi A
Still stuck with that... Thanks. On Saturday, October 5, 2013 5:29:37 PM UTC+3, Avi A wrote: > > def echo(): > value = request.post_vars.f_item_category > filtered_sub = db(db.t_sub_categories.f_category_id == > value).select(db.t_sub_categories.ALL,orderby=db.t_sub_categories.f_sub_categ

Re: [web2py] Postgres DAL-generated Join syntax woes

2013-10-08 Thread Richard Vézina
Not sure why you need to do that... I don't see how to you created your "alias" though... I guess you do : first = db.fqdn_word_part Did you read about .with_alias()?? Richard On Mon, Oct 7, 2013 at 7:29 PM, Alex W wrote: > I'm seeing an odd (bug?) issue with performing selects with alias

[web2py] Re: DAL query for this SQL

2013-10-08 Thread Dave S
On Monday, October 7, 2013 11:34:53 PM UTC-7, Niphlod wrote: > > sql-wise, that query of yours will have to scan the entire table to find > records, because you're applying a function to a date. Even if you think to > put an index on logtime, the result won't change. > thanks to god, you have dat

[web2py] Re: Blank screen from app/admin/edit button

2013-10-08 Thread Dave S
On Monday, October 7, 2013 11:45:14 PM UTC-7, Niphlod wrote: > > I think you just need to ctrl+f5 reloading the cache of the browser. If > anyone isn't able to edit files through the admin app, it would rain hell > on web2py's developers :P > > You are right again, sir. Thank goodness for people

[web2py] Custom Auth

2013-10-08 Thread GregD
We created a form in the index controller to authenticate users to a database that utilize asp.net membership for authentication. However, we need to turn on Authentication for all forms now, but can't seem to do it since we didn't use the web2py built-in authentication mechanism. Is it possib

[web2py] Re: Blank screen from app/admin/edit button

2013-10-08 Thread Niphlod
On Tuesday, October 8, 2013 7:36:45 PM UTC+2, Dave S wrote: > > On Monday, October 7, 2013 11:45:14 PM UTC-7, Niphlod wrote: >> >> I think you just need to ctrl+f5 reloading the cache of the browser. If >> anyone isn't able to edit files through the admin app, it would rain hell >> on web2py's

[web2py] trying to return data as .json but getting a 404 error when deployed to ubuntu/apache

2013-10-08 Thread Tim Richardson
web2py 4.6.3 & 4.7.2 I have an app which demonstrates a plugin I've made. On my local host using rocket it works fine. When I upload the app to a server, Ubuntu LTS with apache, I get this error (& also with pythonanywhere) GET https://do.growthpath.com.au/google_charts/plugin_google_chart/plu

[web2py] Re: trying to return data as .json but getting a 404 error when deployed to ubuntu/apache

2013-10-08 Thread Niphlod
seems to me that the problem is the missing generic.json. if you turn off generic views on localhost, do you get the same error ? On Tuesday, October 8, 2013 9:08:49 PM UTC+2, Tim Richardson wrote: > > web2py 4.6.3 & 4.7.2 > I have an app which demonstrates a plugin I've made. On my local host >

[web2py] Re: trying to return data as .json but getting a 404 error when deployed to ubuntu/apache

2013-10-08 Thread Niphlod
anyone asking for an action that you have as /appname/default/index will be able to see the dict returned by that function using /appname/default/index.json if you're not used to do return dict(lots_of_things_private_that_the_view_wont_show) you are on the safe side. Security-wise (and mos

[web2py] Re: trying to return data as .json but getting a 404 error when deployed to ubuntu/apache

2013-10-08 Thread Tim Richardson
You're fast. I just noticed this in the book response.generic_patterns = ['*.json'] which solves the problem (in reverse of your suggestion but this is the problem) Is there a security risk in enabling generic.json? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: trying to return data as .json but getting a 404 error when deployed to ubuntu/apache

2013-10-08 Thread Tim Richardson
Thanks again. I also tried making a plugin_return_data.json view and copying the contents of the generic.json view into this new view. and then disabling in models/db.py This works without needing to modify models/db.py with response.generic_patterns = ['*.json'] and it seems like it keeps

[web2py] Two loaded components on one page - How can I refresh both on submit of sqlform.grid in one?

2013-10-08 Thread Jim S
I have a SQLFORM.grid in a loaded component on my page with select boxes. When I click on the submit button I want to refresh the grid, but when that is done I also want to refresh the grid in the other loaded component that is on the page. Is this making sense? Anyone know how I can do tha

[web2py] Re: Two loaded components on one page - How can I refresh both on submit of sqlform.grid in one?

2013-10-08 Thread Stefaan Himpe
Anyone know how I can do that? I did just that yesterday! Here's what I did: I passed a parameter onupdate=ongridupdate to the grid, where def ongridupdate(form): # all kinds of stuff, followed by... redirect(URL("default", "index", extension="html"),client_side=True) -- Resource

[web2py] Re: Two loaded components on one page - How can I refresh both on submit of sqlform.grid in one?

2013-10-08 Thread Niphlod
let's see...what is a grid "with select boxes" ? you mean "checkboxes" ? how is it configured the first grid to "be refreshed" ? On Tuesday, October 8, 2013 10:53:56 PM UTC+2, Jim S wrote: > > I have a SQLFORM.grid in a loaded component on my page with select boxes. > When I click on the submit

Re: [web2py] Custom Auth

2013-10-08 Thread Vinicius Assef
Web2py Auth is a class. You should extend it and in models/db.py you should have something like: auth = MyExtendedAuth() On Tue, Oct 8, 2013 at 2:54 PM, GregD wrote: > We created a form in the index controller to authenticate users to a > database that utilize asp.net membership for authenticat

[web2py] Re: grid layout problem

2013-10-08 Thread lesssugar
web2py's default layout is not responsive. If you're facing problems with displaying the tables, you should overwrite the CSS to adapt the columns behaviour. On Tuesday, October 8, 2013 2:06:13 PM UTC+2, stefaan wrote: > > Hello all, > > I noticed the following when using a grid with some "links

[web2py] Re: Two loaded components on one page - How can I refresh both on submit of sqlform.grid in one?

2013-10-08 Thread Niphlod
let's go with the uber-difficult setup (assuming that you meant "grid with checkboxes" and the "submit button" is the one that shows up when you pass a lambda to selectable) def grid1(): a = 'grid1 %s' % request.now grid = SQLFORM.grid(db.auth_user, formname='grid1', user_signature=Fals

[web2py] Re: Two loaded components on one page - How can I refresh both on submit of sqlform.grid in one?

2013-10-08 Thread Jim S
Niphlod - once again you have decoded my poorly worded question and given me the solution. Yes, I'm talking about checkboxes and refreshing the second grid in a separate component. I will give this a try and report back. Thanks -Jim On Tuesday, October 8, 2013 4:28:59 PM UTC-5, Niphlod wrot

Re: [web2py] Re: Why does Web2py add 'orderby' to grid queries?

2013-10-08 Thread Michele Comitini
Whenever there is a big performance impact it's better not to make assumptions on what is the most common use case. I hate to hear the "web2py is slow" refrain because it's false if you have a good knowledge of web2py. What concerns me is that doing hidden things that impact on performance scares

Re: [web2py] Re: Why does Web2py add 'orderby' to grid queries?

2013-10-08 Thread Derek
If you blame your lack of skill on a framework then you probably shouldn't be using that framework. Limitby is supposed to be use to page though results, or to have a window through results, with the idea being you get to scroll your window. I think perhaps we could add a 'top(#)' operator whic

[web2py] Re: onselect ajax...

2013-10-08 Thread Derek
Yea, sorry about that, the recipe is not quite right, you shouldn't be building the html manually. You should return a dict with the results... write up a small widget to display the options, and use a custom widget (they are called components now?). On Tuesday, October 8, 2013 6:29:03 AM UTC-7

Re: [web2py] Re: Why does Web2py add 'orderby' to grid queries?

2013-10-08 Thread Michele Comitini
I making no suppositions, I just wonder why most of the databases want that ordering is explicitly required in a query where LIMIT BY/FETCH is present? This is not an issue to many, but since one expect that DAL maps almost one to one to SQL syntax, than behavior (assumption) would be unexpected an

[web2py] Re: onselect ajax...

2013-10-08 Thread Derek
This recipe might help you understand how to make it work... http://www.web2pyslices.com/slice/show/1612/ajax-adding-child-records-to-parent Use the 'ajax' function to replace your div (that contains the options list) and let the server render it. My particular 'saveAddresses.html' just has {{=h

[web2py] Re: onselect ajax...

2013-10-08 Thread Derek
I'm working on a new slice, I'll finish it up tomorrow and post it on web2pyslices. It will do the standard cascaded dropdown lists... car / make... On Tuesday, October 8, 2013 5:21:41 PM UTC-7, Derek wrote: > > This recipe might help you understand how to make it work... > > http://www.web2pysl

Re: [web2py] Re: Why does Web2py add 'orderby' to grid queries?

2013-10-08 Thread Anthony
> > Suppose I am new to web2py, but not a newbie to programming and python. I > have a big database and I want to publish things out of it with a nice > framework. I know that accessing the db is critical. I heard web2py is > easy to use. > I do a simple test. I want to know if there are

Re: [web2py] Re: Why does Web2py add 'orderby' to grid queries?

2013-10-08 Thread 黄祥
is it have a big impact on performance when using orderby on grid? should we turn it off the orderby and sortable when not use it on grid (orderby=None and sortable=False)? best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2p

[web2py] I think model load order has changed since 2.6.4; global models are no longer loaded first(?)

2013-10-08 Thread Tim Richardson
In trunk, notice that a conditional model calling/calling_db.py is loading before db.py This is not what 2.6.4 does; it loads db.py first. I have discovered this because I have a conditional model which relies on database variables being created in db.py, and under trunk it breaks. The book sa

[web2py] Is there any timeout settings for server response?

2013-10-08 Thread Jayakumar Bellie
We can set timeout settings for a request sent to the server through ajax. Is there any timeout settings for server response in web2py? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/is

[web2py] Re: HTML error code 206, due to headers not set

2013-10-08 Thread Jayakumar Bellie
Is there any timeout settings? On Monday, October 7, 2013 9:31:52 PM UTC+5:30, Jayakumar Bellie wrote: > > I have also found if there is good internet speed, this problem does not > occur. It works fine with 8 Mbps connection. > > On Monday, October 7, 2013 11:15:43 AM UTC+5:30, Jayakumar Bellie

Re: [web2py] Re: onvalidation upload size

2013-10-08 Thread __pyslan__ - Ayslan Jenken
Massimo, the strange behavior continues to occur... I had to make a change and store the number of lines that the file has. Added a function to the oncreate SQLFORM.grid as follows: def set_total_emails(form): print request.vars.file_name form.vars.file_name = request.post_vars.file_name

Re: [web2py] Re: Why does Web2py add 'orderby' to grid queries?

2013-10-08 Thread Johann Spies
On 8 October 2013 15:24, Niphlod wrote: > the smartest thing to do would be to avoid orderby when there are less > records than paginate. > ... > > What we should orderby to then? The only assured field that has an implicit > index is the id (being a PK). Orderby(ing) a PK should definitely not >