Re: [web2py] delicious is closing

2010-12-17 Thread LightDot
SEO experts and SEO experts who use Delicious for ranking optimization will have a lot of work on their hands these days :) Yahooo should have sold the service rather than close it, IMHO.

[web2py] error in using captcha in crud

2010-12-17 Thread Markus Schmitz
Hi everybody, I was trying to use the recaptcha feature with a crud form and I am hitting an error: File D:\My Dropbox\InterManager\web2py\gluon\tools.py, line 2808, in update self._addrow(form, captcha.label, captcha, captcha.comment, AttributeError: 'Crud' object has no attribute

[web2py] LEFT JOIN in web2py

2010-12-17 Thread annet
In my model I have a company table and a person table and a combination table that links the two together. Some companies allow there people to maintain a profile text, in addition some companies allow there people to also upload a picture of themselves. To meet these requirements I defined a

[web2py] Powertable remarks

2010-12-17 Thread Johann Spies
I have downloaded Powertable and like most of what I see. What I like: * The ability to use more datasources than just a table and a single-column query. * The layout which is more readable and understandable than jqgrid from plugin_wiki I have certain questions and concerns though: * Is

Re: [web2py] Powertable remarks

2010-12-17 Thread rochacbruno
Hi, thank you for testing the plugin. I am writing the documentation explaining every option of the API. In this First alpha release only client side is available, the table is entirely loaded to the client, which is really not usable if you has more than 500 rows. I am working right now on

Re: [web2py] Powertable remarks

2010-12-17 Thread Phyo Arkar
* I have tested it this morning on a table with more just over 8200 entries and it took 70-90 seconds on Firefox and 30-35 secondes no Chrome to reload the page from localhost. That is not usable. Plugin_wiki's jqgrid does this in less than a second. It seems that it loads the whole table

Re: [web2py] Powertable remarks

2010-12-17 Thread Martín Mulone
You fetch 8200 records, this is not good for the server side and client browser. Perhaps need some tutorial about pagination or integrated with the plugin. 2010/12/17 Johann Spies johann.sp...@gmail.com: I have downloaded Powertable and like most of what I see. What I like: *  The ability to

Re: [web2py] Powertable remarks

2010-12-17 Thread rochacbruno
WIth jqgrid even without paging , i had successfully loaded 40k records within 6 - 8 secs . That is because jqgrid loads limited amount of data per request, i am doing this with datatables. And I am working to incorporaye it to the plugin.

Re: [web2py] Powertable remarks

2010-12-17 Thread Phyo Arkar
That is because jqgrid loads limited amount of data per request, i am doing this with datatables. And I am working to incorporaye it to the plugin. Nope , i did loadonce option which load all records atonce. and my database now is 500k records+ On 12/17/10, rochacbruno rochacbr...@gmail.com

Re: [web2py] Powertable remarks

2010-12-17 Thread Bruno Rocha
Nope , i did loadonce option which load all records atonce. and my database now is 500k records+ Is it loading all this records into a JSON? I just tested 20k of data loaded in to Java Script Array with this approach http://www.datatables.net/examples/data_sources/js_array.html Works

Re: [web2py] Powertable remarks

2010-12-17 Thread Branko Vukelic
- Original Message - From: rochacbruno Sent: 12/17/10 01:38 PM To: web2py@googlegroups.com Subject: Re: [web2py] Powertable remarks WIth jqgrid even without paging , i had successfully loaded 40k records within 6 - 8 secs . That is because jqgrid loads limited amount of

Re: [web2py] Powertable remarks

2010-12-17 Thread Bruno Rocha
Nice library! I didn't know http://demo.qooxdoo.org/ I just loaded 40k records in just 5 secs (locally) using JavaScript Array+Pipeline as data source for datatables. Now I am thinking in a way to use Rows.as_dict() to automate that. 2010/12/17 Branko Vukelic branko.vuke...@gmx.com -

Re: [web2py] Powertable remarks

2010-12-17 Thread Branko Vukelic
- Original Message - From: Bruno Rocha Sent: 12/17/10 03:08 PM To: web2py@googlegroups.com Subject: Re: [web2py] Powertable remarks Nice library! I didn't know http://demo.qooxdoo.org/ Well, check out their tag line on the homepage http://www.qooxdoo.org/. It's not a lie,

Re: [web2py] Powertable remarks

2010-12-17 Thread Bruno Rocha
Just wanted to add a detail: I have not started to develop the plugin to replace or compete jqGrid. I do not use jQgrid just because I do not like its layout and i've never read its documentation. JqGrid or webgrid does not use PluginManager() to config grid option, and I like the way we do with

[web2py] Re: delicious is closing

2010-12-17 Thread Tomeu
Ohh zootool is down !! in his page: We are offline The Delicious rumors hit us pretty hard. We are currently working on the import system and the whole infrastructure to be able to handle that better. Sorry for the downtime and thanks for your patience! On 17 dic, 09:19, LightDot

Re: [web2py] Re: delicious is closing

2010-12-17 Thread Branko Vukelic
Hehe, yeah. Should've seen it coming. :D - Original Message - From: Tomeu Sent: 12/17/10 03:49 PM To: web2py-users Subject: [web2py] Re: delicious is closing Ohh zootool is down !! in his page: We are offline The Delicious rumors hit us pretty hard. We are currently

Re: [web2py] Re: delicious is closing

2010-12-17 Thread Bruno Rocha
Hehe, I Imagine that will happen. they are running now to upgrade their Vm's Nice! hope this come back soon. 2010/12/17 Branko Vukelic branko.vuke...@gmx.com Hehe, yeah. Should've seen it coming. :D - Original Message - From: Tomeu Sent: 12/17/10 03:49 PM To: web2py-users

Re: [web2py] Re: delicious is closing

2010-12-17 Thread Branko Vukelic
At least something good happened to zootools. I actually like it a lot. Thanks, Bruno. - Original Message - From: Bruno Rocha Sent: 12/17/10 04:48 PM To: web2py@googlegroups.com Subject: Re: [web2py] Re: delicious is closing Hehe, I Imagine that will happen. they are running now

Re: [web2py] Powertable remarks

2010-12-17 Thread ron_m
This is a tiny nit pick so my apologies in advance but I thought it might be worth mentioning. I went to the demo page, picked Products and hit the green plus to open the details on the last item in the list. The control turned red but nothing else appeared to happen. Second time I noticed a

[web2py] Re: Creating database tables tutorial?

2010-12-17 Thread Hybride
Actually, that was the example I tried following. I still have previous tables from the wizard generator the first time around I tried to actually create them. So, I inserted the example into the models/db.py, saved and go to database administration, but it still shows the previous tables

[web2py] Re: How to fetch already exiting table data with out defining new table

2010-12-17 Thread sushanth
Thank you for the info, i am doing the same.but only problem i found i am not able to run return dict(records=db().select(db.tablename.ALL)) it throws below error Traceback (most recent call last): File /home/sushanth/Desktop/web2py/gluon/restricted.py, line 188, in restricted exec ccode

Re: [web2py] Powertable remarks

2010-12-17 Thread rochacbruno
I noticed a scroll bar activated on the right side of the form and sure enough if you scroll down there it is. I don't know how difficult it would be to expose the part that opened if it is out of the current view area. I'll try to bring it up to the viewport. Thank you for mentioning.

[web2py] parse_get_post_vars change

2010-12-17 Thread NuclearDragon
So, I am in the process of upgrading Web2py from version 1.67 to 1.89.5. Ouch. One of the things I encountered is that request.vars will now include a list of duplicate values, rather than a single value (not a list) as it previously did. For example, our url includes a _next variable. So does the

[web2py] Re: LEFT JOIN in web2py

2010-12-17 Thread DenesL
Hi Annet, try a ',' instead of the '' inside the 'left' part. On Dec 17, 4:12 am, annet annet.verm...@gmail.com wrote: In my model I have a company table and a person table and a combination table that links the two together. Some companies allow there people to maintain a profile text, in

[web2py] Re: delicious is closing

2010-12-17 Thread dlypka
I'm doing one for GAE. I have it to the point where it can upload the .htm file that is exported from Firefox. It uses taskqueues and my own recursive logic similar to Map Reduce to do the upload to GAE. It is web2py based but uses native GAE Datastore api calls for speed. They render to my own

[web2py] Re: Alternative Auth Fields (not additional ones)?

2010-12-17 Thread DenesL
Try setting db.auth_user.last_name.requires=[] in your model after auth is defined or in your action before the form. On Dec 17, 12:44 am, Greg greg.kr...@gmail.com wrote: Hello, When my users register I won't have any need for them to enter First name or Last name. I really only need

[web2py] Re: delicious is closing

2010-12-17 Thread dlypka
I'm doing one for GAE. I have it to the point where it can upload the .htm file that is exported from Firefox. It uses taskqueues and my own recursive logic similar to Map Reduce to do the upload to GAE. It is web2py based but uses native GAE Datastore api calls for speed. They render to my own

Re: [web2py] Re: How to fetch already exiting table data with out defining new table

2010-12-17 Thread Kenneth Lundström
return dict(records=db().select(db.tablename.ALL)) You can´t use the word tablename if you don´t have a table named tablename. If you wan´t to have everything from a table named customers use return dict(records=db().select(db.customers.ALL)) Kenneth it throws below error Traceback (most

[web2py] Re: LEFT JOIN in web2py

2010-12-17 Thread annet
Hi Denes, Thanks, problem solved! Kind regards, Annet

[web2py] Re: Powertable remarks

2010-12-17 Thread Carlos
Hi, Just in case it helps (e.g. to check their apis, feature set, etc.), following is (I believe) the most powerful treegrid out there: http://www.treegrid.com Take care, Carlos On Dec 17, 11:17 am, rochacbruno rochacbr...@gmail.com wrote:  I noticed a scroll bar activated on the

Re: [web2py] Re: it case you missed it...

2010-12-17 Thread appydev
Greetings. I am a new member of the community, however, I will take the dare to give my humble opinion: I think that a license of type BSD or MIT would be beneficial for web2py. I think the GPL license, frighten off the business and other potential users. Some do not understand the exception

[web2py] Re: it case you missed it...

2010-12-17 Thread mdipierro
I think we can all agree on two issues: 1) the current license (GPL + exception) is OK for almost everybody 2) the current license is unclear and it is confused with pure GPL. That is limiting the adoption of web2py. This needs to be addressed, How do people feel about the following license:

Re: [web2py] Re: it case you missed it...

2010-12-17 Thread Branko Vukelic
- Original Message - From: mdipierro Sent: 12/17/10 09:39 PM To: web2py-users Subject: [web2py] Re: it case you missed it... I think we can all agree on two issues: 1) the current license (GPL + exception) is OK for almost everybody 2) the current license is unclear and it is

[web2py] Re: Alternative Auth Fields (not additional ones)?

2010-12-17 Thread Greg
Thank you, that does work. On Dec 17, 11:54 am, DenesL denes1...@yahoo.ca wrote: Try setting db.auth_user.last_name.requires=[] in your model after auth is defined or in your action before the form. On Dec 17, 12:44 am, Greg greg.kr...@gmail.com wrote: Hello, When my users

[web2py] Re: Powertable remarks

2010-12-17 Thread Anthony
On Dec 17, 2:01 pm, Carlos carlosgali...@gmail.com wrote: Hi, Just in case it helps (e.g. to check their apis, feature set, etc.), following is (I believe) the most powerful treegrid out there:    http://www.treegrid.com It's not free, though:

[web2py] Re: it case you missed it...

2010-12-17 Thread ron_m
I think that is a good solution.

Re: [web2py] delicious is closing

2010-12-17 Thread Jonathan Lundell
On Dec 17, 2010, at 12:19 AM, LightDot wrote: SEO experts and SEO experts who use Delicious for ranking optimization will have a lot of work on their hands these days :) Yahooo should have sold the service rather than close it, IMHO. There's some confusion on that score. What’s Next for

