[web2py] Re: Many to many

Thanks a lot Anthony. Now it works. Il giorno giovedì 31 ottobre 2013 00:12:43 UTC+1, Anthony ha scritto: > > > {{for company_image in company_images.select():}} >> > > You've already done a select, so don't call .select() again. > > >> {{for company_image in company_ima

Re: [web2py] Internal Error - Ticket unknown - only over HTTPS?!

1. try to activate logging using logging.conf (see the included example). 2. look in your app errors directory, and see if you find any error file, then go to web2py root dir and launch the shell: python web2py.py -S app2 -M >>> import pickle >>> with open('applications/app/errors/127.0.0.1.2013

Re: [web2py] change web2py application directory

For Windows users who are interested... Now I have 2 separate folders : |_web2py (containing web2py source files with default applications) |_... |_applications |_admin |_welcome |_web2py_apps (folder containing all my apps) |_app1 |_app2 |_... When I upgrade w

Re: [web2py] change web2py application directory

Loic, I find this to be useful, primarily because I want to add just my web2py applications to source control, and not necessarily the web2py installation. Also, am developing this stuff on windows, and actually deploy it on ubuntu. I feel this separation of my apps from the web2py platform is

Re: [web2py] Re: Testing redirection with py.test

Good idea. I'll make it, but it is based on a previous work [1]. I need improve docs for it. [1] http://github.com/viniciusban/web2py.test On Thu, Oct 31, 2013 at 12:11 AM, Massimo Di Pierro wrote: > Can you please make a web2py slice about this? > > > On Monday, 28 October 2013 18:13:22 UTC-5,

Re: [web2py] Re: Join might work? Table limits?

That was my point, Diogo. Is there some fault when we have many explicit joins in DAL? On Wed, Oct 30, 2013 at 4:01 PM, Diogo Munaro wrote: > Hi Vinicius! > The query with a lot of natural joins really don't work, but join with WHERE > worked. > > I don't know what happend, but web2py become cr

[web2py] Re: Invalid literal for long () with base 10: 'ie' - using BEAUTIFY

Hi Niphlod. You're right, there was something wrong in this field, I've delete it and create another one 'integer' and now it works fine. Thanks a lot. Il giorno mercoledì 30 ottobre 2013 21:22:56 UTC+1, Niphlod ha scritto: > > has the cat_id field been a "string" before being a reference in a s

[web2py] Escolher qual base de dados acessar ao entrar no sistema...

Ola, bom dia... Estou desenvolvendo uma aplicação que será disponibilizada para vários clientes, nisso terei para cada cliente um banco de dados (prefeitura).. gostaria de saber dos colegas, como posso identificar o banco de dados que cada cliente deverá ter acesso, no meu arquivo DB.PY, eu te

[web2py] How do I recieve files in a regular post message?

I have various data I can handle but how do I handle the file upload? I can read the message from request.post_vars.file_data. But how do I do things like save it to my uploads directory (or another directory if needed.) I am not using a tradition form because it's data I use in a very different w

Re: [web2py] Escolher qual base de dados acessar ao entrar no sistema...

O Web2py permite trabalhar com vários bancos de dados na mesma aplicação ou escolher a qual deles fazer sua conexão. Assim, fazer o que você sugeriu acima é muito simples. A lógica foi a que você escreveu mesmo. No entanto, precisa ter em mente algumas coisas: 1) Dependendo da quantidade de banco

[web2py] Re: web2py 'way' for windows NET USE?

Thanks Massimo - win32 is new to me, so that helps on many fronts. On Wednesday, October 30, 2013 9:53:02 PM UTC-4, Massimo Di Pierro wrote: > > You can try this: http://code.activestate.com/lists/python-list/44825/ > > not web2py specific but win32 ships with web2py for windows > > On Wednesday,

Re: [web2py] Re: Rich text in text fields

Thanks Tim and Anthony. I have installed CKeditor and it works very nicely. Regards Johann On 18 October 2013 16:59, Anthony wrote: > This (advanced_editor) is not documented in the book as far as I can see. > > > See the end of this > section

[web2py] What is inserting '_2.7.3' into my static url's?

Investing why admin on the server does not use CSS (at least for the initial view and the 'design' view) I found (using Firebug) that the references to the static files look like this:

Re: [web2py] Re: Join might work? Table limits?

Yes, web2py is not ok with it. Making 3 or 4 explicit joins and it gets errors 2013/10/31 Vinicius Assef > That was my point, Diogo. > > Is there some fault when we have many explicit joins in DAL? > > > On Wed, Oct 30, 2013 at 4:01 PM, Diogo Munaro > wrote: > > Hi Vinicius! > > The query with

Re: [web2py] What is inserting '_2.7.3' into my static url's?

Am not sure what is causing the issue. But reading this bit of the documentation may give you a clue: http://web2py.com/books/default/chapter/29/04/the-core#Static-asset-management Kiran Subbaraman http://subbaraman.wordpress.com/about/ On 10/31/2013 5:

[web2py] Re: 2.4.7 problems

Hello everyone, I encountered this problem on 2.2.1 myself, so I checked the trunk source code and it has not moved a lot since. I investigated this problem and found the bug, and thus the correction: https://code.google.com/p/web2py/issues/detail?id=1736#c1 You can now correct if for next version

[web2py] Re: How do I recieve files in a regular post message?

if it's a multipart upload you'd have the corresponding FieldStorage instance on the request.post_vars On Thursday, October 31, 2013 12:53:31 PM UTC+1, encompass wrote: > > I have various data I can handle but how do I handle the file upload? > I can read the message from request.post_vars.file_d

Re: [web2py] change web2py application directory

Loïc, what I was saying is that you will get in trouble when you upgrade web2py with this scenario... Migration from version of web2py to another is sometime not straigh as it should and you found yourself having to go back an forth between both version. In this situation you have sometime to make

Re: [web2py] Re: Testing redirection with py.test

I would like to help you Vinicius, what could I do? Richard On Thu, Oct 31, 2013 at 6:29 AM, Vinicius Assef wrote: > Good idea. > > I'll make it, but it is based on a previous work [1]. I need improve > docs for it. > > [1] http://github.com/viniciusban/web2py.test > > On Thu, Oct 31, 2013 at 1

[web2py] Re: SQLFORM factory field width is less than the text on IE8, works fine on FF

By applying Server-side DOM and parsing ( http://web2py.com/books/default/chapter/29/05/the-views?search=DOM#parent-and-siblings) you could use: my_select = form.element('select[name=TestField]') my_select_parent = my_select.parent my_select_parent['_style'] ='width:400px;' Il giorno giove

[web2py] Loading message using web2py_ajax_page

Hi Folks, Is there a way to render a loading message while web2py_ajax_page is redering the component? Thanks, Tito -- Linux User #387870 . _/_õ|__| ..º[ .-.___.-._| . . . . .__( o)__( o).:___ -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] What is inserting '_2.7.3' into my static url's?

This should be something forget in web2py code I guess, or the activate response.static_version But I think it has been forget, since response.static_version should be from your app. Anyway to workaround this you have to configure appache, read the doc form the link post by Kiran above. :) Rich

[web2py] Re: can grid export represented values rather than raw db values?

This is a big can of worms. represents will often do recursive selects (one per records). When you export all you data in CSV we cannot call it for every record. If that's what you want to do and keep performance, you need to de-normalize your database. On Thursday, 31 October 2013 00:50:08 U

Re: [web2py] Re: Testing redirection with py.test

Thank you, Richard. Basically, I need to isolate web2py.test from my example app and prepare better examples. On Thu, Oct 31, 2013 at 11:59 AM, Richard Vézina wrote: > I would like to help you Vinicius, what could I do? > > Richard > > > On Thu, Oct 31, 2013 at 6:29 AM, Vinicius Assef > wrote

Re: [web2py] Re: Join might work? Table limits?

Are you sure you do not want left joins? Except for this query (db.city.id == db.groups.city_id) everything else seems un-necessary to me and perhaps should be a left join. Perhaps that's what is confusing the DB too. On Thursday, 31 October 2013 07:50:47 UTC-5, Diogo Munaro wrote: > > Yes, web2

[web2py] _filter_fields

Where can I find info about _filter_fields? What does it do? def _filter_fields (self, record, id=False): return dict([(k, v) for (k, v) in record.iteritems

Re: [web2py] Re: Testing redirection with py.test

Ok, I get web2py.test and web2py 2.7.4 (I will test at the same time that web2py.test works well with it). Now, https://gist.github.com/viniciusban/7206413 seems just a example... Should I just add it to web2py.test app? Richard On Thu, Oct 31, 2013 at 11:39 AM, Vinicius Assef wrote: > Thank y

[web2py] add / append to db() set?

Hello, I found this solution : where_1 = (db.auth_user.first_name == 'Jambon') where_2 = (db.auth_user.last_name == 'Forêt Noir') where_3 = '' where_4 = '' where_5 = '' where_6 = '' where_clauses = {'where_1': where_1, 'where_2': where_2, 'where_3': where_3, '

[web2py] Re: _filter_fields

It takes a dictionary-like object (e.g., a web2py Storage object, such as request.vars) and converts it to a dictionary that includes only keys whose names match the fields in the given DAL Table -- so it filters out any keys that are not associated with fields in the table. It is useful if you

Re: [web2py] Re: Testing redirection with py.test

Wait, I didn't read carefully web2py.test more complex than I thought, I thought it was just an app. I will set up a virtualenv. Richard On Thu, Oct 31, 2013 at 12:08 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Ok, I get web2py.test and web2py 2.7.4 (I will test at the same time

Re: [web2py] add / append to db() set?

yes. where = [(db.auth_user.first_name == 'Jambon'), (db.auth_user.last_name == 'Forêt Noir')] # etc etc query = reduce(lambda a,b:a&b, where) rows = db(query).select() On Thursday, 31 October 2013 11:14:22 UTC-5, Richard wrote: > > Hello, > > I found this solution : > > where_1 = (db.auth_user

Re: [web2py] Re: can grid export represented values rather than raw db values?

... or create a SQL view with the formats you need... 2013/10/31 Massimo Di Pierro > This is a big can of worms. represents will often do recursive selects > (one per records). When you export all you data in CSV we cannot call it > for every record. > > If that's what you want to do and keep p

Re: [web2py] What is inserting '_2.7.3' into my static url's?

it's not a forgotten piece of codeit's there for a reason. 1) tell people about response.static_version 2) avoid any errors related to stale browser cache for the admin app files, that is getting more a javascript app than a python one BTW, response.static_version is in web2py since Oct 2012

[web2py] Re: Loading message using web2py_ajax_page

use the "content" attribute of the LOAD helper for that http://web2py.com/books/default/chapter/29/12/components-and-plugins#Components On Thursday, October 31, 2013 3:15:24 PM UTC+1, Tito Garrido wrote: > > Hi Folks, > > Is there a way to render a loading message while web2py_ajax_page is > red

Re: [web2py] What is inserting '_2.7.3' into my static url's?

Doh! :) Richard On Thu, Oct 31, 2013 at 1:00 PM, Niphlod wrote: > it's not a forgotten piece of codeit's there for a reason. > > 1) tell people about response.static_version > 2) avoid any errors related to stale browser cache for the admin app > files, that is getting more a javascript a

