Re: [web2py] Re: list:reference and orderby

2010-11-17 Thread Johann Spies
On 17 November 2010 16:48, mdipierro wrote: > IS_IN_DB(...,orderby=...) > > Thanks. Now I get Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. Traceback (most recent call last): File "/home/js/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/js/web2py/app

[web2py] Please help: Are these errors?

2010-11-17 Thread Seeker
Hi guys, Please help: Could someone please confirm whether the following two issues are indeed errors or if I am simply doing something wrong. They have both been around for a while now and I am surprised that they have not been noticed yet - which makes me think I may be causing the problem. Ba

[web2py] Precise behaviour of "compute" on record update

2010-11-17 Thread cjrh
Regarding the "compute" attribute of a Field object, the book says this: "compute is an optional function. If a record is inserted and there is no value for a field that has a compute attribute, the value is calculated by passing the record (as a dict) to the compute function." My current testing

[web2py] Customize the Appearance of the menu

2010-11-17 Thread Joe J
Hi all, I'm looking to customize the appearance if the menu on a per controller basis. I found some code in the "old" book that seems to do this. However, when I try to run the below code, I get a "two many values to unpack error". Does anyone know who I might go about doing this? Any help is mu

[web2py] Re: New style 1.89.X forms seem washed out?

2010-11-17 Thread ron_m
I did a fresh download, unpacked, ran the welcome application and hit the register button and the form looks the same as my application. I don't see a way to attach a screen snapshot in the web interface, I guess I need to use the email interface to do that. Ron On Nov 17, 10:12 pm, Phyo Arkar w

Re: [web2py] experts4solutions.com again

2010-11-17 Thread Branko Vukelic
On Thu, Nov 18, 2010 at 4:36 AM, rochacbruno wrote: > Is that a matter of style? Um... more like a matter of styleSHEET. ;) I forgot to correct that. As for aesthetics, I think it can rock both ways, but personally, I think it should use correct capitalization. I'll do that tonite (in about 12 ho

Re: [web2py] Re: postgresql error ... (relation "auth_user" already exists)

2010-11-17 Thread Johann Spies
On 16 November 2010 21:48, Carlos wrote: > > Johann, please send the files when you get this error too. > It happened just now again. I have changed the type of a field from 'date' to 'integer' (I want None or year) and the following typical error occured: Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9

[web2py] session not saving variables?