[web2py] interval in a list

2010-12-17 Thread Rick
Hi, In the database there are value records for 31 days. Now I'm trying to make a html file where a value is presented for each day of a week. The code below presents all the recorded values, and I don't know how to make it printing the 7 first records only, or the last 3 records. Thanks in

[web2py] Run Web2py as a Service? on Ubuntu Lucid?

2010-12-17 Thread ghoulmann
I'm thankful this community is here. I'm working on a project for the Sahana-Eden team [1]. It calls for running web2py as a service. I was thankful to find documentation in the 3rd edition Official Web2py Book [2]. Sadly, when I follow the docs I can't get the service running. / etc/init.d/web2py

[web2py] Re: Run Web2py as a Service? on Ubuntu Lucid?

2010-12-17 Thread mdipierro
did you try start it simply with python web2py.py -a password or nohup python web2py.py -a password Does it work fine in these cases? On Dec 17, 4:59 pm, ghoulmann rikgold...@gmail.com wrote: I'm thankful this community is here. I'm working on a project for the Sahana-Eden team [1]. It

[web2py] Re: interval in a list

2010-12-17 Thread Luther Goh Lu Feng
From http://web2py.com/book/default/chapter/06#orderby,-groupby,-limitby,-distinct I think the following may work: for row in db().select(db.table.ALL, limitby=(0, 7)): print row.record for row in db().select(db.table.ALL, limitby=(0, 3). orderby=~db.table.id): print row.record