Re: [web2py] Re: Loading message using web2py_ajax_page

During the component load it is working, since I am using LOAD() function, I am trying to refresh the component via a button click using web2py_ajax_page... I guess there is no way to add a "loading" during the refresh, right? Regards, Tito On Thu, Oct 31, 2013 at 2:00 PM, Niphlod wrote: > us

Re: [web2py] add / append to db() set?

Thank you Massimo, It will be much simpler... :) Richard On Thu, Oct 31, 2013 at 12:43 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > yes. > > where = [(db.auth_user.first_name == 'Jambon'), (db.auth_user.last_name == > 'Forêt Noir')] # etc etc > query = reduce(lambda a,b:a&b, w

[web2py] Alteração descrição de botões da SQLFORM.grid (Add, Delete)...

Ola, boa tarde Estou usando a SQLFORM.grid para criar alguns formularios q nao necessitam de muito implemento... mas queria alterar algumas coisas, tipo o botao ADD, DELETE.. queria colocar tipo NOVO, DELETAR... com eu acesso ele atraves do ID do controle... -- Resources: - http://web2py.com

[web2py] Re: _filter_fields

Thanks for the great explanation Anthony... -- 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 Go

[web2py] Form confirmation without ajax

I am trying to add a confirmation step to SQLFORM.grid (and possibly SQLFORM.smartgrid eventually). I would like this to work with browsers that disable java script . For example, when deleteing a record, redirect to a confirmation URL that displays the details of the object to be deleted with c

