[web2py] Field.Lazy with SQLFORM.grid

2014-05-29 Thread Paolo Valleri
Hi all, I've just discovered that lazy virtual field (aka Field.Lazy) are not shown in a SQLFORM.grid neither implicitly (when all fields of a table are shown) nor explicitly (by selecting the lazy virtual field using fields). In the latter case, the SQLFORM.grid raises an error. The test

[web2py] Re: which version of bootstrap is web2py running?

2014-05-29 Thread Niphlod
source too. https://github.com/web2py/web2py/blob/master/applications/welcome/static/css/bootstrap.min.css On Thursday, May 29, 2014 5:52:56 AM UTC+2, weheh wrote: title says it all -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: sqlform.grid with linked tables

2014-05-29 Thread Mirek Zvolský
To see 2 table grids without any relationship - return from controller: return dict(grid1 = grid(..), grid2 = grid(..)) and render it in view: {{=grid1}} {{=grid2}} For grid(..) syntax you already have examples here. To see parent grid with links to children tables, use smartgrid return dict(grid

Re: [web2py] Re: requires IS_IN_DB set as a union of two queries

2014-05-29 Thread Carlos Costa
Sorry, I should have written: db.owner.own_veh_fk.requires=IS_IN_DB(db(query),'vehicle.id', '%(manufacturer)s %(vin)s') If you need to pass a set so you need to call db(query) in order to execute the query. 2014-05-28 21:46 GMT-03:00 98uj...@gmail.com: I did try: query = query1 | guery2

[web2py] Javascript I use to LOAD forms in modals.

2014-05-29 Thread Leonel Câmara
Hey, I have seen a few people using modals here. So this may be useful to someone. function load_in_modal(url, modal_id, options) { if (typeof options === 'undefined') { /* Example Options: * {title: Add Image, upload_form: true} */ options = {}; } /* *

[web2py] Re: DAL/Decorator for specific data

2014-05-29 Thread Tom Russell
Works perfect, thanks Anthony. On Wednesday, May 28, 2014 11:10:37 AM UTC-4, Anthony wrote: You can include logic to set the readable and writable attributes of particular fields to True/False depending on Auth group membership. For example: db.define_table('mytable', Field('myfield',

[web2py] Google security patch progrem

2014-05-29 Thread Massimo Di Pierro
Find, report and fix a security issue in web2py (or other system) and google may pay you: https://www.google.com/about/appsecurity/patch-rewards/ A rep from google emailed me about this. Massimo -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Personalizar auth

2014-05-29 Thread Natalia Almeyda
Hola! Quisiera averiguar cómo puedo modificar los campos de auth que se ven en la vista?? Gracias!! -- 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) ---

Re: [web2py] Re: not able to include jqueryui in web2py

2014-05-29 Thread sarfaraz ahmed
Thanks for the first reply in this group... This is my first question. I included this in my code with a small mistake. You got it fixed. The accordion started working as per custom them but button are not appearing as required. I have script $(function() { $( #accordion ).accordion(); $(

Re: [web2py] Google security patch progrem

2014-05-29 Thread Michele Comitini
Currently, the scope is limited to the following projects: - ... - ... web2py the only one not in the list! ;-) 2014-05-29 19:16 GMT+02:00 Massimo Di Pierro massimo.dipie...@gmail.com: Find, report and fix a security issue in web2py (or other system) and google may pay you:

[web2py] import right here?

2014-05-29 Thread Pham Quang Dung
I have placed an __init__.py file in the folder (windows) of the controller xyz.py but cannot import abc.py at the same location. Any hints to use path + file name, or copy the abc.py to where? I am newbee, sorry. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: reddit clone - foreign key constraint failed

2014-05-29 Thread Chris Simpson
Hi Uri, Did you ever find a solution to this? On Wednesday, May 14, 2014 12:01:29 PM UTC+2, Uri Tamir wrote: Hi all, I've been following Massimo's video tutorials http://vimeo.com/76047107(which are *great!* thanks Massimo) when trying to build the reddit clone and populate it i get a

[web2py] a simple naive question about the Submit button?

2014-05-29 Thread Pham Quang Dung
Appreciate a simple hint if possible but I spent hours and could not trace anywhere in the code where I could see how to modify the way SQLForm.smartgrid takes a DB actions, such as save or delete. The ultimate purpose is to customize the grid so that I donot need to click View/Edit/Delete per

[web2py] DAL doesn't fully support datetime operations

2014-05-29 Thread Pham Quang Dung
I tried a query like *db().select(xx.writetime - timedelta(minutes=5)) *and the result was totally a surprise because it was of type Int. Thoughts? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: which version of bootstrap is web2py running?

2014-05-29 Thread kyriakopoulos
web2py https://github.com/web2py/web2py / applicationshttps://github.com/web2py/web2py/tree/master/applications/ welcome https://github.com/web2py/web2py/tree/master/applications/welcome/ statichttps://github.com/web2py/web2py/tree/master/applications/welcome/static/

[web2py] Google glyphicons PRO

2014-05-29 Thread Mario Linz
Hi all, We have a problem by using the pro version of goole glyphicons. *Free Version:* For using the free version of the glyphicons on the bootstrap css page there is a very good preview for all available icons + all references the svg paths are set in the *glyphicons.less* file. As example:

[web2py] Urgent required Java Developer - Washington, DC

2014-05-29 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com gurjant.si...@damcosoft.com* *Position: Java Developer* *Location: Washington, DC* *Duration: 6+ Months* *Visa: USC/GC/EAD only* Job Description: Core java skills with some *groovy experience* is must 4-7 yrs exp. Strong communication

[web2py] Using jqueryui button widget

2014-05-29 Thread sarfaraz ahmed
Hello All, I am trying to use customer jquery ui theme. I included file and script in the layout.html. Made changes to view index.html. Everything worked fine except the button. jquery button is not appearing. When I click on inspect element i found it going to bootstrap.min.css. Not sure. I

[web2py] SUM trouble

2014-05-29 Thread Floyd Noel
Hello all, New web2py user here. I'm trying to translate the following query to work in the DAL: SELECT items.description, sum(quantity) FROM orders.items GROUP BY description; This gives me the items together with the quantity totals for each type of item. I'm having trouble getting this to

[web2py] Re: Upload image using RESTful api

2014-05-29 Thread iw3ijq
Found the issue: storage of files is handled by sqlhtml and not by DAL. So I have to write a function that replicate te file storage part of sqlhtml. Il giorno martedì 6 maggio 2014 15:19:22 UTC+2, iw3...@gmail.com ha scritto: Thaks, I will try. I don't think that the iproblem is the

[web2py] ValueError: invalid literal for int() with base 10:

2014-05-29 Thread Tom Russell
I am getting the following error when inserting a new record for a table I have. I cannot seem to pinpoint what the cause is at this time. The error is: Traceback (most recent call last): File /home/tsrdatatech/web2py/applications/ttheorydataextractor/controllers/appadmin.py, line 270, in

[web2py] Re: DAL doesn't fully support datetime operations

2014-05-29 Thread Niphlod
This will never work because there is no notion of timedelta in any db backend (nor any substitute for it). Calculate the result AFTER fetching the rows from the db. On Thursday, May 29, 2014 12:32:41 PM UTC+2, Pham Quang Dung wrote: I tried a query like *db().select(xx.writetime -

[web2py] Re: import right here?

2014-05-29 Thread Niphlod
read the book before posting. from here onwards there is the documentation about third-party modules and the execution environment of web2py. http://web2py.com/books/default/chapter/29/04/the-core#Third-party-modules On Thursday, May 29, 2014 12:40:43 PM UTC+2, Pham Quang Dung wrote: I have

[web2py] Re: SUM trouble

2014-05-29 Thread Niphlod
use this docs to shed some light ^_^ http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum--avg--min--max-and-len On Wednesday, May 28, 2014 10:45:32 PM UTC+2, Floyd Noel wrote: Hello all, New web2py user here. I'm trying to translate the following query to work

[web2py] Re: ValueError: invalid literal for int() with base 10:

2014-05-29 Thread Niphlod
drop the table and recreate it. It's a known issue with sqlite. http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#SQLite On Thursday, May 29, 2014 9:34:28 PM UTC+2, Tom Russell wrote: I am getting the following error when inserting a new record for a table I have. I

[web2py] Re: ValueError: invalid literal for int() with base 10:

2014-05-29 Thread Tom Russell
awesome, worked. On Thursday, May 29, 2014 3:41:12 PM UTC-4, Niphlod wrote: drop the table and recreate it. It's a known issue with sqlite. http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#SQLite On Thursday, May 29, 2014 9:34:28 PM UTC+2, Tom Russell wrote: I

Re: [web2py] Google security patch progrem

2014-05-29 Thread Massimo Di Pierro
I had not noticed. I have asked my contact. On Thursday, 29 May 2014 12:25:10 UTC-5, Michele Comitini wrote: Currently, the scope is limited to the following projects: - ... - ... web2py the only one not in the list! ;-) 2014-05-29 19:16 GMT+02:00 Massimo Di Pierro

[web2py] how to determine the server (name) ?

2014-05-29 Thread Stef Mientki
hello, I'm trying to run the same application on different servers. On each specific server there should be some small differences, so I would like to detect the server on which the web2py application is running. thanks, Stef -- Resources: - http://web2py.com - http://web2py.com/book

Re: [web2py] Google security patch progrem

2014-05-29 Thread Richard Vézina
Ok, so Michele you create the Security hole and we then fix it, that right? Could you let us know when the holes are ready to be filled, so we can focus on something during the meantime?? :D lol Richard On Thu, May 29, 2014 at 4:02 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: I

[web2py] User Registration Form POSTed to Application Root

2014-05-29 Thread RHC
I have a strange problem with an application I have copied from an old web2py 2.0.9 installation to another machine running web2py 2.9.5 When I try and register a new user using the standard user function, the register button POSTS to the application root /CMS/#, instead of the

Re: [web2py] Google security patch progrem

2014-05-29 Thread Michele Comitini
Richard, LOL +1, I was thinking just that :D 2014-05-29 22:34 GMT+02:00 Richard Vézina ml.richard.vez...@gmail.com: Ok, so Michele you create the Security hole and we then fix it, that right? Could you let us know when the holes are ready to be filled, so we can focus on something during

[web2py] Re: User Registration Form POSTed to Application Root

2014-05-29 Thread Anthony
So, the address bar in the browser says http://www.yourdomain.com/CMS/default/user/register, and the form has action=#? On Thursday, May 29, 2014 5:24:13 PM UTC-4, RHC wrote: I have a strange problem with an application I have copied from an old web2py 2.0.9 installation to another machine

[web2py] Re: User Registration Form POSTed to Application Root

2014-05-29 Thread RHC
Yes, that's right. And after the form submission the address bar says http://www.yourdomain.com/CMS/ http://www.google.com/url?q=http%3A%2F%2Fwww.yourdomain.com%2FCMS%2Fdefault%2Fuser%2Fregistersa=Dsntz=1usg=AFQjCNHsw-UKYhz6n9Cfl7FrNNETgfldTA #. I should add, that the user does not get

[web2py] Re: Is there an Easier way to store uploads in the DB (postgres) ?

2014-05-29 Thread Anthony
Note, once you set db._adapter.uploads_in_blob=True, you should not need to explicitly set uploadfield=True in the field definitions, as True is already the default value of that argument. Anthony On Monday, May 19, 2014 2:13:34 PM UTC-4, Anthony wrote: Try: db._adapter.uploads_in_blob =

[web2py] Re: User Registration Form POSTed to Application Root

2014-05-29 Thread Anthony
In the browser developer tools, do you see the browser make a post request with the form data to /CMS/default/user/register# or to /CMS/#? If the former, does the server then issue a redirect? If the latter, it is hard to say what could be happening, as the browser is not supposed to do that.

[web2py] Crud, captcha, and formstyle

2014-05-29 Thread Mark Abajian
Hello web2py users, Does anyone have a workaround or a fix for this potential bug? It seems like crud is not handling captcha properly when formstyle is 'table2cols'. 2.9.5-stable+timestamp.2014.03.16.02.35.39 (Running on Apache/2.2.26 (Unix) mod_wsgi/3.3 Python/2.7.2 mod_ssl/2.2.26

[web2py] Re: how to determine the server (name) ?

2014-05-29 Thread Leonel Câmara
request.env.http_host -- 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