Re: [web2py] Re: Fixed issue 1422 introduced a bug in generic rss views?

2013-05-31 Thread Loïc
Sorry but I installed latest python version on my laptop (python 2.7.5 on Win7 x64) and it still doesn't work : type 'exceptions.UnicodeDecodeError' 'ascii' codec can't decode byte 0xc3 in position 9: ordinal not in range(128) Versionweb2py™Version

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Andriy
Only now I noticed that not only .css files, but all files from /static folder are served with *text/css* headers for Content-Type. So I started to search why, rewritten all files in *gluon* folder with original source files, and recreated the main problem by doing this. Apparently, for some

[web2py] parse in json

2013-05-31 Thread Pawan Jha
row = db.executesql(SELECT * FROm GetIncidentByIncidentId('+Incidentid+')) T.force('hi') MessageType=T('Please reach') return MessageType list=[] for i in row: data = {'MessageType':MessageType, 'num':i[1]} list.append(data);

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Niphlod
this definitely shouldn't happen, but usually you'd want to serve static files from apache without passing through web2py. Anyway, I can't reproduce the misbehaviour on windows using the latest XAMPP available. PS: Right now that site is wasting power to serve static files through web2py ^_^

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Andriy
Niphlod, could you please tell me how to serve static files from apache without passing through web2py? Or where to read on this? Thanks. I may reinstall Apache. May be its problem with my current version (2.2) or with configuration... -- --- You received this message because you are

[web2py] Re: DAL Select constant field

