[web2py] Re: how to build windows binary?

2013-08-15 Thread Niphlod
You download py2exe, go to the web2py source folder, issue python setup_exe.py py2exe and wait. With python 2.5, there are no "subtle" issues with the archive that results. However, with python >= 2.6, you should ship MSVCR90.dll with it to make it work (that's true for every python binary you'

[web2py] how to build windows binary?

2013-08-15 Thread step
For starters, this thread pretty much answers my question, https://groups.google.com/forum/?fromgroups#!searchin/web2py/build$20web2py.exe/web2py/Lirvj_J8q1U/vC1kWqXoDSMJ However, I wonder what is the official method to build web2py.exe, and also if other people have devised or derived their

Re: [web2py] IS_IN_DB zero= solution

2013-08-15 Thread Annet
> On the other end, a multiple select is a totally different "beast", > because choices are shown to the user having a multiple select with a > field that stands for "please do something" in it is a poor design > decision. > Probably. In my table definitions I do use comments to give di

[web2py] Re: Advice on Architecture/Design

2013-08-15 Thread Alex Glaros
develop for multi-tenant from the beginning or else you will waste time re-entering corrected designed data is a "group" equivalent to a "team"? will team membership stay permanent for each season? On Thursday, August 15, 2013 2:40:28 PM UTC-7, Carlos Zenteno wrote: > > Hi all, > > Very new t

Re: [web2py] web2py on Google Drive

2013-08-15 Thread Vineet
On Wednesday, 14 August 2013 02:28:04 UTC+5:30, Luca wrote: > > If you use sqlite, it should work, since the db is kept in a local file. > Luca > There is a mysql-noinstall version available. It can reside in a local folder. -- Vineet -- --- You received this message because you are subscri

[web2py] Re: jquery .hide() interfering with validators

2013-08-15 Thread Jordan Ladora
A I see - it works perfectly now - thanks very much for your help!! -j -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups

[web2py] Re: A few website projects built in Web2py

2013-08-15 Thread Luca
I suspect the author forgot to change the permissions to public. -Luca On Thursday, August 15, 2013 4:56:52 PM UTC-7, samuel bonill wrote: > > hey man !! > > the github links are broken !! > > El lunes, 12 de agosto de 2013 19:12:14 UTC-5, leaping...@gmail.comescribió: >> >> I built these sites a

[web2py] Re: A few website projects built in Web2py

2013-08-15 Thread samuel bonill
hey man !! the github links are broken !! El lunes, 12 de agosto de 2013 19:12:14 UTC-5, leaping...@gmail.com escribió: > > I built these sites a while ago and figured I would release them. They > weren't for clients, more personal projects. > > https://github.com/techshinobi/free-business-pa

[web2py] Advice on Architecture/Design

2013-08-15 Thread Carlos Zenteno
Hi all, Very new to web2py and I like it so far... I am going to develop an app where a 'team' representative will sign up for an account and this will create a team environment where the team players list can be entered. Each account will have 5 groups on it and the players will be moved/assi

Re: [web2py] IS_IN_DB zero= solution

2013-08-15 Thread Niphlod
I agree. The purpose of the "zero" option is to prefill a select with an helper and return an error if that option is the one selected (meaning that the user didn't choose anything). This has been requested because if there is no sane default to provide, having a dropdown with nothing in it tell

[web2py] Re: web2py menus don't like iPhone!

2013-08-15 Thread Paolo Caruccio
In this days I'm building an experimental version of welcome app based on jQuery 2.0.3 and bootstrap 3 (now rc2). With safari on iPhone4 but also with chrome on galaxy s3 mini, the dropdown in navbar wasn't tapable. I solved partially by using this snippet jQuery('.dropdown-toggle')

Re: [web2py] Re: Accessing attributes of reference fields

2013-08-15 Thread Anthony
Oops, of course, the select is done within setdefault. Your if statement version is the way to go. Anthony On Thursday, August 15, 2013 3:21:43 PM UTC-4, Quint wrote: > > Thanks! > > Got it woking now but i got strange results: > > ("Not working" means that the same referenced record is being fe

Re: [web2py] Re: Accessing attributes of reference fields

2013-08-15 Thread Quint van den Muijsenberg
Appears that with set_default, the default param is always evaluated and this will perform the query every time guess.. On Aug 15, 2013 9:21 PM, "Quint" wrote: > Thanks! > > Got it woking now but i got strange results: > > ("Not working" means that the same referenced record is being fetched > ev

Re: [web2py] IS_IN_DB zero= solution

2013-08-15 Thread Richard Vézina
You use multiple... So I guess as Niphold says you can't use zero... Maybe consider create some kind of popover or use comment that is there for that purpose so beside you field the user will be tell to select 4 functions... Richard On Thu, Aug 15, 2013 at 3:26 PM, Richard Vézina wrote: > May

Re: [web2py] IS_IN_DB zero= solution

2013-08-15 Thread Richard Vézina
Maybe you could use IS_IN_SET... You just have to pass you query to it on construct a dict from the query... Refer you to this post of Anthony : https://groups.google.com/d/msg/web2py/QBTYaytNypU/DW2HpnT-xK0J http://web2py.com/books/default/chapter/29/07/forms-and-validators#Validators Scroll a b

Re: [web2py] Re: Accessing attributes of reference fields

2013-08-15 Thread Quint
Thanks! Got it woking now but i got strange results: ("Not working" means that the same referenced record is being fetched every time and not read from the dict) This is not working: Field.Virtual('created_by_record', lambda r: users.setdefault(r.comment.created_by.id, db.

Re: [web2py] Re: Pass python list back to controller

2013-08-15 Thread Richard Vézina
ids = [1, 2, 3] redirect(URL(c='test', f='side_by_side', args=(request.args(0)), vars=dict(ids=ids))) ids = request.vars.ids Work as well... The url look like that : test/side_by_side/table?ids=1&ids=2&ids=3 I have use session.ids before, but I need to pass a list of id by the url in order to

Re: [web2py] IS_IN_DB zero= solution

2013-08-15 Thread Annet
Thank you both for your replies. apart from that, IS_IN_DB totally works with zero (unless multiple=True, in > which a zero argument kinda defeats the purpose). Are you sure that you're > not adding other validators to that field ? > This is the IS_IN_DB validator: db.register.navID.requires=

[web2py] db.mytable.myfield.contains() gives an error Query Not Supported: parser stack overflow

2013-08-15 Thread dave
. . . x = ['a', 'b', 'c', ...] queries.append(db.mytable.myfield.contains(x)) query = reduce(lambda a,b:(a&b),queries) grid = SQLFORM.grid(query, ...) return (grid=grid) gives an error of "Query Not Supported: parser stack overflow", if the list x has too many values, like around 100 or a 1000,

Re: [web2py] IS_IN_DB zero= solution

2013-08-15 Thread Niphlod
apart from that, IS_IN_DB totally works with zero (unless multiple=True, in which a zero argument kinda defeats the purpose). Are you sure that you're not adding other validators to that field ? On Thursday, August 15, 2013 7:59:55 PM UTC+2, Richard wrote: > > insert(0, "Select 4 functions") doe

Re: [web2py] web2py menus don't like iPhone!

2013-08-15 Thread Marin Pranjić
Are you using bootstrap 2.3.2? Try this: https://github.com/twbs/bootstrap/issues/7968 On Thu, Aug 15, 2013 at 8:04 PM, Joe Barnhart wrote: > Well, it's not web2py's fault. But Bootstrap recently did something that > causes their menus to fail on iPhone, and I have verified this behavior. > B

[web2py] web2py menus don't like iPhone!

2013-08-15 Thread Joe Barnhart
Well, it's not web2py's fault. But Bootstrap recently did something that causes their menus to fail on iPhone, and I have verified this behavior. Basically you can't select any menu choices, leaving you unable to log in. I don't know if there's a real fix yet... We tried the suggested fix on

Re: [web2py] IS_IN_DB zero= solution

2013-08-15 Thread Richard Vézina
insert(0, "Select 4 functions") doesn't work? Richard On Thu, Aug 15, 2013 at 1:56 PM, Annet wrote: > Since IS_IN_DB ignores zero='' I tried this: > > form.element('select[name=navID]').append("Select 4 functions") > > However, the options are sorted by id and "Select 4 functions" ends > up a

[web2py] IS_IN_DB zero= solution

2013-08-15 Thread Annet
Since IS_IN_DB ignores zero='' I tried this: form.element('select[name=navID]').append("Select 4 functions") However, the options are sorted by id and "Select 4 functions" ends up as the last option. Is there a way to move it to the top of the list of options? Kind regards, Annet -- --- Y

Re: [web2py] Header for selectable

2013-08-15 Thread Richard Vézina
Could you be more precise? There is headers SQLFORM.grid attribute : - headers is a dictionary that maps 'tablename.fieldname' into the corresponding header label, e.g. {'auth_user.email' : 'Email Address'} But it difficult to know what you need exactly... Richard On Wed, Aug 14, 2013

Re: [web2py] Re: Accessing attributes of reference fields

2013-08-15 Thread Anthony
Good point. I suppose you can adapt your method to work with a virtual field: owners = {} db.define_table('dog', ... Field.Virtual('owner_record', lambda r: owners.setdefault(r.dog.owner, db.person(r.dog.owner))) That will store each fetched owner record in the owners dict, so th

Re: [web2py] Re: Accessing attributes of reference fields

2013-08-15 Thread Quint van den Muijsenberg
But when when a row is calculating it's virtual field, it will fetch the referenced row even when some other row from the initial set has already fetched this same referenced row (when they are referencing the same thing). So they will both perform the same fetch. ? I want to do this fetch 1x and

[web2py] Re: Has the format of the auth tables changed recently? Or the format of t

2013-08-15 Thread Massimo Di Pierro
A possible fix is in trunk. Please help me check it. On Thursday, 15 August 2013 03:59:56 UTC-5, Massimo Di Pierro wrote: > > This is strange because memdb has not changed. Looks like there is a query > by id with id value = None and on GAE this is not possible. Anyway, I am > looking into this

[web2py] Re: Accessing attributes of reference fields

2013-08-15 Thread Anthony
On Thursday, August 15, 2013 10:04:45 AM UTC-4, Quint wrote: > thnx, > > but my goal is to prevent repeated queries for the same record when > accessing ref fields on rows from the same result set. > > I'm missing something, how do those Virtual Fields achieve that? > Yes, that's exactly wh

[web2py] (GAE) periodic updates

2013-08-15 Thread jjg0
(Using google app engine if that matters) I have a table that I want to update on a weekly basis. Basically it's a simple table of users with a date field that gets set to the last time they did something and a field to indicate that they are active. I want to check every Monday which users we

[web2py] Re: Accessing attributes of reference fields

2013-08-15 Thread Quint
thnx, but my goal is to prevent repeated queries for the same record when accessing ref fields on rows from the same result set. I'm missing something, how do those Virtual Fields achieve that? And about the join, wouldn't that mean it won't work on GAE? On Thursday, August 15, 2013 2:19

Re: [web2py] Re: How to define identical tables at once?

2013-08-15 Thread Richard Vézina
Read book about database design, database normalization particularly. To get all those information (linked user, message the leave, etc.) you will have to make query that just the way a database works. Richard On Wed, Aug 14, 2013 at 9:01 PM, Hunt wrote: > Yea sorry... I did an absolutely awfu

[web2py] Re: Accessing attributes of reference fields

2013-08-15 Thread Anthony
On Thursday, August 15, 2013 6:57:23 AM UTC-4, Quint wrote: > like this? > > You run a query with an extra option specify the ref fields to pre-fetch. > and then it would query all the referenced rows in a smart way (only fetch > a record 1x). > > Is there a generally accepted way to handle

[web2py] Re: Accessing attributes of reference fields

2013-08-15 Thread Quint
like this? You run a query with an extra option specify the ref fields to pre-fetch. and then it would query all the referenced rows in a smart way (only fetch a record 1x). Is there a generally accepted way to handle this (in the absence of the mentioned feature)? Right now I'm fetching

[web2py] Re: InterfaceError: connection already closed

2013-08-15 Thread hiro
Ok, I have updated to 2.6.0-development+timestamp.2013.08.08.09.00.28 now. Will give it some time and see if the error is still there. Thank you very much for your help Massimo! On Thursday, August 15, 2013 12:06:39 PM UTC+2, Massimo Di Pierro wrote: > > Can you try using the trunk version? This

[web2py] Re: InterfaceError: connection already closed

2013-08-15 Thread Massimo Di Pierro
Can you try using the trunk version? This may be already fixed. For sure we have changed some of the relevant logic. Let us know. On Thursday, 15 August 2013 04:43:51 UTC-5, hiro wrote: > > The latest: 2.5.1-stable+timestamp.2013.06.06.15.39.19, but I have hade > the problem for a while with ear

[web2py] Re: GAE local MySQL with DAL

2013-08-15 Thread Massimo Di Pierro
Which web2py version? On Thursday, 15 August 2013 04:32:58 UTC-5, Grace wrote: > > Hi Massimo, > > Thanks for the reply. I have change the line to > > db = DAL('google:sql://username:password@localhost/dbname') > > and the GAE logs now show the following: > > File "C:\Program Files > (x86)\

[web2py] Re: InterfaceError: connection already closed

2013-08-15 Thread hiro
The latest: 2.5.1-stable+timestamp.2013.06.06.15.39.19, but I have hade the problem for a while with earlier versions of web2py. On Tuesday, August 13, 2013 4:05:15 PM UTC+2, Massimo Di Pierro wrote: > > Do you know which web2py version? > > On Monday, 12 August 2013 09:49:32 UTC-5, hiro wrote: >

Re: [web2py] reference db.auth_user from other Database..

2013-08-15 Thread hiro
Ok, well I will just think about moving all data to the external DB On Wednesday, August 14, 2013 5:48:37 PM UTC+2, Carlos Correia wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Em 14-08-2013 15:23, hiro escreveu: > > Without touching db.py I have created a new file in order to

[web2py] Re: reference db.auth_user from other Database..

2013-08-15 Thread hiro
Thank you... On Wednesday, August 14, 2013 5:21:49 PM UTC+2, Niphlod wrote: > > nope it's not. > > Is it possible to cross reference the databases? If so, how? >> > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this

[web2py] Re: GAE local MySQL with DAL

2013-08-15 Thread Grace
Hi Massimo, Thanks for the reply. I have change the line to db = DAL('google:sql://username:password@localhost/dbname') and the GAE logs now show the following: File "C:\Program Files (x86)\Google\google_appengine\web2py\gluon\dal.py", lin e 9958, in select return adapter.select(self.qu

[web2py] Re: Encoding problem in 'format' from define_table on GAE

2013-08-15 Thread Massimo Di Pierro
replace format="%(nombre)s - %(precio)s€" with format= "%(nombre)s - %(precio)s\xe2\x82\xac" because labels mush be in ascii (or utf8) but not unicode. On Wednesday, 14 August 2013 15:57:24 UTC-5, juan wrote: > > Hello, > > It seems that the format option in db.define_table isn't working prop

[web2py] Re: GAE local MySQL with DAL

2013-08-15 Thread Massimo Di Pierro
I do not believe GAE allows connections to external MySQL services. You have to connect to theirs with using DAL('google:sql://...') On Thursday, 15 August 2013 02:33:04 UTC-5, Grace wrote: > > Hi, > > I am trying to work with Web2py for GAE, connect to my local MySQL. When I > use DAL, with th

[web2py] Re: c.r.m. source

2013-08-15 Thread Corne Dickens
It's somewhere half way on the page.. CustomerRelationshipManagement source: https://github.com/mdipierro/web2py-appliances/tree/master/CustomerRelationshipManagement download: https://raw.github.com/mdipierro/web2py-appliances/master/CustomerRelationshipManagement/web2py.app.CustomerRelationship

[web2py] Re: deployment to google app engine did not include my static files

2013-08-15 Thread Massimo Di Pierro
Sorry, was out of town and had connection very few hours a day. Trying to catch up. Tomorrow will be a little better. On Wednesday, 14 August 2013 18:33:33 UTC-5, Luca wrote: > > Massimo, I have been trying to send you emails for some time without > success. Is there some issue with your email?

[web2py] Re: Has the format of the auth tables changed recently? Or the format of t

2013-08-15 Thread Massimo Di Pierro
This is strange because memdb has not changed. Looks like there is a query by id with id value = None and on GAE this is not possible. Anyway, I am looking into this ... On Wednesday, 14 August 2013 18:21:45 UTC-5, Luca wrote: > > I have recently upgraded from web2py release R-2.4.6 to the head

[web2py] Header for selectable

2013-08-15 Thread Leonardo Pires Felix
How put a header on selectable column on SQLFORM.grid? -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more option

[web2py] Encoding problem in 'format' from define_table on GAE

2013-08-15 Thread juan
Hello, It seems that the format option in db.define_table isn't working properly when deployed on GAE. Please, consider these two tables: db.define_table('ingrediente', Field('nombre', 'string', requires=IS_NOT_EMPTY(error_message='Se ha de indicar el nombre')),

[web2py] Re: Web2py Sem Segredos

2013-08-15 Thread Matheus Godoy
Tenho muito interesse no curso, mas não consigo encaixar minha rotina em nenhum dos horários. É possível a venda da gravação das aulas? Abraço! -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop recei

[web2py] encoding problem in GAE when using format in db.define_table

2013-08-15 Thread juanchín chin chin
It seems that something isn't working properly when using the attribute 'format' and not-only English chars on db.define_table when deployed on GAE Please, consider theses two table definitions: db.define_table('ingrediente', Field('nombre', 'string', requires=IS_NOT_EMPTY(error_m

Re: [web2py] Re: Request: Course about Web2py & TDD + pledge for cash

2013-08-15 Thread Mika Sjöman
Hi looks great. Why don't you make it a free coursera.org course and add a hundred thousand students to your class? I am moving to Sweden so California is a bit far to go even though I would love to study in California ;) Also I see UCSC is already at Coursera: https://www.coursera.org/ucsc Wh

[web2py] A few website projects built in Web2py

2013-08-15 Thread leapingstudios
I built these sites a while ago and figured I would release them. They weren't for clients, more personal projects. https://github.com/techshinobi/free-business-pages https://github.com/techshinobi/echovids The echovids project is a bit older but free-business-pages is a newer one. Can't give

[web2py] GAE local MySQL with DAL

2013-08-15 Thread Grace
Hi, I am trying to work with Web2py for GAE, connect to my local MySQL. When I use DAL, with the following command: db = DAL('mysql://username:password@localhost/dbname') GAE log show the following: RuntimeError: no driver available ('MySQLdb', 'pymysql') but the above command work perfectly fr

[web2py] It would be nice to see the downloads of web2py.

2013-08-15 Thread Jason (spot) Brower
It would be fun to have a download chart about how many people download web2py in the day, week, month, ever. Could that be added to the page somewhere? Maybe the download page? BR, Jason Brower -- --- You received this message because you are subscribed to the Google Groups "web2py-users" g

[web2py] Re: File extention automatically changes when a file is uploaded

2013-08-15 Thread Anthony
Explicitly calling the .store() method should work in 2.4.6, but this method: db(db.mytable.id==24).update(file1=request.vars.file1) doesn't work in any stable version -- it only works in trunk (and therefore will work in the next stable release). Anthony On Thursday, August 15, 2013 2:39:13

[web2py] Re: Do you use web2py professionally?

2013-08-15 Thread webpypy
Thank you, Arnon, for your cooperation. Ashraf -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, vis

[web2py] Re: Do you use web2py professionally?

2013-08-15 Thread Arnon Marcus
The explenation I gave shoul make it trivial to write a simple example - it boils everytings down to a few urls that return an xml. Writing such controller-actions in web2py is trivial to do with the aid of the web2py documentation - you may even be able to find examples. As for the xml formatt