Re: [web2py] Problem with rname?

2014-04-16 Thread Johann Spies
Hallo Richard, I use rname to be able to make use of Postgresqll schemas. e.g. rname = 'level1.journal' In this case when migrate is true, DAL will create a table 'journal' in the schema 'level1' . And that is working as expected. My problem as stated above is only when I then make changes

[web2py] Re: Online Manual: Chapter 9: Access Control - Formatting/content issues?

2014-04-16 Thread Seeker
Thanks lots Tim. On Tuesday, 15 April 2014 14:24:25 UTC+2, Tim Richardson wrote: On Monday, 14 April 2014 22:05:44 UTC+10, Seeker wrote: Hi Tim, Any idea how long it will take for caches to clear? The problem still persists :-| It's ok now. -- Resources: - http://web2py.com -

[web2py] too many values to unpack

2014-04-16 Thread Richard
I have a working app and added a list of form in the response variables from the controller tot the view. Now the app comes with the error too many values to unpack. I can imagine that there is a limit tot the response size. Is there and how can I increase this. Background info: I want to add

Re: [web2py] Re: Online Manual: Chapter 9: Access Control - Formatting/content issues?

2014-04-16 Thread Michele Comitini
+1 Thank you Tim! 2014-04-16 8:48 GMT+02:00 Seeker tmurn...@gmail.com: Thanks lots Tim. On Tuesday, 15 April 2014 14:24:25 UTC+2, Tim Richardson wrote: On Monday, 14 April 2014 22:05:44 UTC+10, Seeker wrote: Hi Tim, Any idea how long it will take for caches to clear? The problem

Re: [web2py] Nginx/passenger/web2py - 504 Gateway Timeout?

2014-04-16 Thread LightDot
I use apache and mod_passenger (Scientific Linux 6.x / EPEL) on a couple of high traffic web2py apps, works like a charm. Passenger is really neat, I'm testing an unified solution that provides python, nodejs and ruby support with seamless passtrough for PHP / HTML / static files. Apart of

Re: [web2py] too many values to unpack

2014-04-16 Thread Carlos Costa
To show some code should help us to help you. This type of error occurs when something like this is tried; d = dict(a='a',b='b') a, b, c = d 2014-04-16 6:36 GMT-03:00 Richard richard.dijks...@planet.nl: I have a working app and added a list of form in the response variables from the

Re: [web2py] Re: Change the download text from file to something else?

2014-04-16 Thread Niphlod
there should be one. if not, i should be created On Tuesday, April 15, 2014 4:23:24 PM UTC+2, Ramos wrote: 2014-04-15 14:24 GMT+01:00 Niphlod nip...@gmail.com javascript:: 'file ## download' You lost me where do i find the string 'file ## download' ? -- Resources: - http://web2py.com

[web2py] T when sending email

2014-04-16 Thread Kenneth
Hello, I'm trying to send email that is made from about 6-7 T('texts'). But newlines are not inserted into the emails. How should I do that? Kenneth -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Re: Change the download text from file to something else?

