[web2py] Re: SQLFORM.grid problems with Oracle database tables

Nico, Thanks for your response. The tables were already joined in the query definition inside the controller. query = ((db2.STATUSPOINT.POINTNUMBER < 100)&\ (db2.STATUSPOINT.POINTACCESSAREA == db2.AOR.AOR)) I feel quite certain that the problem is associated with the extra SQL requ

[web2py] put condition in appconfig

is it possible to put condition in appconfig? e.g. private/appconfig.ini ; environment [environment] type = dev ;type = test ;type = stage ;type = prod ; Environment condition [dev_env] condition = request.application != 'test0' or request.is_https != False or request.env.http_host != '127.0.0.1:

[web2py] Re: Record Versioning not working for just one table (?)

By default, record versioning creates a "current_record" reference field in the archive table to point to the original record (i.e., the current version of the record in the original table), but your table already has its own "current_record" boolean field (which prevents record versioning from

[web2py] Re: Why function definition sequence in default controller matter?

No, the order doesn't matter. Must have been something else wrong. Anthony On Tuesday, September 6, 2016 at 10:43:17 AM UTC-4, Muhammad Radifar wrote: > > Dear all, > > I'm very new to Web2py, and when I tried the examples in Web2py Complete > Reference Manual (5th ed) part 3.2.4 "Say my name",

[web2py] Re: Display Contents of a directory and it's subdirectory and download files .

See if this works for you: http://web2py.com/books/default/chapter/29/14/other-recipes#Publishing-a-folder. If not, I suggest reading the documentation (and possibly the source code for the ab

[web2py] Re: How to not return ticket issue HTML but a custom error?

http://web2py.com/books/default/chapter/29/04/the-core#Routes-on-error Anthony On Tuesday, September 6, 2016 at 10:43:19 AM UTC-4, Ty oc wrote: > > Still I need to log the ticket issue so we know what is happening (we will > be watching for errors to show on the admin webapp), but we dont want t

[web2py] Re: Why passwords are stored in clear text ?

I found the error (reminds me stupid.css:-) I develop on Windows and deploy to Linux I have the following in def user(): if request.args(0)=='register': if runningOn == 'linux': db.auth_user.password.requires = IS_STRONG(min=8, special=1, upper=1) This will effectively replace the CRYPT()

[web2py] Re: Password Recovery Not Sending (lazyT object being passed to GAE?)

Yes, It is also in Google App engine. I could find several differences between files gluon/tools.py I guess it has something to do with it as the GAE warning said, but I can't solve it. This is what I get when I try to request reset password

[web2py] Re: Update javascript object by ajax

Javascript error is: Uncaught TypeError: Cannot read property 'lat' of undefined Do I have to add these '[' at the beginning and '']' at the end like in javascript? Anyway with or without the error is the same. Here is the get_locations result: "[{title: 'In collina 26 a salire e 600 a scendere

[web2py] Re: scheduler task_id assigned to multiple workers

we're handing over 20k a second, the odd thing is if i move the scheduler to mysql the deadlocks stop. The mysql box is much lower specs and we only use for internal stuff so i don't want that to be final solution. On Tuesday, August 30, 2016 at 3:37:41 PM UTC-4, Niphlod wrote: > > if 24cores 2

[web2py] Limit search fields in SQLFORM grid, in search panel

Hi, I have a query please refer to the figure below: [image: Inline image 1] This is SQLFORM.grid table. In the search panel, all the fields of the db table are coming, is there a way we can limit the fields we can perform search on. Any help is appreciated. Thanks in advance, Piklu -- Re

[web2py] Re: redirection using ajax with javascript variables passed in the url.