[web2py] Re: interval in a list

2010-12-17 Thread Rick
Thanks a lot! The final code looks like this: {{for record in db().select(db.table.ALL, orderby=db.table.day, limitby=(0, 7)):}} On Dec 18, 12:59 am, Luther Goh Lu Feng elf...@yahoo.com wrote: Fromhttp://web2py.com/book/default/chapter/06#orderby,-groupby,-limitby,-... I think the following

[web2py] Re: interval in a list

2010-12-17 Thread Rick
Sorry for spamming, but I want to be exact. Here is the final code, where n is the week number: {{for record in db().select(db.table.ALL, orderby=db.table.day, limitby=(n*0, n*7)):}} On Dec 18, 1:24 am, Rick sababa.sab...@gmail.com wrote: Thanks a lot! The final code looks like this: {{for

[web2py] Re: interval in a list

2010-12-17 Thread Rick
Oh no, the code above failed. Here is the final code where n is the week number: {{for record in db().select(db.table.ALL, orderby=db.table.day, limitby=((n-1)*7, n*7)):}} On Dec 18, 1:30 am, Rick sababa.sab...@gmail.com wrote: Sorry for spamming, but I want to be exact. Here is the final code,

Re: [web2py] Re: uWSGI + Cherokee + web2py - a howto.

2010-12-17 Thread pbreit
Oops: also very similar to Ivan's instructions.

[web2py] variables

2010-12-17 Thread Rick
Hi, I want to change the value of a variable by clicking on an a tag, but can't find any information about the topic. I suppose the code would look something like this: {{=A('', request n=n-1) }} Thanks in advance for help

[web2py] variables

2010-12-17 Thread Rick
Hi, I want to change the value of a variable by clicking on an a tag, but can't find any information about the topic. I suppose the code would look something like this: {{=A('', request n=n-1) }} Thanks in advance for help

[web2py] Re: variables

2010-12-17 Thread pbreit
I don't really understand the question. Do you want to change a JavaScript variable? Or a variable in your web2py code? I don't think you would be able to modify a web2py variable as the result of a click. By the time the suer views your page, all the web2py code has been rendered into HTML.

Re: [web2py] Re: Powertable remarks

2010-12-17 Thread Bruno Rocha
I liked this treegrid library, but I think it is visually poluted, too much complicated, I always need a simple dynamic html tables (just like SQLTABLE) but including pagination, just one level of nested detail, edit in-line and search. In adition with DAL virtual fields for live

Re: [web2py] Re: Powertable remarks

2010-12-17 Thread Branko Vukelic
In other words, there's no silver bullet. ;) - Original Message - From: Bruno Rocha Sent: 12/18/10 02:43 AM To: web2py@googlegroups.com Subject: Re: [web2py] Re: Powertable remarks I liked this treegrid library, but I think it is visually poluted, too much complicated, I always

[web2py] Re: variables

2010-12-17 Thread Rick
Thanks for the replies! The variable that I'm operating with is python type, not javascript. Mdipierro, your solution looks nice, but i can't get it working. The value of the variable doesn't seem to change. Here is my code: from views/default/index.html: {{n=1}} a href=#

Re: [web2py] Re: Powertable remarks

2010-12-17 Thread Bruno Rocha
2010/12/17 Branko Vukelic branko.vuke...@gmx.com In other words, there's no silver bullet. ;) My wife just told me: Why are you so focused on these tables stuff, if already exists microsoft excel, and everybody uses it? LOL! -- Bruno Rocha http://about.me/rochacbruno/bio

[web2py] Re: variables

2010-12-17 Thread Luther Goh Lu Feng
You can use javascript or jquery(since web2py includes jquery) to do this: ==javascript== $('#some_id).click(function() { $('#target).val( ($('#target).val()+1) ); } ) ==html== span id=some_ida href=# Click me/a/span span id=target2/span This should more or less work. On Dec 18,

[web2py] helper tabs

2010-12-17 Thread Luis Díaz
Greetings. I like working with tabs here posted something that I designed, http://www.box.net/shared/6p0hfupjin I hope to improve the work with your comments and suggestions and also post my progress on the mailing list in Spanish I personally like ... obvious is my creation ha ha ha notes:

Re: [web2py] helper tabs

2010-12-17 Thread Bruno Rocha
I used in a different way of what you show in the app, and it works very well! In controller: tabs =PEST([ ['Index', URL('default')] , ['Tab one',URL('tab1')] ]) return dict(tab=tab) In view: {{=tabs}} I just suggest you: Calling the class 'TAB' instead of 'PEST'. Needs a way to output

[web2py] Re: Run Web2py as a Service? on Ubuntu Lucid?

2010-12-17 Thread ghoulmann
Thanks so much for the reply. I did try both; retried them when I saw your response. Both commands start web2py.py listening on :8000. SO, it does work in these cases. Is there something I can try next? On Dec 17, 6:34 pm, mdipierro mdipie...@cs.depaul.edu wrote: did you try start it simply with

[web2py] BUG on new DAL and _filter_fields?

2010-12-17 Thread Tito Garrido
When I try to create record that has an list:reference field I'm getting the following error: MODEL: Field('troco_por', 'list:reference jogo', label='Troco por qualquer um destes jogos', comment='Use a tecla Ctrl para selecionar mais de um jogo'), CONTROLLER:

Re: [web2py] BUG on new DAL and _filter_fields?

2010-12-17 Thread Bruno Rocha
I ran with the same issue with the new dal. https://groups.google.com/forum/#!topic/web2py-developers/RU5yUhu_2pU Jus to to remember: Also Virtual fields: https://groups.google.com/forum/#!topic/web2py-developers/IPoWmlKoFOQ And the load charts on applet:

[web2py] Quick cron question

2010-12-17 Thread Thadeus Burgess
Do the models get executed before or after hard-cron process is started? And are those models available to the scope of the cron application. In my example cron would be executing a long-running controller function. -- Thadeus

Re: [web2py] helper tabs

2010-12-17 Thread Luis Díaz
* very good perspective you used * TAG is certainly easier to read than PEST use PEST because my language is Spanish and use it asshorthand for PESTAÑA * with respect to: Needs a Proper way to output dynamic CSS I do not understand, I could explain with an example? * I do not like the plugin.

[web2py] Re: Powertable remarks

2010-12-17 Thread mdipierro
Wifes are smarter than we are ready to admit. On Dec 17, 8:04 pm, Bruno Rocha rochacbr...@gmail.com wrote: 2010/12/17 Branko Vukelic branko.vuke...@gmx.com In other words, there's no silver bullet. ;) My wife just told me: Why are you so focused on these tables stuff, if already exists

[web2py] Re: BUG on new DAL and _filter_fields?

2010-12-17 Thread mdipierro
before db.user_jogo.insert(**db.user_jogo._filter_fields(form.vars)) please add print db.user_jogo._insert(**db.user_jogo._filter_fields(form.vars)) What does it print when the problem occurs? On Dec 17, 11:14 pm, Bruno Rocha rochacbr...@gmail.com wrote: I ran with the same issue with the

[web2py] Re: Quick cron question

2010-12-17 Thread mdipierro
cron just starts nwe web2py.py processes. Each cron task executes the models. If you are working on what I think you are working get rid of cron and use a single background process that loops. Massimo On Dec 18, 12:27 am, Thadeus Burgess thade...@thadeusb.com wrote: Do the models get executed

Re: [web2py] Re: Quick cron question

2010-12-17 Thread Jonathan Lundell
On Dec 17, 2010, at 11:17 PM, mdipierro wrote: cron just starts nwe web2py.py processes. Each cron task executes the models. If you are working on what I think you are working get rid of cron and use a single background process that loops. I was looking at the code, and have a question.

Re: [web2py] helper tabs

2010-12-17 Thread Luis Díaz
as recommended by a friend: Bruno Rocha make some changes to the system tab I get it link: http://www.box.net/shared/6p0hfupjin is the same but the file is new version 2010/12/18 Luis Díaz diazluis2...@gmail.com * very good perspective you used * TAG is certainly easier to read than PEST