Re: [web2py] embed image from variable

Maybe you want "embed" in html which is much cooler it requires only one single request/response: def index(): form = SQLFORM.factory(Field('x')).process() img64 = None if form.accepted: img = myplotfunction(form.vars.x) img64 = embed64(data=img,extension='image/png') # <- !

[web2py] Re: can grid export represented values rather than raw db values?

If you can live with tab-delimited instead of comma delimited, the TSV format does exactly what you want (it actually downloads with a .csv extension, so it will open up in Excel as is). If you need CSV, perhaps you could copy the gluon.sqlhtml.ExportTSV class and just change the delimiter to a

[web2py] Erro ao criar um campo no postgresql via codigo, e excluir manual...

Ola, boa tarde... Pessoal, o tal do iniciante sobre ne... no meu projeto organizei o codigo no qual via codigo foram criados as tabelas/campos no banco de dados postgresql, dai tava tudo funcionando, eu na curiosidade adicionei mas uma linha para criar mais um campo numa tabela ja existente...

[web2py] web2py calendar

Web2py calendar or datepicker not working in firefox. Any idea why? -- 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

[web2py] Re: Erro ao criar um campo no postgresql via codigo, e excluir manual...

ola, percebi fazendo uns testes aqui.. q se eu tirar essa linha: session.connect(request, response, db=db) nao aparece o erro, mas tambem nao cria as tabelasrss essa linha ta logo abaixo a conexao do banco de dados... -

