[web2py] Re: Error in trunk opening PostgreSQL database

2011-03-04 Thread ron_m
Thanks, it is easy to see how the default parameter gets changed with that example since the binding passes back outside the function through the return value, gets assigned to another variable and then the container contents modified through that assignment.

[web2py] From .represent to csv: is this possible?

2011-03-04 Thread Johann Spies
I have a generic 'show_data' function in my controller using the .represent functions in the models to show linked fields correctly. The clients wants the same now in the csv-downloads from the same data shown by show_data. There are many tables involved - it might be more than 20 and I do not

[web2py] Error in templating system

2011-03-04 Thread szimszon
web2py™ Version 1.92.1 (2011-02-16 15:04:40) Python Python 2.5.2: /usr/bin/python Traceback (most recent call last): File /home/szimszon_nfs/web2py/gluon/restricted.py, line 186, in restricted ccode = compile2(code,layer) File /home/szimszon_nfs/web2py/gluon/restricted.py, line

[web2py] Error in templating system

2011-03-04 Thread pbreit
Maybe try closing up the pass with }} and then reopening the rest of the code?

[web2py] Re: Error in templating system

2011-03-04 Thread szimszon
Yes I already did it and I mentioned it in the code above but the point is that it was working until I upgraded the framework. The original syntax was good too I mean I can't see what is wrong with it. So it's a backward compatibility issue :( On márc. 4, 10:58, pbreit pbreitenb...@gmail.com

[web2py] Re: Error in templating system

2011-03-04 Thread pbreit
Oh, ok, I see, sorry about that. So it somehow dropped the closing ) after =XML(msg). Could your msg have any special characters in it? I see some UTF-8 related diffs in the code for html.py recently.

[web2py] mysql dal.py boolean field

2011-03-04 Thread szimszon
I had a mysql table with boolean field but there was some rows with empty fields than I got that: Traceback (most recent call last): File applications/serveradmin/compiled/controllers_integrity_ftp.py, line 191, in ftp File /usr/local/web2py/gluon/dal.py, line 4605, in select return

[web2py] Re: Error in templating system

2011-03-04 Thread szimszon
Don't know could be but The interpreter which checks the syntax about all the pass-es are in right place give me the syntax error. What I try to say that first I visit the page the msg is None so the if branch isn't executed at all. If I just byte compile the app I have the same syntax error

[web2py] Weird self submitting forms all checkbox is checked after submit

2011-03-04 Thread szimszon
If I Submit form data which contains checkbox (boolean) field I got back the form with all checkbox selected... The database operation is ok. Just the returning form is displayed with all checkbox checked...

[web2py] Re: changing export_to_csv( )'s default behaviour

2011-03-04 Thread Eduardo
Thank you very much, Anthony. Your explanation and solution was exactly what I needed. Eduardo On 4 mar, 00:23, Anthony abasta...@gmail.com wrote: On Thursday, March 3, 2011 1:19:14 PM UTC-5, Eduardo wrote: Thank you all. Editing appadmin will do. I am, however, having a hard time

[web2py] cant use the python set function

2011-03-04 Thread Suhail Thakur
Hello, in python there is a standard function set, which is used to uniquify a list, the thing i can't use this in web2py, because in web2py/gluon/ contrib/memcache/__init__.py and web2py/gluon/contrib/memcache/ memcache.py there is a function named set which conflicts with the python's standard

[web2py] web2py console doesn't show activity

2011-03-04 Thread Tamas
Hi there, I updated my web2py installation recently and after the update the small window where I type IP, port and password doesn't show webserver access any more. It was a pretty good feature that showed a green peak every time I connected to the server. Does somebody know why it is not working

[web2py] how to change checkbox to button delete in SQLFORM

2011-03-04 Thread Bruno Barbosa
I want change default checkbox to button in SQLFORM, suggestions? # --- # Bruno Barbosa # Seja livre - Use Linux!!! # http://algoritmizando.com # http://twitter.com/bruninbsb # ---