2010-11-17 Thread Crim
so my website was working yesterday and now for some reason the session variables arnt saving at certain points namely when i try this {{var = db.executesql("""SELECT TOP 1000 [ID] ,[Price] ,[Airport-From-Name] ,[Airport-From-State] ,[Airport-From-City] ,[Ai

Re: [web2py] New style 1.89.X forms seem washed out?

2010-11-17 Thread Phyo Arkar
You seem to got CSS messed up. On 11/18/10, ron_m wrote: > I don't want to sound unappreciative of the new look for the > application, it is a lot of good work and a definite improvement over > all. Maybe I messed something up, I don't think so, but here is what I > find unusual now. > > All form

[web2py] How do we add projects or post a request for a new job on expert exchange?

2010-11-17 Thread Jason Brower
I want to start recommending people come to this site for Jobs and Projects... is that happening yet?

[web2py] New style 1.89.X forms seem washed out?

2010-11-17 Thread ron_m
I don't want to sound unappreciative of the new look for the application, it is a lot of good work and a definite improvement over all. Maybe I messed something up, I don't think so, but here is what I find unusual now. All form controls seem washed out, there are almost no visible borders on text

Re: [web2py] experts4solutions.com again

2010-11-17 Thread Nathan Freeze
Massimo, your bio is missing a pic. Is it okay to endorse you? :) On Wed, Nov 17, 2010 at 9:23 PM, mdipierro wrote: > I have implemented an endorsement mechanism. Existing members can see > and endorse new applicants. New applications should contact existing > members by email and request an end

Re: [web2py] experts4solutions.com again

2010-11-17 Thread rochacbruno
In the expert profile/bio the top title where expert name are shown is all lowecase. Is that a matter of style? Enviado via iPhone Em 18/11/2010, às 01:23, mdipierro escreveu: > I have implemented an endorsement mechanism. Existing members can see > and endorse new applicants. New applicatio

[web2py] experts4solutions.com again

2010-11-17 Thread mdipierro
I have implemented an endorsement mechanism. Existing members can see and endorse new applicants. New applications should contact existing members by email and request an endorsement. 5 endorsements qualify for acceptance as an expert. Endorsements can be withdrawn. Endorsements are confidential. I

[web2py] Re: Recipe about mixing web2py, pydev, GoogleCode and others

2010-11-17 Thread mdipierro
Thanks. This issue comes up often. Very valuable. On Nov 17, 8:17 pm, pierreth wrote: > Hello, > > I just published a blog about mixing all this stuff in Eclipse for > web2py development: > > # GC issue tracking with Mylyn; > # GC versioning using Mercurial and the MercurialEclipse plug-in; > # P

[web2py] Recipe about mixing web2py, pydev, GoogleCode and others

2010-11-17 Thread pierreth
Hello, I just published a blog about mixing all this stuff in Eclipse for web2py development: # GC issue tracking with Mylyn; # GC versioning using Mercurial and the MercurialEclipse plug-in; # Pydev with code completion and code checking; # Aptana Studio plug-in for Eclipse for the edition of HT

[web2py] Re: Error: Edit about end license

2010-11-17 Thread mdipierro
Thank you for the clarification. The reason I could not reproduce (and still cannot) is that this is because of a bug that was fixed this morning in trunk. ;-) Thanks for reporting it anyway. if filetype == 'html' and request.args >= 3: in your version, should be if filetype == 'html' a

[web2py] Re: Error: Edit about end license

2010-11-17 Thread Vollrath
Ok, 1. In dashboard app welcome click about. (admin/default/site) 2. About welcome click in edit (admin/default/about/welcome) 3. result: Internal error: Ticket issued: admin/ 127.0.0.1.2010-11-17.23-59-53.92f42c7d-cee6-4fe5-9794-d6c3c2fbc38c 4. Ticket: Traceback (most recent call last): File "

[web2py] Re: Error: Edit about end license

2010-11-17 Thread mdipierro
Since I cannot reproduce it, perhaps I do not understand. Can you list the steps to reproduce it? Massimo On Nov 17, 3:32 pm, Vinicius Vollrath wrote: > Hi, > > Environment > web2py™ Version 1.89.3 (2010-11-16 13:53:22) > Python Python 2.5.5: /usr/bin/python2.5 > > Traceback (most recent call la

[web2py] Re: Error: Edit about end license

2010-11-17 Thread Vollrath
No, Ubuntu 10.04. On Nov 17, 11:20 pm, mdipierro wrote: > using windows? > > On Nov 17, 7:06 pm, Vollrath wrote:

[web2py] Re: endswith patch in trunk exception message incorrect

2010-11-17 Thread mdipierro
fixed in trunk. On Nov 17, 7:11 pm, ron_m wrote: >     def endswith(self, value): >        if self.type in ('string', 'text'): >            return Query(self, ' LIKE ', '%%%s' % value) >        else: >            raise RuntimeError, "startswith used with incompatible > field type" > > The last li

[web2py] Re: Error: Edit about end license

2010-11-17 Thread mdipierro
using windows? On Nov 17, 7:06 pm, Vollrath wrote: > version 1.89.3 (2010-11-16 13:53:22) > I download the trunk (for developers) inhttps://web2py.googlecode.com/hg/ > > [ ]'s > Vinicius > > On Nov 17, 9:15 pm, mdipierro wrote: > > > Eu não posso reproduzir isso.Qual a versão? > > > Em 17 de nov

Re: [web2py] ajax push

2010-11-17 Thread Phyo Arkar
Very cool framework . But how web2py gonna work with as it have no serverside support for python ? We may be have to run 2 servers 1 for web2py and just 1 alone for Pushes .. Anyone have used it in real applications? On Tue, Nov 16, 2010 at 3:54 AM, Michele Comitini < michele.comit...@gmail.co

[web2py] endswith patch in trunk exception message incorrect

2010-11-17 Thread ron_m
def endswith(self, value): if self.type in ('string', 'text'): return Query(self, ' LIKE ', '%%%s' % value) else: raise RuntimeError, "startswith used with incompatible field type" The last line should be raise RuntimeError, "endswith used with i

[web2py] Re: Error: Edit about end license

2010-11-17 Thread Vollrath
version 1.89.3 (2010-11-16 13:53:22) I download the trunk (for developers) in https://web2py.googlecode.com/hg/ [ ]'s Vinicius On Nov 17, 9:15 pm, mdipierro wrote: > Eu não posso reproduzir isso.Qual a versão? > > Em 17 de novembro, 03:32, Vinicius Vollrath terradigital.com.br>escreveu:

[web2py] Re: Unable to detect your browser

2010-11-17 Thread mdipierro
you should set the environment variable BROWSER http://docs.python.org/library/webbrowser.html On Nov 17, 5:31 pm, greenpoise wrote: > Ok, I must admit, I am one of those with a weird setup. I dont have > firefox, seamonkey, IExplorer. I just happen to have Chromium and > Opera as my two browser

[web2py] Unable to detect your browser

2010-11-17 Thread greenpoise
Ok, I must admit, I am one of those with a weird setup. I dont have firefox, seamonkey, IExplorer. I just happen to have Chromium and Opera as my two browsers. When I try to load web2py I get this error: Traceback (most recent call last): File "web2py.py", line 20, in import gluon.widget

[web2py] Re: web2py and distributed computing

2010-11-17 Thread mdipierro
You can import rpyc and use it already. Anyway, I am going to look more into this. Do you have something specific in mind? On Nov 17, 5:12 pm, VP wrote: > I am wondering if it is feasible and even easy to incorporate > something like RPyC into web2py.   Ideally, I would like to have an > app call

[web2py] Re: Error: Edit about end license

2010-11-17 Thread mdipierro
I cannot reproduce this. Which version? On Nov 17, 3:32 pm, Vinicius Vollrath wrote: > Hi, > > Environment > web2py™ Version 1.89.3 (2010-11-16 13:53:22) > Python Python 2.5.5: /usr/bin/python2.5 > > Traceback (most recent call last): >   File "/home/vinicius/www/plocme/gluon/restricted.py", line

[web2py] web2py and distributed computing

2010-11-17 Thread VP
I am wondering if it is feasible and even easy to incorporate something like RPyC into web2py. Ideally, I would like to have an app calling a web2py app located in a different server without too much hassle (web2py taking care of the technical details). Can we have this feature in web2py? :-)

[web2py] Error: Edit about end license

2010-11-17 Thread Vinicius Vollrath
Hi, Environment web2py™ Version 1.89.3 (2010-11-16 13:53:22) Python Python 2.5.5: /usr/bin/python2.5 Traceback (most recent call last): File "/home/vinicius/www/plocme/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/vinicius/www/plocme/applications/admi

[web2py] Re: import csv automatic

2010-11-17 Thread Aurigadl
#This was my solution. import os db.define_table('sgd_pa_cont_continente', Field('cont_nombre',writable=False, required=True, notnull=True)) appfolder = os.path.normpath(request.folder) fileCsv = os.path.join(appfolder, 'static','continente.csv') db.import_from_csv_file(open(fileCsv, 'rb'

[web2py] Re: Upgrade problem

2010-11-17 Thread mdipierro
hmmm. I can make the error go away but this is a path issue On Nov 17, 3:31 pm, Kenneth Lundström wrote: > I tried to upgrade version 1.89.1 to 1.89.3. I got the following error. > > I m running Linux, Apache and mod_wsgi. Is this too an file permission > problem. I still can t create a new appli

[web2py] Re: decimal validator by default or not

2010-11-17 Thread mdipierro
4,2 have to do with precision, not range. On Nov 17, 4:18 pm, Richard Vézina wrote: > Ok, > > I think I wrongly define the IS_DECIMAL_IN_RANGE > > I set it to (0,99.99) > > And now the validators works. > > Still wondering if IS_DECIMAL_IN_RANGE as to be explicitly define since the > decimal(4,2)

Re: [web2py] Re: decimal validator by default or not

2010-11-17 Thread Richard Vézina
Ok, I think I wrongly define the IS_DECIMAL_IN_RANGE I set it to (0,99.99) And now the validators works. Still wondering if IS_DECIMAL_IN_RANGE as to be explicitly define since the decimal(4,2) were already available Richard On Wed, Nov 17, 2010 at 4:06 PM, Richard Vézina wrote: > Just

[web2py] Re: many to many inline form

2010-11-17 Thread Joe Wakefield
I'm still learning widget stuff, and while I can design a many-to-many widget, I am having trouble visualizing how to produce one with extra fields and buttons for adding/removing. I might strike an epiphany, but I'll likely just wait for you to make something available. On Nov 12, 11:27 am, mdipi

[web2py] Re:

2010-11-17 Thread villas
On Nov 17, 3:12 pm, Napoleon Moreno wrote: > I found the answer in the book , like is usual Great news Napoleon! Sorry I didn't see your post until after I'd replied :)

[web2py] Upgrade problem

2010-11-17 Thread Kenneth Lundström
I tried to upgrade version 1.89.1 to 1.89.3. I got the following error. I´m running Linux, Apache and mod_wsgi. Is this too an file permission problem. I still can´t create a new application with admin. Don´t know where to start looking for the problem. Kenneth Version web2py™ Version 1.89

[web2py] verification login

2010-11-17 Thread mattynoce
hi, i hope this is an easy question, but i didn't find answers elsewhere in the forum. here's what i'm looking to do: 1) a parent registers with the site 2) the parent registers her child using just an email address 3) the child receives the verification email, and clicks on the link 4) the child

[web2py] Re: How to setup plugin_wiki?

2010-11-17 Thread Dan
Thank you very much. Everything works fine if you use the simple way to create an new application. In the beginning I was using the new wizard and many things went wrong. E.g. everytime I was using the registration forumular the system adds 100 random users + mine. On 17 Nov., 21:07, mdipierro wr

[web2py] Re: plugin_wiki won't set active flag in response.menu?

2010-11-17 Thread mdipierro
Plugin wiki is not very smart. That needs to be improved. On Nov 17, 3:12 pm, Dan wrote: > Just tried to build my onw menu based on the pages from plugin_wiki > but every active flag in response.menu is set to false. Is there any > onther way to determine if a wiki page is active?

[web2py] plugin_wiki won't set active flag in response.menu?

2010-11-17 Thread Dan
Just tried to build my onw menu based on the pages from plugin_wiki but every active flag in response.menu is set to false. Is there any onther way to determine if a wiki page is active?

Re: [web2py] Re: decimal validator by default or not

2010-11-17 Thread Richard Vézina
Just to be sure... Data are entered in english... Mean if we entered exactly this in the form fiel : 123.123 On Wed, Nov 17, 2010 at 3:59 PM, Jonathan Lundell wrote: > On Nov 17, 2010, at 12:26 PM, mdipierro wrote: > > > > could be. Not sure what that means for decimal numbers. > > FWIW, I took a

[web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread Anthony
You should encourage every expert to provide as much bio detail as possible (some have none at all), or at least link to a personal or business website -- potential customers will want some details before making contact. Also, everyone should have a location listed -- "undisclosed location" makes i

Re: [web2py] Re: decimal validator by default or not

2010-11-17 Thread Jonathan Lundell
On Nov 17, 2010, at 12:26 PM, mdipierro wrote: > > could be. Not sure what that means for decimal numbers. FWIW, I took a look at the Python decimal module, and it requires '.' as the decimal separator. So any conversion is going to have to happen before Decimal gets the string. > > On Nov 1

[web2py] Re: experts4solutions badges

2010-11-17 Thread Branko Vukelic
Here are some badges for experts4solutions members. The 'button' version comes in two flavors: for dark background ('_d') and for light background ('_l'). -- Branko Vukelić bg.bra...@gmail.com stu...@brankovukelic.com Check out my blog: http://www.brankovukelic.com/ Check out my portfolio: http

Re: [web2py] Re: crud operations for joins?

2010-11-17 Thread Ivan Matveev
> In the example I provide (entity), specifically for web2py and > relational databases, does it actually make sense to separate 'entity' > to its own table and use 1:1 relationships from tables A/B/C, or is it > recommended to just embed the 'entity' fields into tables A/B/C > (without any referen

Re: [web2py] Re: decimal validator by default or not

2010-11-17 Thread Richard Vézina
The french in the ticket should comes from the ubuntu locales setting, I see no python packages related to the local... Richard On Wed, Nov 17, 2010 at 3:43 PM, Richard Vézina wrote: > No change with nav set to en-us and with firefox. > > Richard > > > On Wed, Nov 17, 2010 at 3:35 PM, Richard V

[web2py] Re: crud operations for joins?

2010-11-17 Thread villas
Hi Carlos In the relational model, you would separate it. The idea is that you group your data into logical datasets (tables), then you join it all together by using foreign keys. The idea is that data only ever has to be entered once and there is little wasted space. These days we also have th

[web2py] Re: Easy to do using executesql, how to achieve with DAL?

2010-11-17 Thread Niphlod
+1 for examples, it's quite unusable. that is also accomplished with this query, only if not seeking other values db4(db4.data_table).select(db4.data_table.reqtime, limitby=(0,1), orderby=db4.data_table.reqtime) Niphlod On 17 Nov, 20:57, Lorin Rivers wrote: > I think this would make a goo

Re: [web2py] Re: decimal validator by default or not

2010-11-17 Thread Richard Vézina
No change with nav set to en-us and with firefox. Richard On Wed, Nov 17, 2010 at 3:35 PM, Richard Vézina wrote: > In the database table decimal are represented like this : 123.123 > > When I export data the "." is replaced by the comma, but I think that > depend of the local of the system or t

Re: [web2py] Re: decimal validator by default or not

2010-11-17 Thread Richard Vézina
In the database table decimal are represented like this : 123.123 When I export data the "." is replaced by the comma, but I think that depend of the local of the system or the local I specified in the pgadmin export panel... What the relation between the local of the database and the and the len

[web2py] Re: decimal validator by default or not

2010-11-17 Thread mdipierro
could be. Not sure what that means for decimal numbers. On Nov 17, 2:07 pm, Richard Vézina wrote: > I use postgresql and local in postgres are : fr_CA.UTF-8 > > Could it be the reason of the problem? > > Richard > > On Wed, Nov 17, 2010 at 2:37 PM, mdipierro wrote: > > BTW... why are you getting

Re: [web2py] Re: list:reference issue

2010-11-17 Thread Richard Vézina
Thanks You are involved in a lot of dev... I understand the delay, no problem. It is just a kind of reminder ;-) Richard On Wed, Nov 17, 2010 at 2:31 PM, mdipierro wrote: > will look into this asap. > > On Nov 17, 11:49 am, Richard Vézina > wrote: > > Hello, > > > > The list:reference issue I

[web2py] Re: How to setup plugin_wiki?

2010-11-17 Thread mdipierro
http://www.web2py.com/book/default/chapter/13 On Nov 17, 2:03 pm, Dan wrote: > Hi, I just downloaded web2py and added the plugin_wiki plugin. But I > don't find any documentation on how to use this plugin. I saw the > video on vimeo but the plugin does not add a new node to the main > menu. If I'

Re: [web2py] Re: decimal validator by default or not

2010-11-17 Thread Richard Vézina
I use postgresql and local in postgres are : fr_CA.UTF-8 Could it be the reason of the problem? Richard On Wed, Nov 17, 2010 at 2:37 PM, mdipierro wrote: > BTW... why are you getting the traceback in french? If your python is > localized, could this affect the meaning of . in sqlite? > > On No

[web2py] How to setup plugin_wiki?

2010-11-17 Thread Dan
Hi, I just downloaded web2py and added the plugin_wiki plugin. But I don't find any documentation on how to use this plugin. I saw the video on vimeo but the plugin does not add a new node to the main menu. If I'm calling the plugin in the url I'm getting an error: Not authorized ACCESS DENIED. Th

Re: [web2py] Re: Easy to do using executesql, how to achieve with DAL?

2010-11-17 Thread Lorin Rivers
I think this would make a good thing to have in the examples. On Nov 17, 2010, at 13:45 , Massimo Di Pierro wrote: > my mistake > > m=db4.data_table.ReqTime.min() > firsttime = db4(db4.data_table).select(m).first()[m] > > On Nov 17, 2010, at 1:44 PM, Lorin Rivers wrote: > >> m=db4.data_table.R

[web2py] Re: Beginner's Question

2010-11-17 Thread mdipierro
The problem is here > db.task.id_person_released.requires = IS_IN_DB( db,'person.initials', > '%(initials)s | %(name_first)s %(name_last)s') and 'person.initials' shoud be 'person.id' for a reference field. You also have a | instead of an &. Anyway, here is a more compact notation that

Re: [web2py] Re: Easy to do using executesql, how to achieve with DAL?

2010-11-17 Thread Massimo Di Pierro
my mistake m=db4.data_table.ReqTime.min() firsttime = db4(db4.data_table).select(m).first()[m] On Nov 17, 2010, at 1:44 PM, Lorin Rivers wrote: > m=db4.data_table.ReqTime.min() > firsttime = db4(db4.data_table).select().first()[m]

Re: [web2py] Re: Easy to do using executesql, how to achieve with DAL?

2010-11-17 Thread Lorin Rivers
Massimo, That pegs my CPU for a bit and then errors: File "/Users/lrivers/Documents/CurrentProjects/SPTI/spowertech_webappserver1/gluon/sql.py", line 734, in __getitem__ return dict.__getitem__(self, key) KeyError: 'MIN(data_table.ReqTime)' Here's my code: m=db4.data_table.ReqTime.min() f

[web2py] Beginner's Question

2010-11-17 Thread asklucas
Hello! I'm new to web development and my trying web2py because of DRY and, most importantly, Python. I created a model, however I can't insert records in the admin interface because of a constraints-error I don't understand. When trying to insert a record here: http://127.0.0.1:8000/task/appadm

[web2py] Re: social network, event planners, and the like?

2010-11-17 Thread mdipierro
Not exactly but this is a good place to start: http://web2py.com/appliances/default/show/71 On Nov 17, 12:59 pm, Carlos wrote: > Hi, > > In a future project I might need capabilities like social network, > event planners (e.g. weddings, parties), and the like. > > I'm wondering if there's someth

[web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread mdipierro
here are many things the need refactoring. we need a public list of approved experts (the same as now, but random order and pagination) and a private list of everybody who registered to that existing experts can endorse new applicants. massimo On Nov 17, 10:35 am, Branko Vukelic wrote: > On W

[web2py] Web2py Application Exhibition ( Version 2.0 ) 4 weeks to go

2010-11-17 Thread NetAdmin
Just in case you didn't see the "pinned" message at the top of the group messages, there are 5 weeks to get your apps ready for the Web2py Application Exhibition ( Version 2.0 ) For more details, see the "pinned" message. Good Luck! Mr.NetAdmin

[web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread mdipierro
I doubt you are getting a web2py error. You are probably getting a RuntimeError or ProgrammingError from sqlite. On Nov 17, 10:19 am, António Ramos wrote: > AHH, found a big problem! > I need to create a table with 940 fields and web2py complains that it is > over 255 > > What to do to resolv

[web2py] Re: decimal validator by default or not

2010-11-17 Thread mdipierro
BTW... why are you getting the traceback in french? If your python is localized, could this affect the meaning of . in sqlite? On Nov 17, 9:43 am, Richard Vézina wrote: > Hello, > > I wonder if it is normal that I get ticket in that case : > > Model : > > Field('field1','decimal(4,2)'), > > If I

[web2py] Re: decimal validator by default or not

2010-11-17 Thread mdipierro
what python version? perhaps something has changed in sqlite? this looks like a sqlite error. On Nov 17, 9:43 am, Richard Vézina wrote: > Hello, > > I wonder if it is normal that I get ticket in that case : > > Model : > > Field('field1','decimal(4,2)'), > > If I insert in form generate with crud

[web2py] Re: Validate dynamically generated select SQLFORM.factory

2010-11-17 Thread mdipierro
btw you can do requires=IS_IN_SET(...,multiple=True,_and=IS_NOT_EMPTY()) On Nov 17, 1:33 pm, mdipierro wrote: > > DenesL I agree that "multiple should mean 1 or more, not zero or more." > > I disagree. Multiple means 0 or more. Anyway, we cannot change this. > > On Nov 17, 12:06 pm, Kostas M wr

[web2py] Re: Validate dynamically generated select SQLFORM.factory

2010-11-17 Thread mdipierro
> DenesL I agree that "multiple should mean 1 or more, not zero or more." I disagree. Multiple means 0 or more. Anyway, we cannot change this. On Nov 17, 12:06 pm, Kostas M wrote: > At first thanks villas for the correction of the boolean 'multiple' > argument. > > DenesL I agree that "multiple

[web2py] Re: list:reference issue

2010-11-17 Thread mdipierro
will look into this asap. On Nov 17, 11:49 am, Richard Vézina wrote: > Hello, > > The list:reference issue I discribed last week is still in trunk. I joint a > demo app with which it is possible to reproduce the issue. > > If the date validator is triggered and the id of the referenced record is

[web2py] Re: Easy to do using executesql, how to achieve with DAL?

2010-11-17 Thread mdipierro
m=db.data_table.reqtime.min() value = db(db.date_table).select().first()[m] On Nov 17, 11:43 am, Lorin Rivers wrote: > executesql('select min(reqtime) from data_table;') > -- > Lorin Rivers > Mosasaur: Killer Technical Marketing > > 512/203.

[web2py] social network, event planners, and the like?

2010-11-17 Thread Carlos
Hi, In a future project I might need capabilities like social network, event planners (e.g. weddings, parties), and the like. I'm wondering if there's something already out there - preferably free open source, and obviously developed with web2py?, or at least in python?. If there's nothing, is i

[web2py] Re: crud operations for joins?

2010-11-17 Thread Carlos
Thanks villas. In the example I provide (entity), specifically for web2py and relational databases, does it actually make sense to separate 'entity' to its own table and use 1:1 relationships from tables A/B/C, or is it recommended to just embed the 'entity' fields into tables A/B/C (without any r

[web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread cjrh
On Nov 17, 6:19 pm, António Ramos wrote: > What to do to resolve this? i dont want to partition my table because the > record realy has 940 fields in my database (Lotus Notes) I would love to see a summary of that schema, because with that number of fields it sounds like you're beginning to fail

Re: [web2py] Re: decimal validator by default or not

2010-11-17 Thread Jonathan Lundell
On Nov 17, 2010, at 9:40 AM, Richard Vézina wrote: > Doesn't neither with IS_DECIMAL_IN_RANGE(0,99), I get the same ticket... The doctest for IS_DECIMAL_IN_RANGE is currently broken (Massimo, I'll send you a patch), but these all pass: >>> IS_DECIMAL_IN_RANGE(0,99)(123.123) (123.

[web2py] Re: Validate dynamically generated select SQLFORM.factory

2010-11-17 Thread Kostas M
At first thanks villas for the correction of the boolean 'multiple' argument. DenesL I agree that "multiple should mean 1 or more, not zero or more." Making though the following test: >>> IS_IN_SET(['max', 'john'])('') ('', 'value not allowed') >>> IS_IN_SET(['max', 'john'], multiple=True)('') (

Re: [web2py] Re: How may I revoked a user logged in "server side"

2010-11-17 Thread Richard Vézina
Forgot about this one... My error cause of mixup between dev db and prod db... ;-D Richard On Wed, Nov 17, 2010 at 11:50 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Hello, > > I note that "blocked" in registration_key not prevent the user to login > under 1.88.2... > > Is the keyw

[web2py] Easy to do using executesql, how to achieve with DAL?

2010-11-17 Thread Lorin Rivers
executesql('select min(reqtime) from data_table;') -- Lorin Rivers Mosasaur: Killer Technical Marketing 512/203.3198 (m)

Re: [web2py] Re: decimal validator by default or not

2010-11-17 Thread Richard Vézina
Doesn't neither with IS_DECIMAL_IN_RANGE(0,99), I get the same ticket... Richard On Wed, Nov 17, 2010 at 12:24 PM, villas wrote: > Sorry I misunderstood. I think you are right, web2py doesn't validate > it. > -D > > On Nov 17, 5:00 pm, Richard Vézina > wrote: > > I don't want to store 123.123,

[web2py] Re: decimal validator by default or not

2010-11-17 Thread villas
Sorry I misunderstood. I think you are right, web2py doesn't validate it. -D On Nov 17, 5:00 pm, Richard Vézina wrote: > I don't want to store 123.123, I want 99.99 max. > > The problem is that no validator is triggered when entering 123.123... > > Richard > > On Wed, Nov 17, 2010 at 11:53 AM, vi

[web2py] Re: crud operations for joins?

2010-11-17 Thread villas
Hi Carlos, See what you mean. We don't usually use 1:1 relationships, but 1 to many. e.g. From the book: db.define_table('person', Field('name'), format='%(name)s') db.define_table('dog', Field('name'), Field('owner', db.person), format='%(name)s') Of course an owner migh

Re: [web2py] Re: decimal validator by default or not

2010-11-17 Thread Richard Vézina
I don't want to store 123.123, I want 99.99 max. The problem is that no validator is triggered when entering 123.123... Richard On Wed, Nov 17, 2010 at 11:53 AM, villas wrote: > Hi Richard > > It might depend on the DB, but I believe you would normally need at > least decimal(5,2) to contain

[web2py] Re: decimal validator by default or not

2010-11-17 Thread villas
Hi Richard It might depend on the DB, but I believe you would normally need at least decimal(5,2) to contain 123.456789 With decimal(4,2) I think the max value would be 99.99... Try it... :) -D On Nov 17, 3:44 pm, Richard Vézina wrote: > I forgot to precise that I am under 1.88.2 > > Thanks

Re: [web2py] Re: How may I revoked a user logged in "server side"

2010-11-17 Thread Richard Vézina
Hello, I note that "blocked" in registration_key not prevent the user to login under 1.88.2... Is the keyword for that task as change?? Richard On Thu, Aug 26, 2010 at 2:27 PM, mdipierro wrote: > What Thadeus suggests forces the user to logout. > > Before you do that you may also want to use

[web2py] Re:

2010-11-17 Thread villas
Hi Napolean I have looked at your app and I did not understand it very well, but I hope you don't mind that I will try to give you some advice anyway (even though it might not be so useful!). It seems that you are going from one view to another without a good way of passing the ids. For example

Re: [web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread Branko Vukelic
On Wed, Nov 17, 2010 at 4:22 PM, mdipierro wrote: > You can sign up. I will approve those people who I recognize as > contributors and/or have proven skills by deploying a web2py > application. After we reach ~50 people new members will have to be > endorsed by 5 existing members to be approved.

Re: [web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread António Ramos
AHH, found a big problem! I need to create a table with 940 fields and web2py complains that it is over 255 What to do to resolve this? i dont want to partition my table because the record realy has 940 fields in my database (Lotus Notes) that i want to migrate to web2py. António 2010/11/17 A

Re: [web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread appydev
Thank you very much Anthony, I spend part of the morning trying to find in the search of the group without any results. with queries like "django clone people." Is rare. Thank you very much again. 2010/11/17 Anthony > Also, there's this one (a little older): > > http://www.appenginepeople.net/u

[web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread Anthony
Also, there's this one (a little older): http://www.appenginepeople.net/users/tag/web2py/ Discussed here: http://groups.google.com/group/web2py/browse_frm/thread/668fade78f5c3d79 and here: http://groups.google.com/group/web2py/browse_frm/thread/aa692ce9bc9c572e On Nov 17, 10:57 am, Anthony w

Re: [web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread appydev
Yes! Thanks Anthony. 2010/11/17 Anthony > Are you talking about this: > > http://web2pyople.appspot.com/ > > > On Nov 17, 10:46 am, appydev wrote: > > Excellent. Thanks for responding. > > > > A much changed. I remember an application that was made just for the map > of > > the "experts." And

[web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread Anthony
Are you talking about this: http://web2pyople.appspot.com/ On Nov 17, 10:46 am, appydev wrote: > Excellent. Thanks for responding. > > A much changed. I remember an application that was made just for the map of > the "experts." And since I'm beginner, I wanted to see the application to > learn,

Re: [web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread appydev
Excellent. Thanks for responding. A much changed. I remember an application that was made just for the map of the "experts." And since I'm beginner, I wanted to see the application to learn, remember being hosted on Google App Engine. 2010/11/17 mdipierro > we are taking a different approach >

[web2py] Re: decimal validator by default or not

2010-11-17 Thread Richard Vézina
I forgot to precise that I am under 1.88.2 Thanks On Wed, Nov 17, 2010 at 10:43 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Hello, > > I wonder if it is normal that I get ticket in that case : > > Model : > > Field('field1','decimal(4,2)'), > > > If I insert in form generate with

[web2py] Re: crud operations for joins?

2010-11-17 Thread Carlos
Thanks villas and Ivan. When I say joins I mean 1:1 relationships (or "linked tables"?), where each record in tables A/B/C reference one (and only one) unique 'entity' record, kind of like an 'extension' of such tables, but with data centralized in the 'entity' table (which would allow better main

[web2py] decimal validator by default or not

2010-11-17 Thread Richard Vézina
Hello, I wonder if it is normal that I get ticket in that case : Model : Field('field1','decimal(4,2)'), If I insert in form generate with crud.create(db.table1) this value : 123.123 I get ticket : Error traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. T

[web2py] Re: migrate existing GAE list fields to new web2py list types

2010-11-17 Thread howesc
hmmm, i made the changes you suggested, but now that the field type is 'list:reference' GAE throws: File "/Applications/GoogleAppEngineLauncher.app/Contents/Resources/ GoogleAppEngine-default.bundle/Contents/Resources/google_appengine/ google/appengine/ext/db/__init__.py", line 3016, in validate

[web2py] Re: Application developed with web2py like "Django People"

2010-11-17 Thread mdipierro
we are taking a different approach https://experts4solutions.com You can sign up. I will approve those people who I recognize as contributors and/or have proven skills by deploying a web2py application. After we reach ~50 people new members will have to be endorsed by 5 existing members to be

Re: [web2py] Re:

2010-11-17 Thread Napoleon Moreno
I found the answer in the book , like is usual db.define_table('diagnostico', Field('name','string'),format='%(name)s' ) It shows the name in every place where i have the diagnostico.id. I got my app running. Thanks everybody! On Wed, Nov 17, 2010 at 9:24 AM, Napoleon Moreno wrote: >

[web2py] Re: crud.create(db.table) issues error ticket

2010-11-17 Thread annet
Hi Denes, Thanks for your explanation. The mock app's behaviour made me worry about my own app's behaviour, however, I chose a different approach, and know I understand why I won't encounter this problem. Kind regards, Annet.

  1   2   >