[web2py] Re: Is web2py incompatible with 2nd generation Google Cloud SQL ?

Hello Massimo, One more piece of information that might be useful: One Google support person at the "Google App Engine" forum here told me my login attempt was made with password "password", which is NOT the password I set into the environment variable as seen in my attempted hack above, as th

Re: [web2py] Re: How can I union 2 different table datasets?

Postgres supports views and stored procedures. Assuming I can create a query statement to call a view or stored procedure, can't that query be passed to SQLFORM? > On Apr 27, 2017, at 1:20 PM, Richard Vézina > wrote: > > You surely can create a view, if you can, you can mimic one with > db.e

Re: [web2py] Re: lack of documentation

Translation are a work in progress and the english version of the book is the most accurate up to date... You may have better result taking the english version and google translate it... You may consider improving the translation in your native language by forking an submitting PR here : https://g

Re: [web2py] default search widget from SQLFORM.grid only searches the reference field by id but not format=''

Hello Rudy, I am not sure I understand what you mean by : "I can write an action select_quote_by_name() to address it" But, you sould be able to use "company" reference field representation like so : db.define_table('quotation', Field('company', 'reference company',

Re: [web2py] Re: How can I union 2 different table datasets?

You surely can create a view, if you can, you can mimic one with db.executesql() where you do your union, and then construct you grid with web2py html HELPERS() or other means... Sadly you can use SQLFORM.grid() as previously said but it not a big deal as you avoid convulated form processing to mai

[web2py] default search widget from SQLFORM.grid only searches the reference field by id but not format=''

Hi there, I have a quotation table which references the company table. When i created a SQLFORM.grid, I couldn't use the company_name as keyword in the default search widget as company field in the quotation table is integer type (id) even though it's displayed as company_name. I can write an a

[web2py] Re: sql COUNT function and DAL

csp_count = db.table.csp.count() db(db.table).select(db.table.csp, '%s AS freq' % csp_count, groupby=db.table .csp, orderby=~csp_count, limitby=(start, end)) Within a given record, you should be able to access the count via row[csp_count] or row.freq. Anthony On Thursday, Ap

[web2py] Re: How can I union 2 different table datasets?

Does your database support views/materialized views? Anthony On Thursday, April 27, 2017 at 8:48:26 AM UTC-4, George D Elig wrote: > > Unfortunately, I cannot combine the two tables. The existing product uses > one of them extensively for queue processing and I don't want to possibly > break an

[web2py] Re: Problems using @cache.action(valid_statuses=[200])

Sorry to bother in this old thread, but I've noticed that the last stable version of web2py doesn't include the fix that was made previously to correct this bug. I'm trying with last version: 2.14.6-stable+timestamp.2016.05.10.00.21.47 but the bug is there. I checked the source code of gluon/co

[web2py] Re: not authorised flash message when I used SQLFORM.grid, but worked fine with SQLFORM.smartgrid

Hi Massimo, url i used was "localhost:8000/myapp/accounting/list_item2", the actual table i tried to pull data out was named "quotation", it didn't work with SQLFORM.grid(), so i tried the very basic like example grid = SQLFORM.grid(db.auth_user), but still didn't work. But when I used SQLFORM

[web2py] Re: lack of documentation

> > Hi, > First : thank you, it's extacly what I'm searching : to join the translator, to show him. Second : of course I can read it in English, but it takes a little more time :):) Thank you for your awswer. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://

[web2py] Re: How can I union 2 different table datasets?

Unfortunately, I cannot combine the two tables. The existing product uses one of them extensively for queue processing and I don't want to possibly break any of that functionality. All I want to do is update the SQLFORM with information from the new table. I can use db.executesql but won't that

Re: [web2py] Access DB2/400 from IBM i (AS/400) PASE environment

Yes, I was able to get it to connect and the DAL created my tables, but not it won't access them because it is looking for lower case table names and evidently when the tables were created the names became upper case. Since I'm working with this in a Litmis space I don't have full access to do all