[web2py] Bug in MySQLAdapter

2011-03-04 Thread Milan Melena
I found bug in MySQLAdapter (repository version): 1.1 --- a/gluon/dal.pyThu Mar 03 23:20:20 2011 -0600 1.2 +++ b/gluon/dal.py Fri Mar 04 09:25:00 2011 +0100 1.3 @@ -1470,11 +1470,11 @@ 1.4 charset = m.group('charset') or 'utf8' 1.5

[web2py] Multiple forms grouped as one (django formset equivalent) with jquery plugin allowing clients to add and remove forms on the client-side

2011-03-04 Thread ChrisT
Hello everyone, I am in the process of evaluating web2py and django to decide which one I am going to use for a project of mine. I am new to both frameworks and web frameworks in general (although I did experiment with Ruby on Rails a while back) I must say I am learning web2py much faster than

Re: [web2py] how to change checkbox to button delete in SQLFORM

2011-03-04 Thread Richard Vézina
There is possibility, but I am not sure of the relevance of your needs. 1) jQuery (in view) 2) Once you have your form... (form = SQLFORM(db.table)) you can modify the everything in there that will be under html (in controller)... But it could brake the web2py workflow... 3) Build your own form

[web2py] Re: potential memory leak???

2011-03-04 Thread Anthony
On Friday, March 4, 2011 1:41:13 AM UTC-5, VP wrote: Apache configuration: 5 processes, 1 thread (more than 1 threads will cause WSGI premature script error as previously described). I thought the WSGI premature script error problem was resolved by upgrading psycopg2 to a version

[web2py] Re: potential memory leak???

2011-03-04 Thread Massimo Di Pierro
I do not think it is a memory leak. Please run two tests: 1) What do you get with run with the built-in server instead of apache? 2) what is the output of print db(db.data).select('sum(length(data.body) +length(data.body1)+length(data.body2)+length(data.body3))') I suspect it may be a big

[web2py] Re: mysql dal.py boolean field

2011-03-04 Thread Massimo Di Pierro
should be fixed in trunk. The problem is corrupted data anyway. Massimo On Mar 4, 4:34 am, szimszon szims...@gmail.com wrote: I had a mysql table with boolean field but there was some rows with empty fields than I got that: Traceback (most recent call last): File

[web2py] Re: Weird self submitting forms all checkbox is checked after submit

2011-03-04 Thread Massimo Di Pierro
Which web2py version? I cannnot reproduce it? If latest, can you post some code to reproduce it? On Mar 4, 6:12 am, szimszon szims...@gmail.com wrote: If I Submit form data which contains checkbox (boolean) field I got back the form with all checkbox selected... The database operation is ok.

[web2py] Re: Bug in MySQLAdapter

2011-03-04 Thread Massimo Di Pierro
fixed in trunk. Please check! thank you. On Mar 4, 2:32 am, Milan Melena milan.mel...@gmail.com wrote: I found bug in MySQLAdapter (repository version):       1.1 --- a/gluon/dal.py    Thu Mar 03 23:20:20 2011 -0600      1.2 +++ b/gluon/dal.py     Fri Mar 04 09:25:00 2011 +0100      1.3 @@

[web2py] Re: Multiple forms grouped as one (django formset equivalent) with jquery plugin allowing clients to add and remove forms on the client-side

2011-03-04 Thread Massimo Di Pierro
Hello ChrisT, it is possible but I am not sure I have seen a recipe posted for this. I will try write one next week and post it, perhaps sooner. Massimo On Mar 4, 3:30 am, ChrisT christostopou...@gmail.com wrote: Hello everyone, I am in the process of evaluating web2py and django to decide

[web2py] Re: no json - cont.

2011-03-04 Thread villas
As an aside, I would mention that my experience of naming primary keys anything other than 'id' is that it will always trip you up. In the end I refactored all my codebase to use 'id' across delphi, php and web2py. Glad I did. IMO it is better to do it sooner than later. Regards, D