2014-04-16 Thread António Ramos
i created this in my view before the upload widget h1{{=T(file ## download)}}/h1 i see it in my language file and i translate it. i refresh this page and the h1 tag shows the translated text but the upload widget continues to show file next to the upload button. So it does not solve my problem.

Re: [web2py] Re: Change the download text from file to something else?

2014-04-16 Thread António Ramos
a litle more info i use sqlform form=SQLFORM(db.trabalhador,row.id, showid=False, submit_button=Gravar, fields=formfields, table_name='trabalhador', formstyle = 'table2cols', upload=URL('download'), readonly=readonly ) to create

[web2py] 'Table' object has no attribute 'attr'

2014-04-16 Thread Richard
I have used a form in a view and want to update a record after submit: View: {{=SQLFORM(db.activity, record = a.id, deletable = True, hidden=dict(attr='chgact'))}} controller: if (request.vars['attr'] == 'chgact') and (request.vars['delete_this_record'] != 'on'):

[web2py] SQLFORM.grid Export and represent

2014-04-16 Thread John Fraser
Is there an easy way to strip HTML markup from SQLFORM.grid's CSV/TSV export? I realize I probably need to create a custom export function, but curious if there is an argument or a one liner that would do the trick. Or is there a better way to format the display? I have the following

[web2py] routes.py invalid request

2014-04-16 Thread Cliff Kachinske
Using pattern-based routing, I get Invalid Request messages. Usually the routes work OK after restarting nginx. But after closing and restarting Chrome the problem recurs. The failing url is www.dotzle.com/apps This is the routes.py file. I used the nginx setup script. The only change I made

[web2py] Re: SQLFORM.grid Export and represent

2014-04-16 Thread Cliff Kachinske
There must be something in the request that indicates you want csv or tsv. If it's in the request.args, for example, something like this would work: if 'csv' not in request.args and 'tsv' not in request.args: db.inventory.cpu_status.represent = lambda cpu_status, row: SPAN( ... On

[web2py] Re: SQLFORM.grid Export and represent

2014-04-16 Thread Anthony
Also, I believe CSV does not use the represent attribute (i.e., it returns the raw values) -- only TSV converts the values via represent. So, maybe just disable TSV. Anthony On Wednesday, April 16, 2014 1:29:30 PM UTC-4, Cliff Kachinske wrote: There must be something in the request that

[web2py] Re: id field is editable through REST PUT request

2014-04-16 Thread Derek
You're right, I guess you should store the ID in session state... but wait, this is ReST... part of the url then, and not a parameter. and PUT should not take the record_id. On Saturday, April 12, 2014 3:01:20 PM UTC-7, Massimo Di Pierro wrote: That is not a hole. This code: def

Re: [web2py] Re: SQLFORM.grid Export and represent

2014-04-16 Thread John Fraser
The problem is I need the values 'as displayed to the user' for all referenced fields. So I need the represent value for some fields and do not for others. I was over thinking the problem and Cliff pointed me in the right directionThanks as this appears to work. Vars not Args if

[web2py] Re: id field is editable through REST PUT request

2014-04-16 Thread Henry Nguyen
Simply inserting into the tables blindly was the problem, as Massimo pointed out. I've gone ahead and implemented manual checking of the vars: def PUT(*args, **vars): required_vars = ['id'] optional_vars = ['first_name','last_name'] # Check for required vars

[web2py] Best way to implement SQL select query

2014-04-16 Thread Rob Goldsmith
I tried posting this earlier, but it doesn't seem to have appeared yet - so apologies if this comes up twice. I am writing a web2py application which accepts a UK postcode then provides information about nearby postcodes. I have tried two methods, both of which work fine when the number of

[web2py] Most efficient way to do SQL select with condition constrained by a list

2014-04-16 Thread Rob Goldsmith
Hi I'm writing a web2py application that starts with a UK postcode and then retrieves information for surrounding UK postcodes. I have tried two methods of doing this - both of which work fine when the surrounding search area is relatively small (i.e. when there are few extra postcodes).

[web2py] Problems running with Cygwin

2014-04-16 Thread Andre Basel
I have been following: http://killer-web-development.com/section/2/5 As per the tutorial, I can get the following lines to work: curl -O http://www.web2py.com/examples/static/web2py_src.zip $ unzip web2py_src.zip $ cd web2py However when I run the last line: $ ./web2py.py Nothing

[web2py] 'auth.settings.register_verify_password = True' does not generate password confirmation field

2014-04-16 Thread Spokes
I am writing a custom registration form, and would like the form to contain a field in which the user has to re-enter/confirm the password they want. The new user() function contains the following lines: def user(): if request.args(0) == 'login': return dict(form = auth())

[web2py] Re: id field is editable through REST PUT request

2014-04-16 Thread Niphlod
it's not that far-fetch to include a control for writable = False fields. def PUT(table_name, record_id, **vars): tb = db[table_name] cant_update_those = [tb[k] for k in tb.fields if tb[k].writable is False] invalid_fields = set(vars) set(cant_update_those) if

Re: [web2py] Re: Change the download text from file to something else?

2014-04-16 Thread Niphlod
what version are you using ? with latest stable (2.9.5), I just confirmed that the string pops up quite fine. Can you pack an app to reproduce ? On Wednesday, April 16, 2014 4:23:06 PM UTC+2, Ramos wrote: a litle more info i use sqlform form=SQLFORM(db.trabalhador,row.id,

[web2py] Re: Best way to implement SQL select query

2014-04-16 Thread Niphlod
what field type is f_postcode ? what type is the result variable ? On Wednesday, April 16, 2014 2:39:02 PM UTC+2, Rob Goldsmith wrote: I tried posting this earlier, but it doesn't seem to have appeared yet - so apologies if this comes up twice. I am writing a web2py application which

[web2py] Re: id field is editable through REST PUT request

2014-04-16 Thread Henry Nguyen
Nice... thank you, Niphlod... I hadn't even considered checking that field attribute directly like that. Henry On Wednesday, April 16, 2014 1:14:21 PM UTC-7, Niphlod wrote: it's not that far-fetch to include a control for writable = False fields. def PUT(table_name, record_id,

Re: [web2py] 'Table' object has no attribute 'attr'

2014-04-16 Thread Carlos Costa
The book says in http://web2py.com/books/default/chapter/29/07/forms-and-validators causes the hidden fields to be passed with the submission, no more, no less. form.accepts(...) is not intended to read the received hidden fields and move them into form.vars. The reason is security. Hidden fields

[web2py] Re: T when sending email

2014-04-16 Thread Kenneth
Hello, text send.mail() Kenneth what format are you sending the emails ? text or html ? What's the used function to send the emails ? On Wednesday, April 16, 2014 2:20:02 PM UTC+2, Kenneth wrote: Hello, I'm trying to send email that is made from about 6-7 T('texts'). But newlines

[web2py] Hosting separate web2py application and PHP application on same apache fedora server

2014-04-16 Thread sonu kumar
I am running one web2py application on fedora webserver. Now I would like to run one PHP application on this same server, but I am not able to configure its httpd.conf file. At the moment my web2py application setting in httpd.conf file is below in black and red is for my PHP application but

[web2py] Re: Hosting separate web2py application and PHP application on same apache fedora server

2014-04-16 Thread LightDot
First thing that jumps at me is the Deny from all directive in your PHP vhost... The other things I notice are the typos: you have catdb subdomain, catpdb document root and caspdb directory. At least one of those is a clear typo. Apache logs are quite helpful with these stuff. Regards On

Re: [web2py] Re: T when sending email

2014-04-16 Thread Roberto Perdomo
Try something like this if you are using simple text email: line1 = T('This is line one') line2 = T('This is line two') message = '%s\n%s' % (line1, line2) mail.send(to='y...@example.com', subject='hello', # If reply_to is omitted, then mail.settings.sender is used

[web2py] Re: Hosting separate web2py application and PHP application on same apache fedora server

2014-04-16 Thread sonu kumar
I just corrected all typos and deleted Deny from all and also added ErrorLog /data/www/html/caspdb/error_log but still not working as well as nothing is written in error_log file On Wednesday, 16 April 2014 17:04:58 UTC-7, LightDot wrote: First thing that jumps at me is the Deny from all

[web2py] Re: Hosting separate web2py application and PHP application on same apache fedora server

2014-04-16 Thread LightDot
So what is the error you get? Apache should either complain at server restart or you should be able to see at least some error description when you attempt to open the page. Also, I assume you have PHP configured outside of this vhost and enabled server-wide? Are you using mod_fcgid or..? On

[web2py] Re: Hosting separate web2py application and PHP application on same apache fedora server

2014-04-16 Thread sonu kumar
When I open my catdb application on web it says browser could not find... there is one php.conf file in /etc/httpd/conf.d/ my php application is totally independent of web2py application... On Wednesday, 16 April 2014 17:45:35 UTC-7, LightDot wrote: So what is the error you get? Apache should

[web2py] Re: Best way to implement SQL select query

2014-04-16 Thread Joe Barnhart
You probably want belongs instead of contains. It's a common mistake (which I make regularly myself). The contains function in web2py is to test if strings are contained in a field, i.e. db.mytable.myfield.contains(joe) is like db.mytable.myfield.like(%joe%). Belongs is used to test for

[web2py] Re: Problems running with Cygwin

2014-04-16 Thread Dave S
On Wednesday, April 16, 2014 3:26:13 AM UTC-7, Andre Basel wrote: I have been following: http://killer-web-development.com/section/2/5 As per the tutorial, I can get the following lines to work: curl -O http://www.web2py.com/examples/static/web2py_src.zip $ unzip web2py_src.zip $ cd

[web2py] Re: Hosting separate web2py application and PHP application on same apache fedora server

2014-04-16 Thread LightDot
Browser could not find... means exactly that. That might not be an apache error at all... If your domain / subdomain names are correct, than you're missing DNS entries for either caspdb or cleav subdomains. They might work locally if you've put them in /etc/hosts, but they most certainly won't

Re: [web2py] Problems running with Cygwin

2014-04-16 Thread Kiran Subbaraman
python 2.7.x should be 32bit. cygwin use the 32bit installer. Since it is from source, you can run this as python ./web2py.py I just tried this on my Windows8 box, and this works. Kiran Subbaraman