Re: [web2py] Re: web2py is not starting with python 3.0/3.1

Yes, cloning the master branch works fine! Thanks, Nico 2017-04-27 13:28 GMT+02:00 Marlysson Silva : > This feature seems to be in a commit of branch's web2py repository , I > think that still do not was merged with master branch .. But cloning the > repository and checking this branch you can r

Re: [web2py] Access DB2/400 from IBM i (AS/400) PASE environment

@Jim any news on this ? Sem vírus. www.avast.com <#DAB4FAD8-2DD7-40BB-A1B8-4E

[web2py] Re: web2py is not starting with python 3.0/3.1

This feature seems to be in a commit of branch's web2py repository , I think that still do not was merged with master branch .. But cloning the repository and checking this branch you can run in py3 enviroment. Em segunda-feira, 24 de junho de 2013 06:19:15 UTC-3, Pradeeshnarayan escreveu: > >

[web2py] Re: sql COUNT function and DAL

You have the table definition written in dal ? To populate them and test . Em quinta-feira, 27 de abril de 2017 07:00:17 UTC-3, Pierre escreveu: > > Hi, > > Is there a way to transform this sql into a valid DAL expression ? > > "SELECT csp, COUNT(csp)AS freq FROM table GROUP BY csp ORDER BY COUN

[web2py] Type of boolean queried from MYSQL: is this a bug of a feature?

I had some difficult time with handling boolean values from MySQL. When I define a table with *db.define_table* and in the Field constructor define *type='boolean'*, the column in the data base becomes a *char(1)*. Values are "*T*" of "*F*". Now when I do a query/select and iterate through the

[web2py] sql COUNT function and DAL

Hi, Is there a way to transform this sql into a valid DAL expression ? "SELECT csp, COUNT(csp)AS freq FROM table GROUP BY csp ORDER BY COUNT(csp) DESC LIMIT %s OFFSET %s;" %(limit,offset) I want to avoid executesql as much as i can.. -- Resources: - http://web2py.com - http://web2py.com/

[web2py] Re: Creating a custom authentication method through http request by passing credentials in URL

i know it is not good but cant find an easy way of authenticating my android app with w2p without creating a new login function On Wednesday, April 26, 2017 at 10:17:16 PM UTC+2, Anthony wrote: > > Not a good idea to put login credentials in a URL -- see > http://stackoverflow.com/a/3150712/4403

[web2py] Re: Displaying images

On Wednesday, April 12, 2017 at 4:31:42 AM UTC-7, Massimo Di Pierro wrote: > > I would do: > > def custom_download(): > filename = request.args(0) > # maybe validate filename > full_path = os.path.join('/whereever/it/is', filename) > return response.stream(full_path) > > and cal

[web2py] Re: lack of documentation

On Wednesday, April 26, 2017 at 6:57:50 PM UTC-7, jean-mic...@meggitt.com wrote: > > Hi, > I'm starting with web2py, it seems a very powerfull tool. > But concerning the documentation, it's difficult to read : in this > document (see link above) it's OK from the beginning up to 75%. After the

Re: [web2py] Re: web2py is not starting with python 3.0/3.1

Hello, I have the same problem now, with the current nightly build. Massimo and others said that it's working now with Python3 (experimentally), so I think I'm missing something obvious... Python 3.6.1 on Windows 10 64 bit, and also Python 3.5.2 on Ubuntu 16.10 Thank you 2013-06-24 12:11 GMT+0

[web2py] Re: How to change menu bar background and font colors

Thank you, those are really helpful. I have learned again. :-) -- 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

[web2py] Re: How to change menu bar background and font colors

What I use to do when I don't want to deal with css changes or creating new classes, just a *quick and dirty solution* is: Right click on the element I want to change – Inspect I get a pane with the html code. For instance, if I try to change the style of navbar, I would right click on LOG