2013-05-31 Thread Zach
Hey there, it worked, thanks a lot guys. so if I put a string in it it tries to find a column with that name and complains, if I put a number it is ok with it. So now I will explain what i need it for. The ROWs set I getting from the query I am putting it in a SQLGRID with a couple of

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Niphlod
with an aliasmatch and a directory directive. This comes from the sponsored web2py script AliasMatch ^/([^/]+)/static/(.*) \ /home/www-data/web2py/applications/$1/static/$2 Directory /home/www-data/web2py/applications/*/static/ Options -Indexes Order Allow,Deny Allow

[web2py] Re: web2py 2.4.7 admin Recent Tweets not loaded

2013-05-31 Thread Massimo Di Pierro
Done. in trunk. On Thursday, 30 May 2013 22:39:10 UTC-5, 黄祥 wrote: hi, just want to report that web2py 2.4.7 admin Recent Tweets not loaded. error: Unable to download because: local variable 'r' referenced before assignment applications/admin/controllers/default.py def twitter():

[web2py] Re: response.flash is going to center in web2py 2.4.7

2013-05-31 Thread Massimo Di Pierro
We changed the right space to avoid overlap with the login menu. On small screens it may appear to go to center. On Thursday, 30 May 2013 22:50:20 UTC-5, 黄祥 wrote: hi, just tested the web2py 2.4.7 (create new application) and found that response.flash position is going to center (usually

[web2py] Re: web2py 2.4.7 admin Recent Tweets not loaded

2013-05-31 Thread Paolo valleri
Hi, now it seems to work but it is different than the former implementation, namely the current shows only tweets posted by the user web2py, however the most recent one is more than two months old. As is I don't see this so useful, actually It is a matter of communication and which information

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Andriy
Thank you, I did this and I think its Apache serving static files now, because all headers are OK. But if I make request for static file in Opera it has *X-Powered-By: web2py *header... Also I had response.static_version set in model file and now I have problem with it. I`m reading in web2py

[web2py] Re: web2py 2.4.7 admin Recent Tweets not loaded

2013-05-31 Thread Massimo Di Pierro
I think it is better this way. That should be for security updates and new releases. I will do a better job at posting more news. If something is important I can re-tweet. It is not there for a social purpose. Yet this is open for discussion. On Friday, 31 May 2013 08:44:29 UTC-5, Paolo

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Niphlod
definitely they're being served by apache right now. I don't know how Opera can still receive files with the header, it's plain impossible (if the same url is requested by it) I don't know why the aliasmatch doesn't work for static version (nothing seems wrong glancing at it)...I don't have an

[web2py] Re: After update web2py version, invalid login.

2013-05-31 Thread Lamps902
Did you perform an sqlite - postgresql migration which left a bunch of trailing whitespace in various fields? On Sunday, May 26, 2013 3:02:02 AM UTC-5, toni campins wrote: Hi, Why after update web2py i have to edit all passwords for invalid login? Thanks -- --- You received this

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Andriy
So far I found that: http://www.autosim.ru/static/css/web2py.css - without app name in link, returns X-Powered-By: web2py http://www.autosim.ru/mad/static/css/web2py.css - with app name in link, no X-Powered-By header -- --- You received this message because you are subscribed to

Re: [web2py] Re: What is best practice to give a user administrator rights for one application (to manage users)

2013-05-31 Thread Richard Vézina
Hello, Maybe it could be easy to remove this issue and let the appadmin be used by admin user or any user authorized. The search feature of .grid() and .smartgrid() could be used to search in appadmin?? Richard On Thu, May 30, 2013 at 12:50 PM, Massimo Di Pierro massimo.dipie...@gmail.com

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Niphlod
so, config another aliasmatch to match the url without the app name. PS: usually routes.py doesn't rewrite static urls, i.e. the app should generate /mad/static/blablabla.css all the time... Il giorno venerdì 31 maggio 2013 16:59:33 UTC+2, Andriy ha scritto: So far I found that:

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Andriy
Yes, app generates all links with app-name in them. I was making manual requests in Opera without them before. Now only files like autosim.ru/robots.txt have no app name in them and are served with X-Powered-By: web2py header. I dont think its big problem For now I`m stuck, because I have no

[web2py] Re-create database tables

2013-05-31 Thread André Kablu
Hi all, I am creating a new app using MYSQL... and many times I needed to change the fields, including keys, foreign keys, etc... And I always get many mysql errors of not possible to rename, not possible to delete, not possible to create, etc... So what I need to do is to copy all my files

Re: [web2py] Re: What is best practice to give a user administrator rights for one application (to manage users)

2013-05-31 Thread Massimo Di Pierro
We could but we do not want to? On Friday, 31 May 2013 10:05:49 UTC-5, Richard wrote: Hello, Maybe it could be easy to remove this issue and let the appadmin be used by admin user or any user authorized. The search feature of .grid() and .smartgrid() could be used to search in appadmin??

[web2py] Nested dictionaries / JSON to nested HTML-lists

2013-05-31 Thread D.
Dear community, let's say I have a list of strings representing directory-paths: /bar.csv /windows/foo.foo /windows/explorer/bar.exe /windows/explorer/foo.bar /windows/system32/foo.dll /windows/system32/lib/bar.bat I have successfully parsed those into a tree-structure of nested (default-)

[web2py] Re: offtopic: general python code required

2013-05-31 Thread Massimo Di Pierro
data = 0'a' 1'b' 2'c' 1'd'

[web2py] web2py: jQuery and two forms

2013-05-31 Thread A Mehta
I have two SQLFORMS with only the select elements (no submit button). One SQLFORM has the div 'card' other has the div 'evo'. So far I can detect the user has selected an option via: script jQuery('select[name=cards]').on('change', function() { [do something here]});/script If the user picks

[web2py] Set Time

2013-05-31 Thread REM
Greetings! I am just beginning to use web2py and I noticed that, in going through the manual and working on the create wiki section, when I added the RSS feed section, the indicated creation time listed for the wiki was hours and hours earlier than its actual local creation time. Other time

[web2py] Re: Re-create database tables

2013-05-31 Thread Loïc
If you want to delete all tablesand recreate them, you can : * (be aware that you will lose all your data) * - Delete all your tables on MySQL (it would be a good idea to make a backup of your data before...) - Delete all files in *YourApplication/databases *folder - Launch your

[web2py] Manual: RE built-in wiki

2013-05-31 Thread REM
Felicitations, Fellow Primates! I'm working through the web2py manual and, having reached the built-in wiki section and following the instructions, after the built-in wiki is created (logged in as admin, of course otherwise we couldn't create it to begin with), we navigate to the index for the

[web2py] Re: parse in json

2013-05-31 Thread Derek
Add this at the top... T.lazy=False On Friday, May 31, 2013 5:29:21 AM UTC-7, Pawan Jha wrote: row = db.executesql(SELECT * FROm GetIncidentByIncidentId('+Incidentid+')) T.force('hi') MessageType=T('Please reach') return MessageType list=[] for i in row:

[web2py] Re: Nested dictionaries / JSON to nested HTML-lists

2013-05-31 Thread Alan Etkin
Now I would like to turn this into a nested html-list? How would I accomplish this task in web2py? (possibly by using html-helpers). # You can put something like the following in the controller or the model def ulmaker(val): ul = UL() for k, v in val.iteritems(): if

[web2py] Re: Nested dictionaries / JSON to nested HTML-lists

2013-05-31 Thread Derek
Alan, that is a beautiful recursive function. On Friday, May 31, 2013 10:32:52 AM UTC-7, Alan Etkin wrote: Now I would like to turn this into a nested html-list? How would I accomplish this task in web2py? (possibly by using html-helpers). # You can put something like the following in

[web2py] Re: Found solution! cgi.FieldStorage problem exposed

2013-05-31 Thread Derek
Yeah, I think I'd monkey-patch it. On Thursday, May 30, 2013 11:15:22 AM UTC-7, Joe Barnhart wrote: Wow! I've rediscovered a bug from 2001! And they say I'm living in the past... Well at least I'm not alone back there. Massimo is back there with me!

[web2py] Re: offtopic: general python code required

2013-05-31 Thread Derek
not a bad try, i think it may be more beautiful with recursion. i'll give a stab at it. If Alan reads this, I suspect he can spit something out fast. On Friday, May 31, 2013 9:42:04 AM UTC-7, Massimo Di Pierro wrote: data = 0'a'

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Andriy
Ok, it looks like a typo in web2py.com/books/default/chapter/29/04#Static-asset-management ? I`ve made a simple script to look what this pattern actually matching, and found that its not matching version string at all. By trial and error I found unnecessary Slash after *^/([^/]+)/static/(?:*

[web2py] Re: Set Time

2013-05-31 Thread Massimo Di Pierro
If your app running on a server? the example app uses request.now to determine the time when records are created. That is the time of the server, not the time of the client. On Friday, 31 May 2013 11:00:10 UTC-5, REM wrote: Greetings! I am just beginning to use web2py and I noticed that,

[web2py] Re: Manual: RE built-in wiki

2013-05-31 Thread Massimo Di Pierro
You are right. The book is missing something. The catch is that if you are logged into the applications and you are also logged into admin, it will automatically make a wiki_editor group and make you member. On Friday, 31 May 2013 12:23:42 UTC-5, REM wrote: Felicitations, Fellow Primates!

[web2py] Re: parse in json

2013-05-31 Thread Massimo Di Pierro
I thought this was fixed. Do you have the OSX version or an older version? You can also replace MessageType=T('Please reach') with MessageType=str(T('Please reach')) On Friday, 31 May 2013 07:29:21 UTC-5, Pawan Jha wrote: row = db.executesql(SELECT * FROm

[web2py] Re: Found solution! cgi.FieldStorage problem exposed

2013-05-31 Thread Massimo Di Pierro
Let us know your solution. On Friday, 31 May 2013 12:59:04 UTC-5, Derek wrote: Yeah, I think I'd monkey-patch it. On Thursday, May 30, 2013 11:15:22 AM UTC-7, Joe Barnhart wrote: Wow! I've rediscovered a bug from 2001! And they say I'm living in the past... Well at least I'm not alone

[web2py] Re: offtopic: general python code required

2013-05-31 Thread Massimo Di Pierro
Why use recursion when you can use dynamic programming, save memory and function calls. ;-) On Friday, 31 May 2013 13:03:26 UTC-5, Derek wrote: not a bad try, i think it may be more beautiful with recursion. i'll give a stab at it. If Alan reads this, I suspect he can spit something out

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Massimo Di Pierro
can you send me a book patch? On Friday, 31 May 2013 13:51:46 UTC-5, Andriy wrote: Ok, it looks like a typo in web2py.com/books/default/chapter/29/04#Static-asset-management ? I`ve made a simple script to look what this pattern actually matching, and found that its not matching version

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Niphlod
well, in theory the regex should match /app/static/file.css AND /app/static/_1.2.3/file.css basically stripping the /_1.2.3 part That slash should kick in differently, I agree. Just tested can you try *^/([^/]+)/static/(?:_[\d]+.[\d]+.[\d]+/)?(.*)* ? On Friday, May 31, 2013 8:51:46 PM

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Niphlod
as soon as andriy confirms, I'll send a book patch and a patch for the gluon/scripts relevant files :-P On Friday, May 31, 2013 8:59:06 PM UTC+2, Massimo Di Pierro wrote: can you send me a book patch? On Friday, 31 May 2013 13:51:46 UTC-5, Andriy wrote: Ok, it looks like a typo in

[web2py] Re: SQLFORM.grid view

2013-05-31 Thread John Fraser
That works. Thanks! On Thursday, May 30, 2013 11:12:30 PM UTC-4, Anthony wrote: Maybe try: db.announcement.body.represent = lambda v, r: XML(v, sanitize=True) The sanitize=True will remove potentially unsafe HTML/Javascript from the content. Anthony On Thursday, May 30, 2013

[web2py] Re: Set Time

2013-05-31 Thread REM
Yes, it is running on a local server and I am probing at it from both the local machine and a remote one just to be certain (well, certain-ish) that I don't miss some meaningful difference. Still, everyone is in the same time zone (and same room, even), so I thought this time difference was a

[web2py] Ajax-form-submission: pass ALL form-elements

2013-05-31 Thread D.
Dear community, I'm using ajax to submit a form: $(#myform).submit(function() { ... ajax({{=URL(do_stuff, user_signature=True)}}, [element1, element2, ...], target); return false; } This works very well. However, when #myform has many elements or is created/modified dynamically, naming all

[web2py] Re: Set Time

2013-05-31 Thread Massimo Di Pierro
check the value of request.now. Should be localtime but one can redefine it to utctime. On Friday, 31 May 2013 14:56:15 UTC-5, REM wrote: Yes, it is running on a local server and I am probing at it from both the local machine and a remote one just to be certain (well, certain-ish) that I

[web2py] Re: Ajax-form-submission: pass ALL form-elements

2013-05-31 Thread Niphlod
see https://groups.google.com/forum/?fromgroups=#!searchin/web2py/ajax$20anthony/web2py/sYFJWdLoO3g/V-g6KB6XfqYJ On Friday, May 31, 2013 10:10:08 PM UTC+2, D. wrote: Dear community, I'm using ajax to submit a form: $(#myform).submit(function() { ... ajax({{=URL(do_stuff,

[web2py] auto view creation

2013-05-31 Thread Alex Glaros
my developer partner moved my windows-created web2py app to Rackspace when I create a new def in the controller on Rackspace, it doesn't automatically create a view like the windows desktop version of web2py. Is there a way to get that functionality on Rackspace? Not a big deal to manually

[web2py] Re: auto view view

2013-05-31 Thread Anthony
http://web2py.com/books/default/chapter/29/10#Generic-views On Friday, May 31, 2013 5:38:06 PM UTC-4, Alex Glaros wrote: my developer partner moved my windows-created web2py app to Rackspace when I create a new def in the controller on Rackspace, it doesn't automatically let me view the

[web2py] Re: auto view view

2013-05-31 Thread Massimo Di Pierro
Alex but be careful that allowing all ['*'] generic views may be a security hazard some cases. Only allow generic views for those extensions (html) and those actions that need them. It may be better to just make a normal view. On Friday, 31 May 2013 16:56:28 UTC-5, Anthony wrote:

[web2py] Re: auto view view

2013-05-31 Thread Alex Glaros
Thanks Anthony, it worked. Thanks Massimo. Changed it to *.html and will disable that when not prototyping. Hope that's a secure strategy. Much appreciated, Alex On Friday, May 31, 2013 3:08:57 PM UTC-7, Massimo Di Pierro wrote: Alex but be careful that allowing all ['*'] generic views

[web2py] how to select all users not in a group in web2py

2013-05-31 Thread Mark Finkelstein
I was wondering how to select all users not in a group with a certain role. I tried using: db(db.auth_group.role=='site_admin')(db.auth_membership.group_id==db.auth_group.id)(db.auth_membership.user_id!=db.auth_user.id).select(db.auth_user.id, db.auth_user.first_name, db.auth_user.last_name,

[web2py] how to select all users not in a group in web2py

2013-05-31 Thread Mark Finkelstein
I was wondering how to select all users not in a group with a certain role. I tried using: db(db.auth_group.role=='site_admin')(db.auth_membership.group_id==db.auth_group.id)(db.auth_membership.user_id!=db.auth_user.id).select(db.auth_user.id, db.auth_user.first_name, db.auth_user.last_name,

[web2py] Re: how to select all users not in a group in web2py

2013-05-31 Thread Alan Etkin
I was wondering how to select all users not in a group with a certain role. Perhaps there's a better way, but here's a recipe: group_id = db(db.auth_group.role==role name).select().id users = db((db.auth_user.id==db.auth_membership.user_id)(db.auth_membership.group_id!=group_id)).select()

[web2py] Re: how to select all users not in a group in web2py

2013-05-31 Thread Massimo Di Pierro
I do not think this does what asked because it will match everybody. This should work: group_id = auth.id_group('role name') all_users_in_group = db(db.auth_membership.group_id==group_id)._select(db.auth_membership.user_id) users = db(!db.auth_user.id.belongs(all_users_in_group)).select() On

[web2py] Re: Nested dictionaries / JSON to nested HTML-lists

2013-05-31 Thread Alan Etkin
that is a beautiful recursive function. For the structure of the example dictionary, it seems there's no way of separating a file from an empty folder, so I'd change the structure to something like {foo: {bar: None, foo: {}}} That would be converted to foo (folder) bar (file) foo

Re: [web2py] Re: Random, wrong strings in Content-Type Response header for .css

2013-05-31 Thread Andriy
Yes, *^/([^/]+)/static/(?:_[\d]+.[\d]+.[\d]+/)?(.*)* works. -- --- 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

[web2py] Re: Ember.js and web2py together

2013-05-31 Thread Massimo Di Pierro
Nice work. There is no way to escape {{ in views but perhaps there should be. On Thursday, 30 May 2013 22:40:47 UTC-5, rppowell wrote: Hello; I am attempting to integrate emberjs into web2py. I am doing this both as an experiment and to learn about the two frameworks (javascript

Re: [web2py] Re: psycopg2 or pg8000

2013-05-31 Thread Massimo Di Pierro
Can you try this? With postgres and pg8000 db.define_table('thing',Field('name')) value = r\' db.thing.insert(name=value) It should insert the thing but I suspect you will get an error You can also try: id = db.thing.insert(name='%') print db.thing[id].name do you get '%' or '%%'? Massimo