[web2py] Re: Formatting JSON objects with XML() -TypeError: is not JSON serializable

2014-02-24 Thread Brando
Anthony, that error is produced when I change the field line like i show above. I basically need to know how to change this list: ['Line: 324 ~ tom', 'Line: 246 ~ dick', 'Line: 112 ~ harry'] into this html: Line: 324 - tom Line: 246 - dick Line: 112 - harry The problem seems to arise when I t

Re: [web2py] Auth with multiple E-mail addresses

2014-02-24 Thread Damien
Thank you for your answers. I think at this point my best option is to rewrite a class inheriting from Auth. If it works well I can publish it and we can discuss if it might be interesting to merge it to the trunk. Le dimanche 23 février 2014 04:41:24 UTC-5, mweissen a écrit : > > I think a new

[web2py] Re: How to use twitter bootstrap style

2014-02-24 Thread Jessica Le
How do you add the data toggle, data target, etc. as well? For example: form.element(_type='submit')(['_class']='btn btn-default',['_data-toggle']='modal',['_data-target']='.bs-example-modal-lg') but that doesn't work... On Friday, July 6, 2012 12:06:30 PM UTC-5, Annet wrote: > > To change

[web2py] Jquery Mobile

2014-02-24 Thread clara
Hi all, I am using jquerymobile on a web2py test application and I realize that the "response.flash" notifications can not be closed or dismissed. I checked the layout.html in jquery_plugin and it does include web2py_ajax.html which includes web2py.js, but the notifications don't work as desire

[web2py] Re: Another multiple file upload and file drop area demo, this time using dropzone.js