[web2py] Re: Error in templating system

2011-03-04 Thread villas
The code you posted was clearly badly formed. You need to correct it first. The 'pass' function should always look like this: {{pass}} If something only works in a strange, undocumented way, it is likely to be broken in the future. This is nothing to do with backwards compatibility, it is

[web2py] DAL new syntax RFC

2011-03-04 Thread Massimo Di Pierro
There are some new features in trunk: 1) I got tired of writing default='value',readable=False,writable=False etc. So: Field(':name') is the same as Field('name',readable=False,writable=False) Field('.name') is the same as Field('name',readable=True,writable=False) Field('name=value') is the

Re: [web2py] From .represent to csv: is this possible?

2011-03-04 Thread Richard Vézina
Don't know if it will help : import csv db.export_to_csv_file(open('/home/YOU/Bureau/export_csv_with_represent.csv', 'w'), represent=True, # this bring your representation into the CSV... delimiter='|', quotechar='', quoting=csv.QOUTE_NONNUMERIC) Richard On Fri, Mar 4, 2011 at 4:09

[web2py] Re: potential memory leak???

2011-03-04 Thread VP
Massimo: 1. This is with Apache. 2. print db(db.data).select('sum(length(data.body) +length(data.body1)+length(data.body2)+length(data.body3))') Answer: 1764948 I am looking at ps aux right now. Under VSZ column, there's 141M. Resource is still not released since last night. On Mar 4, 8:27 am,

[web2py] Re: Multiple forms grouped as one (django formset equivalent) with jquery plugin allowing clients to add and remove forms on the client-side

2011-03-04 Thread ChrisT
Wow, a response from the man himself :-) I must admit I was secretly hoping for this and that this is another reason web2py seems like a better choice to me. I have been lurking at discussions for quite some time and I am constantly amazed by the amount of responses you give, always with a

[web2py] Re: potential memory leak???

2011-03-04 Thread VP
For some reason, I missed the rest of that discussion. I didn't upgrade psycopg2. My VPS has not upgraded to Debian 6 yet (but will soon). So, I will wait for a few weeks and then this module will be upgraded together with Debian 6. I will report on this later. On Mar 4, 8:15 am, Anthony

[web2py] Re: One form for multiple tables

2011-03-04 Thread DenesL
Hi Annet, I believe you want something like this: def multitable_form_update(): last=0 if request.args: last=request.args[0] # retrieve next 2 addresses addrs=db(db.cli_addr.idlast).select(limitby=[0,2]) if addrs: addr=addrs[0] curr=addr.id # set defaults to be shown on

[web2py] pysimplesoap GAE caching

2011-03-04 Thread howesc
Hi all, I was wondering if anyone has used pysimplesoap client on GAE with any sort of caching? Since the WSDL is not going to change often, I'd love to cache my client between requests. seems like the client itself is un-pickelable. My next thought is to update the SoapClient.wsdl method

[web2py] FYI change in book

2011-03-04 Thread DenesL
The following paragraph at the end of section http://web2py.com/book/default/chapter/06#orderby,-groupby,-limitby,-distinct has been removed since it no longer applies: Currently, limitby is only partially supported on MSSQL since the Microsoft database does not provide a mechanism to fetch a

Re: [web2py] powerTable.extrajs question

