Re: [web2py] Re: How to use requires with list:reference

2014-06-11 Thread Mandar Vaze / मंदार वझे
Anthony, Let me say that you have been tremendous help. On Wed, Jun 11, 2014 at 6:00 PM, Anthony wrote: > Are you saying you want the user to enter a last name for the child and > then have the drop-down dynamically updated with the list of parents with > the entered last name? If so, obviously

[web2py] ERROR when MYSQL try to CAST() to LONGTEXT

2014-06-11 Thread André Kablu
I have a mysql database and created a LIST:INTEGER field It is created in MYSQL as LONGTEXT type of data In one of my queries I have received an error: *WEB2PY QUERY:* db.table.id_field_list.contains(db.table2.id) *MYSQL QUERY:* SELECT * FROM table, table2 WHERE (table.id_field_list LIKE (CO

[web2py] json javascript

2014-06-11 Thread LoveWeb2py
-- 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 "web2py-users" group. To unsub

[web2py] Auto update db records behaviour per input field on release (AJAX)

2014-06-11 Thread Francisco G. T. Ribeiro
hi all, I'm working on an app that uses forms that can be quite long and it's users often interrupt their sessions for whatever reason and end up losing the information already filled. For this and other reasons I wanted to provide a different behaviour to these forms where each input field upda

[web2py] Re: Developer wanted!

2014-06-11 Thread Derek
$8k would cover a minimum wage person for about 5 months. I'm pretty sure it would take a bit longer than that and no developer worth anything would work for minimum wage. That said, you may have luck finding people in other places to do this work for you. On Tuesday, June 10, 2014 2:06:50 PM U

[web2py] Re: json to D3 graph

2014-06-11 Thread Andrew W
P..S. The above uses the approach of the generic.json files. Refer to: http://web2py.com/books/default/chapter/29/10/services?search=serializers and the generic.json code. On Thursday, June 12, 2014 8:20:04 AM UTC+10, Andrew W wrote: > > This may not be the crucial hint, but I noticed that you

[web2py] Re: json to D3 graph

2014-06-11 Thread Andrew W
This may not be the crucial hint, but I noticed that your flare is a list (array). If you checkout the structure at: https://github.com/mbostock/d3/wiki/Cluster-Layout you see that its a dict (or object). Try removing the [] around your flare definition. Secondly: Where I have used XML(json

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

2014-06-11 Thread 黄祥
Hi, Anthony, is it possible to combine the represent for change the color depend on the value with the represent for is_in_set translate above? e.g. table.status.represent = lambda status, field: SPAN(status, _class = 'text-success' if status == 'Sold' else 'text-warning' if status == 'Hold' els

[web2py] Re: Is This Web2py

2014-06-11 Thread Derek
Look at line 35 when you view source. On Tuesday, June 10, 2014 12:43:45 PM UTC-7, Ovidio Marinho wrote: > > http://sentibol.com/ > > Congratulations http://sentibol.com/ourteam > > Universidade de Lavras - Minas Gerais - Brasil. > > > > > > Ovidio Marinho Falcao Neto >

[web2py] Re: PIL library not working with apache 2.2

2014-06-11 Thread Niphlod
lighttpd and nginx for the webserver part, fastcgi, sgci or uwsgi for the python one. On Wednesday, June 11, 2014 8:29:12 PM UTC+2, at wrote: > > > > On Wednesday, 11 June 2014 21:08:43 UTC+5, Niphlod wrote: >> >> this is the relevant excerpt >> >> *Note that the version of Python from which this

[web2py] Re: PIL library not working with apache 2.2

2014-06-11 Thread at
On Wednesday, 11 June 2014 21:08:43 UTC+5, Niphlod wrote: > > this is the relevant excerpt > > *Note that the version of Python from which this baseline environment is > created must be the same version of Python that mod_wsgi was compiled for. > It is not possible to mix environments based on

[web2py] Amazon RDS for PostgreSQL (Beta)

2014-06-11 Thread Michele Comitini
Support for PostgreSQL on RDS: https://aws.amazon.com/rds/postgresql/ -- 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 y

[web2py] Re: Is there a web2py plugin which lays out divs in a neat grid?

2014-06-11 Thread Derek
Ah, I use a different plugin for my website. You can animate or not, that's entirely up to you. Just a note that if you are animating, your animations should be much smoother if you use tweenmax. The grids plugin is called Masonry. http://masonry.desandro.com/ The animation engine is Tweenmax.

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

2014-06-11 Thread Anthony
Sorry, do it this way: mydict = {1: T(''), 2: T('')} Anthony On Wednesday, June 11, 2014 11:24:34 AM UTC-4, Stefan van den Eertwegh wrote: > > Hi Anthony, > > I am sorry but it doesnt work. > Also gives pycharm an error at the rule mydict = dict > > Stefan > > Op woensdag 11 juni 2014 17:06

[web2py] Re: json to D3 graph

2014-06-11 Thread Richard
Andrew, When I respond with flare=flare I get the & issue, solved by XML() Uncaught SyntaxError: Unexpected token & My script starts with:

[web2py] Re: PIL library not working with apache 2.2

2014-06-11 Thread Niphlod
this is the relevant excerpt *Note that the version of Python from which this baseline environment is created must be the same version of Python that mod_wsgi was compiled for. It is not possible to mix environments based on different major/minor versions of Python* Usually people need to reco

[web2py] json to D3 graph

2014-06-11 Thread Andrew W
What else is in your view? Is the code inside a

[web2py] Re: multiple models in a plugin component

2014-06-11 Thread Louis Amon
I found an answer to my own question : I split my model (plugin_name.py) into multiple files (0_settings.py, 1_user.py, etc.) and put them all in a folder ./models/plugin_name/ Web2py does detect that all my model files belong to the same plugin and packs them together. *Another problem happen

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

2014-06-11 Thread Stefan van den Eertwegh
Hi Anthony, I am sorry but it doesnt work. Also gives pycharm an error at the rule mydict = dict Stefan Op woensdag 11 juni 2014 17:06:06 UTC+2 schreef Anthony: > > mydict = dict(1=T(''), 2=T('')) > > db.define_table('mytable', > Field('myfield', represent=lambda v, r: mydict

Re: [web2py] Uploading a Package

2014-06-11 Thread Fabiano Almeida
Hi, If you have application in tgz, unpack and copy to web2py_folder/application/your_application. 2014-06-10 6:26 GMT-03:00 Priyank Yadav : > Hello, > I am new to web2py. Somebody sent me a tgz file which contained the source > code. > I am trying to upload thar code in my admin interface but

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

2014-06-11 Thread Anthony
mydict = dict(1=T(''), 2=T('')) db.define_table('mytable', Field('myfield', represent=lambda v, r: mydict[v])) Anthony On Wednesday, June 11, 2014 10:50:06 AM UTC-4, Stefan van den Eertwegh wrote: > > Hi Anthony, > > Me and my colleges tried it with represent but we cant figure

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

2014-06-11 Thread Stefan van den Eertwegh
Hi Anthony, Me and my colleges tried it with represent but we cant figure it out. Can you give an example how this should work? The table and column is templates.type (key: value) Regards, Stefan van den Eertwegh Op woensdag 11 juni 2014 16:37:13 UTC+2 schreef Anthony: > > The IS_IN_SET validato

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

2014-06-11 Thread Anthony
The IS_IN_SET validator affects form widgets but not other displays of the values in the field. If you want to change the way a value is displayed in a grid (or SQLTABLE), you must use the "represent" attribute of the field. Anthony On Wednesday, June 11, 2014 8:58:54 AM UTC-4, Stefan van den E

[web2py] Re: PIL library not working with apache 2.2

2014-06-11 Thread at
Thanks for the swift reply. I've tried installing PIL as well as Pillow, using binary install on windows and using *pip* and *apt-get install* on ubuntu. Any quick way to verify which python version is being used by apache? Regards On Wednesday, 11 June 2014 18:21:33 UTC+5, Niphlod wrote: > >

[web2py] Re: PIL library not working with apache 2.2

2014-06-11 Thread Niphlod
verify that apache is running the same python version you're running and has PIL installed. This is a well-known issue, but has nothing to do with web2py. On Wednesday, June 11, 2014 2:39:38 PM UTC+2, at wrote: > > facing same issue both on ubuntu and windows7: > > Trying: > from PIL import Imag

[web2py] Web2py grid shows key from IS_IN_SET({key: value}) model

2014-06-11 Thread Stefan van den Eertwegh
Hi all, I have a model where a Field has IS_IN_SET({'1':T(''),2:T('')}). When you have a grid in web2py; When you edit the record you see the value (the translatable string). But when you view the record you see the key of the IS_IN_SET. IS is possible to have the grid showing the value from th

[web2py] Re: PIL library not working with apache 2.2

2014-06-11 Thread at
facing same issue both on ubuntu and windows7: Trying: from PIL import ImageGrab Getting: ImportError: No module named PIL and the strange thing is *no errors* on: from PIL import Image Any help? Thanks On Wednesday, 11 June 2014 15:16:47 UTC+5, Sharjeel Ali Shaukat wrote: > > I m having a pr

Re: [web2py] Re: How to use requires with list:reference

2014-06-11 Thread Anthony
Are you saying you want the user to enter a last name for the child and then have the drop-down dynamically updated with the list of parents with the entered last name? If so, obviously that cannot be done at the time the form is generated on the server because you don't know what name the user

[web2py] Re: PIL library not working with apache 2.2

2014-06-11 Thread Sharjeel Ali Shaukat
I have installed it using PIL binary file from PIL import ImageGrab this is how i m calling the ImageGrab from PIL this line always give me error after running it on apache server -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (So

[web2py] json to D3 graph

2014-06-11 Thread Richard
Dear fellow Web2py user, I am trying to get a json variable into a D3 graph. This was successfull with a simple list of dictionaries within the python/JS vairable. But nof I want to get the famous flare data structure into my view. In the controller I have: def view_dendo(): import json

[web2py] Re: PIL library not working with apache 2.2

2014-06-11 Thread LightDot
Show us some code. How are you importing the library, how are you using it? Regards On Wednesday, June 11, 2014 12:16:47 PM UTC+2, Sharjeel Ali Shaukat wrote: > > I m having a problem when running PIL library with apache i always get > this error > global name 'ImageGrab' is not defined > pleas

Re: [web2py] Re: How to use requires with list:reference

2014-06-11 Thread Mandar Vaze / मंदार वझे
On Tue, Jun 10, 2014 at 11:23 PM, Anthony wrote: > Assuming you have a particular parent last name, it would be: > > IS_IN_DB(db(db.parent.lname == last_name), 'parent.id', db.parent._format, > multiple=True) > > Above would work for a "fixed" last name. But I need it to work with "lambda" - wher

[web2py] PIL library not working with apache 2.2

2014-06-11 Thread Sharjeel Ali Shaukat
I m having a problem when running PIL library with apache i always get this error global name 'ImageGrab' is not defined please help me regarding this issue -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.

[web2py] Re: Problem using multiple grids in single view

2014-06-11 Thread Sarbjit
*Thanks Stifan and * *LaDarrius Stewart !!By using the formnames, I don't see the issues of both the grids displaying the same data. However, I am still not able to use custom grid (grid1) i.e. I want to use custom grid in view_form mode.Code (test1.load){{if grid1.view_form:}}test