2014-02-24 Thread Morten Frellumstad
Just what I was looking for :) Thanks! PS! I had to update dropzone.js to make it work with Chrome. Regards Morten On Monday, December 16, 2013 7:21:01 PM UTC+1, Leonel Câmara wrote: > > I did this to see how I could integrate dropzone.js ( > http://www.dropzonejs.com/ ) with web2py as I'm thi

[web2py] Re: Multiple tables: update/insert/delete: in one form

2014-02-24 Thread trr
Have you switched over from VFP to web2py? If so I would like to take your guidance for a similar data intensive app. On Monday, May 30, 2011 9:25:01 PM UTC+5:30, Vineet wrote: > > Can anybody toss his/her ideas on my code given in the previous post? > ---Vineet -- Resources: - http://web2py.c

[web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Massimo Di Pierro
$filename = $_FILES["file"]["name"]; move_uploaded_file($_FILES["file"]["tmp_name"], "uploaded/".$filename); would be: import shutil, os filename = request.post_vars.file.filename shutil.copyfileobj(request.post_vars.file.file, open(os.path.join(uploaded,filename),'w')) This is very UNSAFE (bo

Re: [web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Teddy Nyambe
Hi again, I have found out as follows after twiking with the dhtmlx framework. I am not sure how o access the actual image, i have noticed the file is an instance of something...not a file per say. i have the following results: print type(file) type: print dir(file) dir: ['FieldStorageClass'

[web2py] Re: Date display i18n internationalization?

2014-02-24 Thread Massimo Di Pierro
For now do this: T.current_languages = [] T.force(T.http_accept_language) This should work. I will try figure out why T.set_current_languages() does not. On Monday, 24 February 2014 18:07:40 UTC-6, User wrote: > > This does not appear to work the string is not translated. Also the > following

Re: [web2py] Using Recaptcha

2014-02-24 Thread Kiran Subbaraman
Include request in the parameters, and see if that works. Recaptcha(request, ) Kiran Subbaraman http://subbaraman.wordpress.com/about/ On Tue, 25-02-2014 6:40 AM, horridohobbyist wrote: I'm trying to use Recaptcha. I'm following the instructions given

[web2py] simple count(*) field in SQLFORM.grid

2014-02-24 Thread Don O'Hara
I'm trying to transliterate this sql into web2py: select g.name, p.status, count(*) from garden g join plot p on g.id = p.garden_id group by g.name, p.status order by g.name; Given this model: db.define_table('garden', Field('name',requires=[IS_NOT_EMPTY()]), Field('status')) db.define_tab

[web2py] Re: Formatting JSON objects with XML() -TypeError: is not JSON serializable

2014-02-24 Thread Anthony
What exactly produced that error, and can you show the rest of the traceback details? On Monday, February 24, 2014 10:04:09 PM UTC-5, Brando wrote: > > I have json data that looks like this: > > [['tom', 324],['dick', 246],['harry', 112]] > > I want to be able to display html like follows: > > Li

[web2py] Formatting JSON objects with XML() -TypeError: is not JSON serializable

2014-02-24 Thread Brando
I have json data that looks like this: [['tom', 324],['dick', 246],['harry', 112]] I want to be able to display html like follows: Line: 324 - tom Line: 246 - dick Line: 112 - harry SoI made a function to reformat my data and use represent to run the data through the function: Field('use

[web2py] Re: HELP with bootstrap 3

2014-02-24 Thread LightDot
Modernizr and Respond are not interchangeable. Modernizr detects detailed browser capabilities and makes conditional JS/CSS programming possible, while Respond adds the support for certain CSS3 media queries to older browsers (IE 6-8), thus enabling them to display responsive designs. Bootstrap

[web2py] Using Recaptcha

2014-02-24 Thread horridohobbyist
I'm trying to use Recaptcha. I'm following the instructions given here: http://www.web2py.com/book/default/chapter/09#CAPTCHA-and-reCAPTCHA However, when I try to execute the form, I get this error: 'NoneType' object has no attribute 'env' Traceback (most recent call last): File "/home/www-da

[web2py] Re: Represent: List indexing problem.

2014-02-24 Thread Brando
I solved this by inserting the data as json. This line now returns '324'. Field('username', represent = lambda x, row: x[0][1]), -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issue

[web2py] Re: Date display i18n internationalization?

2014-02-24 Thread User
This does not appear to work the string is not translated. Also the following doesn't work either: T.set_current_languages() T.force('en-us') However, as mentioned above changing this back to: T.current_languages = [] T.force('en-us') Does work On Monday, February 24, 2014 6:45:18 PM UTC-

[web2py] Re: Date display i18n internationalization?

2014-02-24 Thread Massimo Di Pierro
Ok. One more try: T.set_current_languages() On Monday, 24 February 2014 17:36:10 UTC-6, User wrote: > > I added T.current_languages = [] to the end of my model but this did > nothing. Then I tried: > > T.current_languages = [] > T.force('en-us') > > This caused the translated string in en-us.p

[web2py] Re: Date display i18n internationalization?

2014-02-24 Thread User
I added T.current_languages = [] to the end of my model but this did nothing. Then I tried: T.current_languages = [] T.force('en-us') This caused the translated string in en-us.py to show up in the rendered html (and also caused the filling of en-us.py with default strings). However, I still

[web2py] Represent: List indexing problem.

2014-02-24 Thread Brando
I am parsing data out of files and inputting this data into a sqlite db. One file may have multiple username entries. The data looks something like this: [['tom', 324],['dick', 246],['harry', 112]] The first item in each list is obviously the name. The second line is the line number (i used

[web2py] Re: How to pre filter a table I want to join.

2014-02-24 Thread Avi A
Yep, this way it work: if request.vars.platform != 'ALL': platform_query = db.t_tests.f_test_platform == request.vars.platform graph_query = graph_query & (platform_query) if request.vars.project != 'ALL': project_query = db.t_tests.f_test_project == request.vars.proje

[web2py] Re: HELP with bootstrap 3

2014-02-24 Thread Massimo Di Pierro
Can you elaborate on the pros and cons? On Monday, 24 February 2014 12:31:12 UTC-6, LightDot wrote: > > I misunderstood you at first because I was looking at the modernizr too > much. If the proposal is to put respond.js into static/js, and remove > modernizr from it, than I'm +1 to that. > > >

[web2py] Re: How to pre filter a table I want to join.

2014-02-24 Thread Avi A
I'll try to filter the t_tests only first. On Monday, February 24, 2014 4:51:31 PM UTC+2, Avi A wrote: > > Hi, > I want to join t_a and t_b: > rows = db(db.t_a.created_by == auth.user.id).select(join=db.t_b.on(db.t_a.f_y > == db.t_b.id)) > that works, > But first I want to filter out t_b, for e

[web2py] Re: How to pre filter a table I want to join.

2014-02-24 Thread Avi A
I tried the below syntex. It works, throughs no errors but the list is not being filtered, (when selecting a value other than ALL): def filter_eco_graph(): my_graphs = db.t_tests_results.created_by == auth.user.id a = request.vars # just for testing and it renders what is expected. ()

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-02-24 Thread Mariano Reingart
You could try to update pg8000 from the official: https://github.com/mfenniak/pg8000 Let us know if that works, so we could update the one distributed with web2py The one currently distributed in contrib is an older version with custom patches (as it was not being mantained at the time it was inc

[web2py] Re: select rows having more than one item in list:string field

2014-02-24 Thread Anthony
list:string field values are stored as simple strings with the items delimited by "|" characters (the values are converted to/from lists during the select/insert process on the web2py side). So, a value with one tag would like like "|tag|", and a value with more than one tag would therefore hav

[web2py] select rows having more than one item in list:string field

2014-02-24 Thread Kök Eksi Bir
How do I write a query that selects rows having more than one item in list:string field? Assume I have a table definition db.define_table('sample_table', Field('tags', 'list:string'), ) How can I select rows that have more than one tag? Regards, -- Resources: - http://web2py.com

Re: [web2py] Re: Web2py Integration with Multiple Oauth Logins

2014-02-24 Thread Quint van den Muijsenberg
James, May I suggest we continue this discussion in the google code repo? You could create an issue with a link to this thread. Quint On Feb 23, 2014 10:21 PM, "James Q" wrote: > Hello again, > > Thanks for taking your time to engage with me. Hopefully I can get this > working sometime soon. >

[web2py] Re: HELP with bootstrap 3

2014-02-24 Thread LightDot
I misunderstood you at first because I was looking at the modernizr too much. If the proposal is to put respond.js into static/js, and remove modernizr from it, than I'm +1 to that. >> https://cdnjs.cloudflare.com/ajax/libs/respond.js/1.4. >> 2/respond.js"> >> >>> https://cdnjs.cloudflar

[web2py] Re: Javascript/Jquery after Form Validation?

2014-02-24 Thread Anthony
Validation happens on the server, after the form has been submitted, so at that point it is too late to do anything on the original page in the browser. You could run some JS on the returned page after it loads, or put the form in an Ajax component and put some code in response.js to run when t

[web2py] Re: HELP with bootstrap 3

2014-02-24 Thread LightDot
Both of these js's are commented out by default (note, the if sentence is commented out entirely), so it would work without internet connection. Anyway, for me it's ok either way... Pesonally, I don't use CDNs but I also prefer to have as few files in the welcome app as possible, especially if

[web2py] Javascript/Jquery after Form Validation?

2014-02-24 Thread EW
I have a web2py form (sqlform.factory to be specific). After all the fields have been validated, I would like to call a javascript function using the form values as arguments. How can I do this? When I have a jquery event handler for the form submit, it gets called anytime the submit button

[web2py] Re: HELP with bootstrap 3

2014-02-24 Thread Niphlod
I'm not confortable with having something cdn dependant. By default apps should be available also if no internet connectivity is assured. +1 with defaulting to local and a comment to enable the cdn version. On Monday, February 24, 2014 1:05:13 PM UTC+1, LightDot wrote: > > Note to those not readi

[web2py] Re: Change color of grid=SQLFORM.grid(db.abc, user_Signature=False)

2014-02-24 Thread Austin Taylor
Figured it out using Firebug and wanted to share my answer: To change the font colors inside the grid feature you have to create a CSS sheet (I called my tablebackground.css) and import it whenever I have a table. Then add this line: .odd.with_id {color: black;} There is also an even.with_id

Re: [web2py] Re: username and email login (auth)

2014-02-24 Thread Richard Vézina
Not sure this approach work with ldap_auth.py contrib... Richard On Mon, Feb 24, 2014 at 8:37 AM, Ruud Schroen wrote: > http://www.web2pyslices.com/slice/show/1642/login-with-username-and-email > > > On Friday, December 9, 2011 1:22:57 PM UTC+1, Francisco Costa wrote: >> >> lots of users on lo

[web2py] Re: How to pre filter a table I want to join.

2014-02-24 Thread Avi A
thanks, yes i just realised i don't need the joint for the filtering. On Monday, February 24, 2014 4:57:37 PM UTC+2, Anthony wrote: > > t_b = db.t_b.f_x ==3 >> > > Doesn't look like you do anything with the above. Why not: > > rows = db((db.t_a.created_by == auth.user.id) & (db.t_b.f_x == 3)).sele

[web2py] Re: How to pre filter a table I want to join.

2014-02-24 Thread Anthony
> > t_b = db.t_b.f_x ==3 > Doesn't look like you do anything with the above. Why not: rows = db((db.t_a.created_by == auth.user.id) & (db.t_b.f_x == 3)).select( join=db.t_b.on(db.t_a.f_test == db.t_b.id)) Note, you can also do a join via: rows = db((db.t_a.created_by == auth.user.id) & (db

[web2py] How to pre filter a table I want to join.

2014-02-24 Thread Avi A
Hi, I want to join t_a and t_b: rows = db(db.t_a.created_by == auth.user.id).select(join=db.t_b.on(db.t_a.f_y == db.t_b.id)) that works, But first I want to filter out t_b, for example: t_b to include only records where f_x == 3. what I tried did not work, it just "ignored" it, nothing was filt

Re: [web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Teddy Nyambe
Ok let me check will revert at least you have given me a head start! On 24 Feb 2014 16:27, "Anthony" wrote: > Well, it's just a string, so that's not the file. You have to figure out > how the JS library is sending the file to the server. > > On Monday, February 24, 2014 9:18:32 AM UTC-5, softwar

Re: [web2py] Re: Web2py Integration with Multiple Oauth Logins

2014-02-24 Thread Quint
Hi there, I changed that field as well. (and another field) about the w2p: Don't know whats going on there. But I tarred it myself using 7zip but apparently that doesn't work. I cannot package or upload using the admin interface on my GAE dev server, gives internal error. Could someone give m

Re: [web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Anthony
Well, it's just a string, so that's not the file. You have to figure out how the JS library is sending the file to the server. On Monday, February 24, 2014 9:18:32 AM UTC-5, software.ted wrote: > > What am supposed to see in dir and type? So that I can debug > On 24 Feb 2014 16:16, "Anthony" > wr

Re: [web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Teddy Nyambe
What am supposed to see in dir and type? So that I can debug On 24 Feb 2014 16:16, "Anthony" wrote: > You'll have the check the JS framework docs to see how/where it is posting > the file (e.g., maybe via a separate Ajax request). > > On Monday, February 24, 2014 8:50:51 AM UTC-5, software.ted wr

Re: [web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Anthony
You'll have the check the JS framework docs to see how/where it is posting the file (e.g., maybe via a separate Ajax request). On Monday, February 24, 2014 8:50:51 AM UTC-5, software.ted wrote: > > the output is: > > Dir: > ['__add__', '__class__', '__contains__', '__delattr__', '__doc__', > '_

Re: [web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Teddy Nyambe
the output is: Dir: ['__add__', '__class__', '__contains__', '__delattr__', '__doc__', '__eq__', '__format__', '__ge__', '__getattribute__', '__getitem__', '__getnewargs__', '__getslice__', '__gt__', '__hash__', '__init__', '__le__', '__len__', '__lt__', '__mod__', '__mul__', '__ne__', '__new__',

Re: [web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Anthony
The output of type(request.vars.photo) and dir(request.vars.photo). On Monday, February 24, 2014 8:33:44 AM UTC-5, software.ted wrote: > > I am using dhtmlx (www.dhtmlx.com) framework. The component am using is > dhtmlxform. I don't understand what you mean by class and attribute. > On 24 Feb 201

[web2py] Re: username and email login (auth)

2014-02-24 Thread Ruud Schroen
http://www.web2pyslices.com/slice/show/1642/login-with-username-and-email On Friday, December 9, 2011 1:22:57 PM UTC+1, Francisco Costa wrote: > > lots of users on login form submit their email instead of the > username.. > > it seems that auth.define_tables(username=True) forces username login >

Re: [web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Teddy Nyambe
I am using dhtmlx (www.dhtmlx.com) framework. The component am using is dhtmlxform. I don't understand what you mean by class and attribute. On 24 Feb 2014 14:45, "Anthony" wrote: > Can you provide information about the form processing tool? What is the > class and attributes of request.vars.phot

[web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-02-24 Thread Horst Horst
I'm getting a: type oid 114 not mapped to py type I'm wondering what's the best thing to do now? Currently I'm considering: - using TEXT instead. But my former JSON strings are then enclosed by "|" which leads to new errors - updating gp8000 (there seems to be a newer version, but the vers

[web2py] Re: Date display i18n internationalization?

2014-02-24 Thread Massimo Di Pierro
I get it now. You need: T.current_languages = [] Otherwise this is set to T.current_languages = ['en'] and it things the current language is english and therefore it does not need translation. On Monday, 24 February 2014 01:45:49 UTC-6, User wrote: > > In fact, if I put an entry in en-g

Re: [web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Anthony
Can you provide information about the form processing tool? What is the class and attributes of request.vars.photo? Anthony On Monday, February 24, 2014 7:36:17 AM UTC-5, software.ted wrote: > > Am using form processing tool. Which has a send method...what it actually > does is make post/get to

[web2py] Re: AJAX component reload problem using .html vs .load

2014-02-24 Thread Anthony
Is the below your exact code? I ask because in stats_del, you refer to a variable a0 that has not been defined (presumably it is request.args(0)). Also, your click handler refers to a ".del-div" class, but I don't see any elements with that class. Anyway, by default, if an incoming URL has no e

Re: [web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Teddy Nyambe
Am using form processing tool. Which has a send method...what it actually does is make post/get to a url in the form.send("{{=URL('c','a')}}") So what happens in the controller is that I can access the form variables as follows: def a(): file_name = request.vars.file_name The framework has c

[web2py] Re: REF: Issue with uploading files with web2py

2014-02-24 Thread Anthony
Ajax doesn't allow file uploads in forms. Are you using an Ajax file upload widget on the client side? Anthony On Monday, February 24, 2014 2:35:02 AM UTC-5, software.ted wrote: > > I am extremely stuck on how to manage uploaded file, I have been working > with web2py now for over a year and I

Re: [web2py] Re: email on logging in is case sensitive. Is this a good idea?

2014-02-24 Thread peter
> > Thanks for the information Marin. I am amazed that they were defined in > this way. You learn something new every day. > However as it says in your link "Hardly any email service or ISP does enforce case sensitive email addresses, returning messages whose recipient's email address was not

[web2py] Re: email on logging in is case sensitive. Is this a good idea?

2014-02-24 Thread Anthony
We can't change the default due to backward compatibility, but as Marin suggests, I suppose we could change it in the welcome app. Feel free to post an issue. Anthony On Monday, February 24, 2014 6:40:24 AM UTC-5, peter wrote: > > Okay I see that this is already attended to by the following set

[web2py] Re: HELP with bootstrap 3

2014-02-24 Thread LightDot
Note to those not reading this group from a web interface: I edited my post to fix copy paste typos in the code. This is the correct code again: I apologize for the mix up. Regards On Monday, February 24, 2014 12:28:19 PM UTC+1, LightDot wrote: > > How about putting Paolo's bootstrap3.py i

Re: [web2py] Re: email on logging in is case sensitive. Is this a good idea?

2014-02-24 Thread Marin Pranjić
It is sensitive by default, and by design: http://email.about.com/od/emailbehindthescenes/f/email_case_sens.htm :( but not by implementation, i don't think anyone is using case sensitive emails. I'd like to see the above line in welcome app, as I have it in all my apps. Marin On Mon, Feb 24,

[web2py] Re: email on logging in is case sensitive. Is this a good idea?

2014-02-24 Thread peter
Okay I see that this is already attended to by the following setting auth.settings.email_case_sensitive = False > > So I guess my comment would be - Wouldn't it be better if the default setting is False rather than True. Peter -- Resources: - http://web2py.com - http://web2py.com/book (Docume

[web2py] email on logging in is case sensitive. Is this a good idea?

2014-02-24 Thread peter
I run a site for a jazz club with ticket booking. Today I had an irate customer because they had previously registered and booked tickets. They then could not log in. The reason was that they had an upper case letter as the first letter of their email. It would seem better to me if the email us

[web2py] Re: HELP with bootstrap 3

2014-02-24 Thread LightDot
How about putting Paolo's bootstrap3.py into contrib an have welcome app import it from there? His module provides most of the bootstrap 3 support (forms, navigation, etc.). We could remove all this from core web2py. As for the welcome app static files, these are redundant (leftovers) now and s

[web2py] Re: Using web2py build-in serwer

2014-02-24 Thread Tobias Locsei
It's a bit hidden in the deployment recipes page but as far as I know the easiest way to make your site go live using the built in server is this: An easy way to setup a secure production environment on a server is to > first stop web2py and then remove all the parameters_*.py files from the >

[web2py] Re: HELP with bootstrap 3

2014-02-24 Thread Niphlod
in my POV instead of reducing all alterations of default widgets in javascript we should ship new widget sets alltogether. This was discussed long ago but nobody seemed to care we can't really start supporting every css framework out there unless we change the way widgets are generated. Go

[web2py] Re: What is proper requires= validator for foreign key?

2014-02-24 Thread Mirek Zvolský
Yes. Looks like a bug. My previous information wasn't completly correct, so I try better: It looks like there are 2 calls of represent= function in smartgrid. One call requires 2 parameters and second call 1 parameter. There is a possible solution: Function can be called with 2nd parameter optio