2011-03-04 Thread Richard Vézina
Hello Bruno, What do you think of using web2py service JSONRPC? So we need function to deal with those call from DataTables : intiDisplayStartDisplay start pointintiDisplayLengthNumber of records to displayintiColumnsNumber of columns being displayed (useful for getting individual column search

[web2py] Re: potential memory leak???

2011-03-04 Thread ron_m
RSS (Resident Set Size) is a closer approximation of actual physical memory consumed by a process. VSZ includes shared libraries and anything else required to be mapped in to make the process complete but shared libraries are not in physical memory more than once for all processes except the

Re: [web2py] Error in templating system

2011-03-04 Thread Jonathan Lundell
On Mar 4, 2011, at 1:52 AM, szimszon wrote: web2py™ Version 1.92.1 (2011-02-16 15:04:40) PythonPython 2.5.2: /usr/bin/python Traceback (most recent call last): File /home/szimszon_nfs/web2py/gluon/restricted.py, line 186, in restricted ccode = compile2(code,layer)

Re: [web2py] Re: Apache, Wsgi problem

2011-03-04 Thread VP
For some reason I missed the rest of this discussion. Just a quick follow up. + I upgraded psycopg2 from 2.0.7 (default in Debian 5) to the latest version, 2.4. This manual installation was smoother than I thought. + Result: preliminary stress tests show that the problem *disappeared*.

[web2py] Re: potential memory leak???

2011-03-04 Thread VP
RSS is smaller than VSZ, but the behavior appeared to be the same. The point is that accumulated resources do not seem to get released. I have made changes (upgraded psycopg2), so I will report on this with further testing. On Mar 4, 11:15 am, ron_m ron.mco...@gmail.com wrote: RSS (Resident

Re: [web2py] Re: Apache, Wsgi problem

2011-03-04 Thread Jonathan Lundell
On Mar 4, 2011, at 9:31 AM, VP wrote: For some reason I missed the rest of this discussion. Just a quick follow up. + I upgraded psycopg2 from 2.0.7 (default in Debian 5) to the latest version, 2.4. This manual installation was smoother than I thought. + Result: preliminary stress

[web2py] Re: Apache, Wsgi problem

2011-03-04 Thread VP
To be precise, RSS started with about 32MB (with an apache restart) and starts crawling up to 80MB/process with aforementioned testing. And If I remember correctly, it stayed that way over night and did not get released. As I said, I will do further testing with this toy example and with my real

Re: [web2py] Re: Apache, Wsgi problem

2011-03-04 Thread Jonathan Lundell
On Mar 4, 2011, at 9:46 AM, VP wrote: To be precise, RSS started with about 32MB (with an apache restart) and starts crawling up to 80MB/process with aforementioned testing. And If I remember correctly, it stayed that way over night and did not get released. As I said, I will do further

[web2py] Re: Apache, Wsgi problem

2011-03-04 Thread VP
oops, it looks like that last post was supposed to be for the other thread (potential memory leaks). On Mar 4, 12:28 pm, Jonathan Lundell jlund...@pobox.com wrote: On Mar 4, 2011, at 9:46 AM, VP wrote: To be precise, RSS started with about 32MB (with an apache restart) and starts

[web2py] Anti-spam form technique

2011-03-04 Thread pbreit
Could Web2py's forms be made to work like this? I know they already include a hash to protect against certain form hacking. http://docs.jquery.com/Tutorials:Safer_Contact_Forms_Without_CAPTCHAs

[web2py] Re: Multiple forms grouped as one (django formset equivalent) with jquery plugin allowing clients to add and remove forms on the client-side

2011-03-04 Thread Massimo Di Pierro
wait I actually do it before you thank me.. ;-) On Mar 4, 11:00 am, ChrisT christostopou...@gmail.com wrote: Wow, a response from the man himself :-) I must admit I was secretly hoping for this and that this is another reason web2py seems like a better choice to me. I have been lurking at

[web2py] Re: Error in templating system

2011-03-04 Thread Massimo Di Pierro
I agree that that is what it should do. Please open a ticket about this. On Mar 4, 11:20 am, Jonathan Lundell jlund...@pobox.com wrote: On Mar 4, 2011, at 1:52 AM, szimszon wrote: web2py™  Version 1.92.1 (2011-02-16 15:04:40) Python     Python 2.5.2: /usr/bin/python Traceback

[web2py] web2py 1.93.1 is OUT