[web2py] Re: Erro ao criar um campo no postgresql via codigo, e excluir manual...

Could you please post in English? This is an English list and it's impossible to follow either the questions or the answers for all of us that don't speak your language. Thanks and regards On Thursday, October 31, 2013 7:40:42 PM UTC+1, Carlynhos77 wrote: > > ola, percebi fazendo uns testes aq

[web2py] Error creating a field in postgresql via code, and delete manual ...

Hello, good afternoon ... Guys, this newcomer on the ne ... in my project I organized the code in which were created via code tables / fields in database postgresql, give everything was working, I added in curiosity but a line to create another field in a table already exists ... checked qo fie

[web2py] Re: web2py calendar

here it does. post an app to reproduce the issue. On Thursday, October 31, 2013 7:39:09 PM UTC+1, Ramesh Kumar wrote: > > Web2py calendar or datepicker not working in firefox. Any idea why? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/we

[web2py] Re: web2py resources

Thanks for your feedback. I'll check the different Mercurial guides and update my website, if I find a better solution. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Repor

Re: [web2py] Re: Loading message using web2py_ajax_page

if you dig into web2py.js you can find the way to do it, but it's not implemented by default. this is because you could potentially replace a very large fragment of the page with a very little "loading..." content, and this can be bad from a ui interaction perspective. try to elaborate on this,