Please reply.I am stuck at this for quite a long now :( On Friday, September 2, 2016 at 12:01:11 AM UTC+5:30, @brooks wrote: > > > I am doing the following to pass the javascript variable from the view to > the controller: > ##default/rough2.html > > {{extend 'layout.html'}} > > > > >

[web2py] Record Versioning not working for just one table (?)

First of all, web2py rocks...I'm amazed how good it is :) Record versioning is one of the great features and is working perfectly for me except for one table. Can anyone see what the problem might be? Thanks in advance. Here is the definition of the table in question: db.define_table('actions',

[web2py] Display Contents of a directory and it's subdirectory and download files .

I wish to create a webpage that displays the sub- directories of a directory and when clicked on any directory, it lists the files present in that directory. Finally by clicking the file in the directory, I want the user to be able to download that file. Any Help on the Controller and the view

[web2py] Why function definition sequence in default controller matter?

Dear all, I'm very new to Web2py, and when I tried the examples in Web2py Complete Reference Manual (5th ed) part 3.2.4 "Say my name", I was confused because the "Invalid controller (default/index)" error message. After some troubleshooting I figured out the source of the problem. The solution

[web2py] How to not return ticket issue HTML but a custom error?

Still I need to log the ticket issue so we know what is happening (we will be watching for errors to show on the admin webapp), but we dont want the error to be like the HTML that is always show to the user. I want to return a one of the following depending on where Im returning it (a page in t

[web2py] Re: Update javascript object by ajax

definitively you want def get_locations(): return response.json(locations) and $.getJSON instead of $.get. which those changes what errors do you get? On Monday, 5 September 2016 15:51:44 UTC-5, Gael Princivalle wrote: > > Thanks Dave. > > However I'm still having trouble. > > With that

[web2py] Re: crud.delete and record versioning error

please do not use crud. it has not been supported in long time. just use db(...).delete() On Sunday, 4 September 2016 07:16:24 UTC-5, Kirill Shatalaev wrote: > > > Well it seems to me del table[record_id] does not work with record > versioning according to this old discussion: > > https://groups

[web2py] Re: Cannot Create Table Named "Items" - Already Exists

yes. Items is a reserved keyword for this reason. On Friday, 2 September 2016 05:02:52 UTC-5, Dave S wrote: > > > > On Thursday, September 1, 2016 at 6:46:10 PM UTC-7, Brian Boatright wrote: >> >> so it's just something in the web2py code base that has a problem with >> the word "items" as a data

[web2py] Re: Smartgrid search: How do I search on integers and linked tables?

You can customize smartgrid and make your own search function. By default you cannot. On Thursday, 1 September 2016 20:34:27 UTC-5, Luciano Laporta Podazza wrote: > > Hello, > > 1. I noted that Smartgrid does not search on integers unless I select that > specific field on the dropdown search wid

[web2py] Re: redirection using ajax with javascript variables passed in the url.

Use chrome JS console. Is the ajax call executed? On Thursday, 1 September 2016 13:31:11 UTC-5, @brooks wrote: > > > I am doing the following to pass the javascript variable from the view to > the controller: > ##default/rough2.html > > {{extend 'layout.html'}} > > > > > > > var x=doc

[web2py] Re: How can i change my in poweredby submitted NAME and description

I will change it for you asap. On Wednesday, 31 August 2016 03:06:00 UTC-5, Karl Florian wrote: > > I would like to access my submitted poweredby data. > > Where can i sign up to change my data? > I also have a link to my pagepeeker thumbnail, where can I put it? > This is my link: > src='http:/

[web2py] Re: Reddit clone source code?

Did you look here: https://github.com/mdipierro/web2py-recipes-source On Sunday, 28 August 2016 22:21:11 UTC-5, Ron Chatterjee wrote: > > > https://www.packtpub.com/web-development/web2py-application-development-cookbook > > Page 61 > > On Sunday, August 28, 2016 at 8:42:52 PM UTC-4, Massimo Di Pi

[web2py] Re: ERROR:root:New installation error: unable to create welcome.w2p file

Did you do git clone --recursive as explained in the instructions? On Sunday, 28 August 2016 19:41:17 UTC-5, Rommel Sotto wrote: > > I have this error running it on macbook pro > > I installed it thru git clone. > > It does not also show the welcome page when i do 127.0.0.1:8000 > > any thing I ca

[web2py] represent for foreign key table

is it possible to have represent for foreign key table? e.g. db.define_table('address', Field('address', 'text'), Field('zip_code'), Field('city'), Field('country'), format = lambda r: '%s, %s, %s, %s' % (r.address, r.zip_code, r.city, r.country) ) def on_define_id_card(table): """ table.ad

[web2py] Re: how to change color and case of form buttons

You could to get css through the console web chrome ( inspected element ) and add property to your css file.. overwriting them Em quarta-feira, 31 de agosto de 2016 01:35:07 UTC-3, Alex Glaros escreveu: > > how to change colors and letter-case in form below > > form = FORM.confirm('Sure you want