2011-03-04 Thread Massimo Di Pierro
Lots of changes! - support for multiple interfaces, thanks Jonathan - upgraded jquery 1.5.1 - upgraded simplejson 2.1.3 - leaner app.yaml - css3 buttons in welcome - android support (experimental) - Field(':hidden'), Field('.readonly'), Field('name=value') (experimental) - combined expressions

Re: [web2py] Re: Error in templating system

2011-03-04 Thread Jonathan Lundell
On Mar 4, 2011, at 12:19 PM, Massimo Di Pierro wrote: I agree that that is what it should do. Please open a ticket about this. Are you saying (I think) that both cases should terminate on a newline (if present)? On Mar 4, 11:20 am, Jonathan Lundell jlund...@pobox.com wrote: On Mar 4,

Re: [web2py] From .represent to csv: is this possible?

2011-03-04 Thread Johann Spies
Hallo Richard, Don't know if it will help : import csv db.export_to_csv_file(open('/home/YOU/Bureau/export_csv_with_represent.csv', 'w'), represent=True, # this bring your representation into the CSV... delimiter='|', quotechar='', quoting=csv.QOUTE_NONNUMERIC) Thanks. I

[web2py] Re: Error in templating system

2011-03-04 Thread Massimo Di Pierro
All I meant is that {{=msg pass}} should become: response.write(msg) pass and not response.write(msg pass) since there is no ambiguity. On Mar 4, 2:25 pm, Jonathan Lundell jlund...@pobox.com wrote: On Mar 4, 2011, at 12:19 PM, Massimo Di Pierro wrote: I agree that that is what it

Re: [web2py] Re: Error in templating system

2011-03-04 Thread Jonathan Lundell
On Mar 4, 2011, at 12:54 PM, Massimo Di Pierro wrote: All I meant is that {{=msg pass}} should become: response.write(msg) pass and not response.write(msg pass) since there is no ambiguity. Right. The question the code has to answer, implicitly, is: exactly what is the

Re: [web2py] web2py 1.93.1 is OUT