[web2py] Re: web2py calendar

{{=INPUT(_name='Workingday',_type='date')}} -- 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 Go

[web2py] Re: web2py calendar

in web2py if you want the calendar widget attached to an input you should use _type="string" and _class="date" . What you're using is HTML5 new inputs, and that kind of support is outside the realm of web2py (because every browser will implement its own widget for HTML5 new input types). On Thu

[web2py] Re: web2py calendar

hmm its working. thanks On Friday, 1 November 2013 01:10:25 UTC+5:30, Niphlod wrote: > > in web2py if you want the calendar widget attached to an input you should > use _type="string" and _class="date" . What you're using is HTML5 new > inputs, and that kind of support is outside the realm of we

Re: [web2py] Re: Testing redirection with py.test

Yes, that's the way to go. :-) On Thu, Oct 31, 2013 at 2:28 PM, Richard Vézina wrote: > Wait, I didn't read carefully web2py.test more complex than I thought, I > thought it was just an app. > > I will set up a virtualenv. > > Richard > > > On Thu, Oct 31, 2013 at 12:08 PM, Richard Vézina > wrot

[web2py] Re: GAE compatability with recent web2py versions

My case too was passing a list of values from a reference field. On Wednesday, October 30, 2013 9:59:29 PM UTC-4, Massimo Di Pierro wrote: > > Belongs on GAE has always been supported. The cited code in version 2.7.4 > is > > def BELONGS(self,first,second=None): > if not isinstance(second

[web2py] Ticket issued: unknown after upgrade to 2.7.4 from 2.4.6 and running on GAE SDK

Running standalone in the web2py dev environment, errors produce good tickets. However, when running in the GAE SDK, all I get is "Ticket issued: unknown". I have done these things that I found in the users group: Attention all users: For pre 2.6 applications to work with web2py >=2.6,

Re: [web2py] Ticket issued: unknown after upgrade to 2.7.4 from 2.4.6 and running on GAE SDK

I have ticket issued: unknown when there is bad persmission on web2py folder, sub-folder and files... sudo chown -R www-data.www-data web2py/ Should do the tricks Richard On Thu, Oct 31, 2013 at 4:52 PM, David Manns wrote: > Running standalone in the web2py dev environment, errors produce go

[web2py] SQLFORM.factory same table twice or more...

Hey guys, it's possible to use sqlform to generate same table twice or more? example: form = SQLFORM.factory(db.item,db.item_image,db.item_image,db.item_image) Is there exists a best way? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2

[web2py] Multiple dbs foreign key

Hello guys! I'm using web2py to create new dbs automatically for each company that uses my system. It's using a central DB for authentication and some default tables. I heard that somebody was developing an integration to work with these foreign key inter dbs. Here everything is working, except

Re: [web2py] SQLFORM.factory same table twice or more...

Your table can't have the same field name : http://web2py.com/books/default/chapter/29/07/forms-and-validators?search=One+form+for+multiple+tables#Other-types-of-Forms This only works when the tables don't have field names in common. But you can .clone() your field : https://groups.google.com/d/

Re: [web2py] SQLFORM.factory same table twice or more...

Thx Richard! Clone is amazing!! 2013/10/31 Richard Vézina > Your table can't have the same field name : > > > http://web2py.com/books/default/chapter/29/07/forms-and-validators?search=One+form+for+multiple+tables#Other-types-of-Forms > This only works when the tables don't have field names in c

[web2py] represent of list:reference field

hi, is there a way to have represent of list:reference field? e.g. models db.define_table('book', Field('title'), Field('cover', 'upload'), format = '%(title)s') db.define_table('course', Field('course_name'), Field('description', 'text'), Field('book', 'list:reference book'), Field('lecturer'

[web2py] Re: represent of list:reference field

A list:reference field already gets a default "represent" attribute, as long as the referenced table has a "format" argument. However, the "represent" function (for any type of field) is only applied automatically in particular contexts (e.g., SQLTABLE, the grid, and read-only forms). In your c

[web2py] Re: Ticket issued: unknown after upgrade to 2.7.4 from 2.4.6 and running on GAE SDK

Did you look in the Logs in the GAE Dashboard for your app? That should at least give you the trace for the error, so you are not flying completely blind. - Scott -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Re: represent of list:reference field

great, it works, thank you so much for your detail explaination anthony. btw, i found the others method in this forum something like : {{=', '.join('%s %s' % (lecturer.first_name, lecturer.last_name) for lecturer in header.course.lecturer)}} thanks and best regards, stifan -- Resources: - htt

[web2py] Re: GAE compatability with recent web2py versions

Please open a ticket pointing this thread. We can add support for this. On Thursday, 31 October 2013 15:11:59 UTC-5, David Manns wrote: > > My case too was passing a list of values from a reference field. > > On Wednesday, October 30, 2013 9:59:29 PM UTC-4, Massimo Di Pierro wrote: >> >> Belongs o

[web2py] SELECT/OPTION field (optional)

I want to do a SELECT/OPTION field in a form: db.define_table('cows', Field('type','reference cows_types'), ... db.cows.type.requires = IS_IN_DB(db, db.cows_types.id, '%(type)s') But I want this field be optional and not mandatory Thanks!! -- Resources: - http://web2py.com -

[web2py] Re: SQLFORM with multiple buttons how to differentiate

OK, thanks. I found a workaround; by naming each button differently and instead of checking the value, just check for name in request.vars. On Wednesday, October 30, 2013 6:30:53 PM UTC-6, John Felps wrote: > > I have an sqlform that populates from a db and has several submit buttons > named te

[web2py] How to disable debug in production using spawn-fcgi with nginx?

I have deployed my app but on production it shows stack trace an all info which is not intended. How can I disable this? I am not using custom views. I am just using routes and it's a very minimal app. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.co

[web2py] Regarding checkbox implementation in web2py??

Hie guys I am a newbie in web2py I have added a Field in the table which goes like this: { db.Field('category','list:reference Category',requires=IS_IN_DB(db,'Category.id','Category.Name',multiple=True)) } how to implement it more as a checkbox type what is the syntax for it ??

[web2py] Re: IE11 vs gluon.contrib.user_agent - 'browser' key not existing anymore

Issue 1755 has just been created about this: https://code.google.com/p/web2py/issues/detail?id=1755 Thanks for the update. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (R

[web2py] Re: SELECT/OPTION field (optional)

db.cows.type.requires = IS_EMPTY_OR(IS_IN_DB(db, db.cows_types.id, '%(type)s',zero='')) On Thursday, 31 October 2013 03:17:09 UTC-5, Manu Mora wrote: > > I want to do a SELECT/OPTION field in a form: > > db.define_table('cows', >Field('type','reference cows_types'), > ... > > db

[web2py] Re: IE11 vs gluon.contrib.user_agent - 'browser' key not existing anymore

Should be fixed. On Thursday, 31 October 2013 03:59:09 UTC-5, Baptiste.T wrote: > > Issue 1755 has just been created about this: > https://code.google.com/p/web2py/issues/detail?id=1755 > > Thanks for the update. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - htt

Re: [web2py] Regarding checkbox implementation in web2py??

Hi Akash! Use: db.Field('category','list: reference Category',requires=IS_IN_DB(db,'Category.id','Category.Name',multiple=True), *widget=SQLFORM.widgets.checkboxes.widget*) I think it works 2013/10/31 Akash Agrawall > Hie guys I am a newbie in web2py > I have added a Field in the ta