2011-03-04 Thread Bruno Rocha
Is there some explanation about these? - support for multiple interfaces - android support (experimental) - Field(':hidden'), Field('.readonly'), Field('name=value') -- Bruno Rocha [ About me: http://zerp.ly/rochacbruno ]

[web2py] Re: web2py 1.93.1 is OUT

2011-03-04 Thread pbreit
I will say, the pace and thoughtfulness of improvements is extraordinary. Thank you, Massimo, and everyone else.

Re: [web2py] web2py 1.93.1 is OUT

2011-03-04 Thread Jonathan Lundell
On Mar 4, 2011, at 1:44 PM, Bruno Rocha wrote: Is there some explanation about these? - support for multiple interfaces The --interfaces item on the command line was broken. Now it works. Each interface is a colon-delimited string, thus: ip:port or ip:port:cert:key, and multiple such

Re: [web2py] web2py 1.93.1 is OUT

2011-03-04 Thread pbreit
The hidden/readonly/default stuff was explained here: https://groups.google.com/d/topic/web2py/4msITKNBNNM/discussion

Re: [web2py] Re: Error in templating system

2011-03-04 Thread Thadeus Burgess
I don't think you should have code included in a {{= block. {{= should ONLY be used to wrap anything in its code block with a response.write(). Exactly how it does it now. Doing otherwise is simply bad template design. I consider it a bug if it ever worked before. Allowing this syntax encourages

[web2py] Re: DAL new syntax RFC

2011-03-04 Thread pbreit
I like the default functionality since it's still really easy to understand. I'm not sold on the : and . shortcuts.

[web2py] Re: potential memory leak???

2011-03-04 Thread ron_m
Depending on the system type the memory doesn't get released. It is rare that a malloc implementation calls sbreak with a smaller number than the previous call which is what you are looking for. If you have a program that consumes say 100 MB to do some initialization and then frees all those

[web2py] mssql, login problems

2011-03-04 Thread Stef Mientki
hello, With the DAL I created tables in an MSSQL database, which I can access as long as I login as the same user. I created the table with a windows login on my own machine, like this Database_Name = r'mssql://NKCV2' My_DB = DAL ( Database_Name, folder = folder ) Now I'm on anther

[web2py] Re: [new slice] Flickr API photosets and web2py

2011-03-04 Thread Bruno Rocha
That is my final solution on Flickr Gallery for web2py. http://serafimnatural.com.br/galeriaflickr/standalone Now I know I can use better aproches as JSON loads of pictures and other methods of the API. When I git it finished, I will pack in a plugin. Now, I am running in some problems for

[web2py] Re: web2py 1.93.1 is OUT

2011-03-04 Thread smg
http://web2py.com/examples/default/changelog - wrong version number (typo).

[web2py] web2py HL7: where come from key:descriptions of some tables?

2011-03-04 Thread Pepe Araya
Hello, I'm trying to understand the Web2py HL7 App and I don't understand where come from the key:descriptions of some tables. e.g: social_history Table id: 1 key: 229819007 description: Tobacco use and exposure (observable entity) Not available Smoking is the key arbitrary or is a

[web2py] Re: DAL new syntax RFC

2011-03-04 Thread Massimo Di Pierro
think of a dot a False. Two does r and w are false, one dot and only w is false. On Mar 4, 4:43 pm, pbreit pbreitenb...@gmail.com wrote: I like the default functionality since it's still really easy to understand. I'm not sold on the : and . shortcuts.

[web2py] Re: web2py 1.93.1 is OUT

2011-03-04 Thread Massimo Di Pierro
oops. Anyway, get 1.93.2 because of a bug in wizard On Mar 4, 5:37 pm, smg smith...@gmail.com wrote: http://web2py.com/examples/default/changelog- wrong version number (typo).

[web2py] Re: web2py 1.93.1 is OUT

2011-03-04 Thread Anthony
Excellent! The new wizard plugin download/install seems to be working for me now. Anthony On Friday, March 4, 2011 3:25:28 PM UTC-5, Massimo Di Pierro wrote: Lots of changes! - support for multiple interfaces, thanks Jonathan - upgraded jquery 1.5.1 - upgraded simplejson 2.1.3 -

[web2py] Re: Error in templating system

2011-03-04 Thread villas
On Mar 4, 10:22 pm, Thadeus Burgess thade...@thadeusb.com wrote: I don't think you should have code included in a {{= block. +1 Explicit is better {{if abc:}} {{=xyz}} {{pass}} Yes, there are extra brackets, but no one's going to have a problem with that.

Re: [web2py] Re: Error in templating system

2011-03-04 Thread Jonathan Lundell
On Mar 4, 2011, at 6:03 PM, villas wrote: On Mar 4, 10:22 pm, Thadeus Burgess thade...@thadeusb.com wrote: I don't think you should have code included in a {{= block. +1 Explicit is better {{if abc:}} {{=xyz}} {{pass}} Yes, there are extra brackets, but no one's going to have a

[web2py] Database change

2011-03-04 Thread darkblue_b
Hi- last night I wanted to change my database name (postgres) and make a couple of small changes.. So, I exported the six tables or so to .csv via the admin pages, then dropped my database, made the change in the DAL connection string, created a new database, and hit go.. That didnt work.. so I

[web2py] Re: DAL new syntax RFC

2011-03-04 Thread Luther Goh Lu Feng
I too like the 'default' syntax much better than the new one. It feels more readable. If the following is feasible, will it be a better solution? Field('name', r=F,w=F) Field('name', d='value') On Mar 5, 7:50 am, Massimo Di Pierro massimo.dipie...@gmail.com wrote: think of a dot a False. Two

[web2py] Radbox getting noticed

2011-03-04 Thread pbreit
One thing I've been looking for is a web2py-based service getting written up in TechCrunch. Radbox is getting close: http://www.businessinsider.com/from-a-new-delhi-cubicle-to-the-new-york-tech-meetup-radbox-kicks-ass-takes-names-2011-3