[web2py] How to generate URLs for each user similar to twitter?

2013-11-13 Thread Noah
I understand that Web2Py's urls work like this: 127.0.0.1:9292/ApplicationName/ControllerName/ControllerFunction I'm building an app that has user logins and I want to have a sort of profile page for each user that has an easy to remember URL. Similar to on twitter where to go to a user's page

[web2py] Error uploading 60 character named .pptx file

2013-11-13 Thread Rahul
Hi All, I get an error like below when I upload a file (.pptx [could be with other extensions too not tested]) in latest web2py - downloaded from trunk yesterday as below. I am on Win7 and IE9 .The file name looks insanely huge as highlighted below. I am able to upload pptx files prior to

[web2py] Re: Error uploading 60 character named .pptx file

2013-11-13 Thread Rahul
All, To correct the file has 89 character and not 60. That was a typo in my earlier post. a sixty character file works fine for upload. By character I mean name of the file - something like [Toney Catters expose Primary divisor from Fontect to Int Focount view and enyamic seaport.pptx]

[web2py] Re: Google charts plugin added

2013-11-13 Thread Sarbjit
Thanks Tim, I have a question: In your example, data is present in controller itself, how can I store the data effectively in database and then use that data for plotting graphs? Can you please provide an example of how this can be stored/retrieved from db? I searched the net and found people

[web2py] Re: Google charts plugin added

2013-11-13 Thread Tim Richardson
All you need to do is return data as an array. That's all the controller does. So you need to learn how to retrieve data using the DAL, and put it into an array. For example, you can get rows from a query, and iterate over the returned rows, building up the array. On Wednesday, November

Re: [web2py] Error uploading 60 character named .pptx file

2013-11-13 Thread Ricardo Pedroso
On Wed, Nov 13, 2013 at 10:00 AM, Rahul rahul.dhak...@gmail.com wrote: Hi All, I get an error like below when I upload a file (.pptx [could be with other extensions too not tested]) in latest web2py - downloaded from trunk yesterday as below. I am on Win7 and IE9 .The file name looks

[web2py] Web Framework Benchmarks

2013-11-13 Thread Mirko
http://www.techempower.com/benchmarks/ A lot of web frameworks but no web2py in this list... :( -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You

Re: [web2py] SQLFORM.grid to view and using groupby clause

2013-11-13 Thread Johann Spies
Why not use the 'group by' in the creation of the view and then you can just view the view using the grid with no need to group by again in the grid? Regards Johann On 13 November 2013 03:06, Meir mmaalbuquer...@hotmail.com wrote: Hello, I have the following problem: I have created a view

Re: [web2py] SQLFORM.grid to view and using groupby clause

2013-11-13 Thread Meir
Hello Johann, It's why I created this view with the concept of cube to BI. I carry a lot of information forlater summarize according to the parameters of the users, but this I do in web2py. I'm working with web2py like my small BI ... Then the assembly is accomplished in various ways as

Re: [web2py] Re: development server slow

2013-11-13 Thread Vinicius Assef
I changed to chrome and it's working ok. The problem persists with Firefox. I already tried some configs changes, but with no success. Fortunately, It's not a rocket problem. On Sat, Nov 9, 2013 at 11:53 PM, Vinicius Assef vinicius...@gmail.com wrote: On Sat, Nov 9, 2013 at 10:52 AM, Niphlod

Re: [web2py] How to generate URLs for each user similar to twitter?

2013-11-13 Thread Jonathan Lundell
On 13 Nov 2013, at 1:44 AM, Noah knudsenn...@gmail.com wrote: I understand that Web2Py's urls work like this: 127.0.0.1:9292/ApplicationName/ControllerName/ControllerFunction I'm building an app that has user logins and I want to have a sort of profile page for each user that has an easy

Re: [web2py] SQLFORM.grid to view and using groupby clause

2013-11-13 Thread Meir
Hello Johann, It's why I created this view with the concept of cube to BI. I carry a lot of information forlater summarize according to the parameters of the users, but this I do in web2py. I'm working with web2py like my small BI ... Then the assembly is accomplished in various ways as defined

[web2py] web2py url rewrting problem

2013-11-13 Thread Naitik patel
Hi Everyone, I have done project in web2py .I want to do url rewriting in web2py. means some url like */app/controller/function* like this type. but I want to change that url as per my requirement. what are the setting I have to do ? please help me for that? Regards, Naitik patel --

[web2py] Problems upgrading from 2.7.2 to 2.7.4 on Mac OS X 10.9 (Mavericks)

2013-11-13 Thread TC
I attempted using the auto upgrade package. The Welcome web site page came up but all the links give an Internal Error ticket number which I can't see without Admin and the admin interface gives another Internal Error. I completely removed the 2.7.2 version for a totally fresh install of

[web2py] orderby variable, uknown column

2013-11-13 Thread Noah Corradin
can someone explain to me why the following does not perform the way i thought it would This works: results=db(db.allstats.ptype==ptype).select(db.allstats.ALL, orderby=db.allstats.attack) But this does not: statA = request.vars.stat1 order='db.allstats.'+statA results =

[web2py] Using MEMDB with Scheduler

2013-11-13 Thread Joel Rathgaber
Hey all, I was attempting to set up a scheduler using a memcache backed MEMDB as the store, but I keep getting this error. type 'exceptions.TypeError' int() argument must be a string or a number, not 'MemcacheClientObj' Traceback: Traceback (most recent call last): File

[web2py] ValueError in local_import when trying to use a constant defined above in the file

2013-11-13 Thread Pascal Polleunus
Hi, In models/db.py, I do this settings = local_import(settings) In modules/settings.py, there's the following lines: FOO = abc BAR = {}def.format(FOO) When I execute this command on my server (WebFaction): web2py.py --no-banner -S app_name -M -N -R applications/app_name/cron/jobs.py

[web2py] Re: comma in html filename causing invalid request

2013-11-13 Thread John Felps
Why? RFC 1738 states Thus, only alphanumerics, the special characters $-_.+!*'(),, and reserved characters used for their reserved purposes may be used unencoded within a URL. A comma is a valid 'special character'. The system I'm working with uses special characters to delineate special

Re: [web2py] query from drop down menu

2013-11-13 Thread Noah Corradin
Thank you very much for the reply. i was able to figure it out but ill look into this method as well. On Tuesday, November 5, 2013 9:04:57 PM UTC-8, Kiran Subbaraman wrote: I would use the ajax+callback mechanism that exists in web2py to do this. Look at the simple wiki example, and

[web2py] Looking for advice for implementing a form to order multiple items

2013-11-13 Thread Vincent Borghi
Hello, I'm thinking about implementing a form for ordering parts, and before starting this work I'd like to have some advice. Here is the base functionality wanted: - The form would include multiple similar lines made of 3 fields, to hold a part_reference, a part_description and a quantity.

[web2py] Ajax function

2013-11-13 Thread Luca Dalla Palma
Hello, this is my *view* div id=paginatore/div on the *controller *I build a function containing the folowing code: pippone='a onclick=ajax('+'\''+URL('seleziona', args=('None',3))+'\''+', [], '+'\''+eval+'\''+') href=#ciao/a' stringa.append(jQuery('#paginatore').html('%s'); % pippone()) print

[web2py] Re: parent child tree query logic

2013-11-13 Thread 黄祥
a, sorry, my fault, didn't notice that the id field is none. thanks for show me my own mistake. is there a way to arrange the result for that? e.g. expected result : root - child 1 - child 2 thanks and best regards, stifan p.s. i've change the code into : *models/db_wizard.py* # coding: utf8

Re: [web2py] Re: comma in html filename causing invalid request

2013-11-13 Thread Richard Vézina
I thougth you were having trouble with filename... I just remember the old not written rules... You do what you want... On Tue, Nov 12, 2013 at 9:34 AM, John Felps john.screwt...@gmail.comwrote: Why? RFC 1738 states Thus, only alphanumerics, the special characters $-_.+!*'(),, and reserved

[web2py] Re: Looking for advice for implementing a form to order multiple items

2013-11-13 Thread 黄祥
i think you can achieve it using session for store the items after that checkout and then submit it (like online shopping cart method) ref: https://github.com/mdipierro/web2py-appliances/tree/master/PosOnlineStore or if you want grid solution (create the header first and then you can add, edit,

[web2py] Re: rocket, windows server, bad file descriptor error due to gluon debug message

2013-11-13 Thread Rob Paire
For what it's worth, I worked through a series of apparently random connection errors when I was using MSSQL database. Searching the net it appeared to be a problem with MSSQL and not web2py DAL. I decided to change the database to Postgres. There were some challenges getting Postgres

[web2py] Re: Problems with mail.send()

2013-11-13 Thread Kariloy Markief
Well, sorry to bring this back from the grave but after some hours debugging I've come to realize that I'm having the same problem has Bernardo. So I was wondering, has by any chance 'sasl_method=PLAIN' have been enabled as a possibility since then? Because, if so it isn't being obvious to me.

Re: [web2py] SQLFORM.grid to view and using groupby clause

2013-11-13 Thread Niphlod
you can't have a column in the grid with a groupby that is not the groupby itself or an aggregate of another column, just like you can't in SQL. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Database insert of time field in web2py not working?

2013-11-13 Thread Niphlod
db.table.field.requires.append(what_you_need) On Wednesday, November 13, 2013 6:43:38 AM UTC+1, User wrote: So since a time field automatically has an IS_TIME validator how would you specify additional validators after the db.define_table statement? On Tuesday, November 12, 2013 3:51:12 AM

[web2py] Re: ValueError in local_import when trying to use a constant defined above in the file

2013-11-13 Thread Niphlod
you have 2.7 while webfaction sits on 2.6 ? On Wednesday, November 13, 2013 8:29:01 AM UTC+1, Pascal Polleunus wrote: Hi, In models/db.py, I do this settings = local_import(settings) In modules/settings.py, there's the following lines: FOO = abc BAR = {}def.format(FOO) When I execute

[web2py] Re: Using MEMDB with Scheduler

2013-11-13 Thread Niphlod
nice shot, but scheduler isn't supported in MEMDB. On Wednesday, November 13, 2013 6:25:40 AM UTC+1, Joel Rathgaber wrote: Hey all, I was attempting to set up a scheduler using a memcache backed MEMDB as the store, but I keep getting this error. type 'exceptions.TypeError' int() argument

[web2py] Re: orderby variable, uknown column

2013-11-13 Thread Niphlod
because db.table.field is NOT a string. statA = request.vars.stat1 order='db.allstats.'+statA should be statA = request.vars.stat1 order=db.allstats[statA] On Wednesday, November 13, 2013 3:32:20 AM UTC+1, Noah Corradin wrote: can someone explain to me why the following does not perform the

[web2py] Re: Problems upgrading from 2.7.2 to 2.7.4 on Mac OS X 10.9 (Mavericks)

2013-11-13 Thread Massimo Di Pierro
Does it unzip? I am trying it with OSX 10.7.3 and it works fine. On Tuesday, 12 November 2013 20:24:30 UTC-6, TC wrote: I attempted using the auto upgrade package. The Welcome web site page came up but all the links give an Internal Error ticket number which I can't see without Admin and

[web2py] Re: web2py url rewrting problem

2013-11-13 Thread Massimo Di Pierro
http://web2py.com/books/default/chapter/29/04/the-core?search=routes.py#URL-rewrite On Wednesday, 13 November 2013 01:13:46 UTC-6, Naitik patel wrote: Hi Everyone, I have done project in web2py .I want to do url rewriting in web2py. means some url like */app/controller/function* like

[web2py] Re: Scheduler TIMEOUT

2013-11-13 Thread Niphlod
On Tuesday, November 12, 2013 11:23:25 PM UTC+1, LightOfMooN wrote: I don't want worker without timeout. I just want scheduler task not to be stopped because of timeout from one of thousands records. Why scheduler doesn't execute tasks with status=='TIMEOUT'? because any task that times

[web2py] security concerns

2013-11-13 Thread sasogeek
A friend wants me to build a loaning system applocation for him. This raises a few flags considering that it deals with money and people's personal information. But I'm particularly concerned about the security of web2py... I want to be able to assure him that the system will be secure. I have

Re: [web2py] Re: comma in html filename causing invalid request

2013-11-13 Thread John Felps
I substituted periods for commas and that seems to work. I'll have to find one of these unwritten rules manuals, although that sounds like a contradiction in terms. On Wednesday, November 13, 2013 8:25:37 AM UTC-7, Richard wrote: I thougth you were having trouble with filename... I just

[web2py] Google App Engine NoSql geopoint field supported by DAL?

2013-11-13 Thread i . misc
Hello everyone, i just started my web2py carrier, and so far I am intrigued. Anyway I have the following question, as i could not really find it the docs. Does the DAL support the geopoint field of the google Big Table data store, and thus location based queries as described by in app engine

Re: [web2py] security concerns

2013-11-13 Thread Richard Vézina
Do you know Rentila?? http://www.rentila.com/ I think it RoR, it is very worth to try before trying to implement something... What you want to do is not as easy as it seems to be, as you explained there is many things to consider. For a local deployment behind firewall you can trust web2py to

[web2py] Re: security concerns

2013-11-13 Thread Derek
Well, if you don't know you are secure, then you should have a security audit. If you don't know anyone who does security audits, can't do it yourself, and can't pay anyone to do it, then you will just have to settle for being insecure. If security is paramount then you'd likely want to get

[web2py] Re: Web Framework Benchmarks

2013-11-13 Thread Derek
You can submit a pull request, so go right ahead and do it. On Wednesday, November 13, 2013 5:31:30 AM UTC-7, Mirko wrote: http://www.techempower.com/benchmarks/ A lot of web frameworks but no web2py in this list... :( -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: mssql connection

2013-11-13 Thread Derek
Possible... Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified. This usually happens in one of the following scenarios: - you referenced your connection incorrectly (e.g. spelled the DSN

[web2py] Re: mssql connection

2013-11-13 Thread Niphlod
@derek: except that he's using unixodbc ^_^ Anyway, googling [unixODBC][Driver Manager]Data source name not found leads you to several hundreds blogposts on the matter. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: Ajax function

2013-11-13 Thread Derek
You're using eval, but are you returning executable javascript from your function 'paginatore' ? On Tuesday, November 12, 2013 7:17:52 AM UTC-7, Luca Dalla Palma wrote: Hello, this is my *view* div id=paginatore/div on the *controller *I build a function containing the folowing code:

[web2py] Re: mssql connection

2013-11-13 Thread Derek
Regardless, it's the same message just a different driver manager. I'd say one of the settings being passed just won't work for mssql express, i'd guess 'pooling'. On Wednesday, November 13, 2013 3:25:38 PM UTC-7, Niphlod wrote: @derek: except that he's using unixodbc ^_^ Anyway,

[web2py] Re: How to make registrations invitation-only with Janrain login/registrations

2013-11-13 Thread Derek
Sure, there is a way to do that. Do you want to have users send out invite codes to their friends, or is this a beta test type thing where once codes are used up they can't use again, or is this for tracking sources? On Friday, November 8, 2013 5:57:08 AM UTC-7, Dragan Matic wrote: When using

Re: [web2py] Re: Best practice when making downloads more private.

2013-11-13 Thread Derek
I think you could modify rocket to return a 404 for a request with an etag or if-not-modified request in that particular folder, that should probably do it, to prevent downloads from the same device. for downloads from different devices, the approach like niphlod said would work, set a

[web2py] serious memdb issue

2013-11-13 Thread Massimo Di Pierro
A serious issue has been reported on web2y-developers. The issue has to do with the memdb module. You are using it if you use session in Memcache on Google App Engine. The bug affects systems on high load and creates duplicates sessions (occasionally two users get new session with the same id

[web2py] count of reference usage

2013-11-13 Thread webpypy
Hi, I have three tables ( emp , dept ) and (many to many). How to get (for each dept), how many times each dept is referenced? deptnumber of occurrences -- . . . Regards, Ashraf -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: orderby variable, uknown column

2013-11-13 Thread Noah Corradin
Thank you so much! was this covered in some documentation i may have missed? On Wednesday, November 13, 2013 8:51:06 AM UTC-8, Niphlod wrote: because db.table.field is NOT a string. statA = request.vars.stat1 order='db.allstats.'+statA should be statA = request.vars.stat1

[web2py] Re: Problems with mail.send()

2013-11-13 Thread Massimo Di Pierro
No but open a ticket. Can you help make it happen? On Wednesday, 13 November 2013 10:45:36 UTC-6, Kariloy Markief wrote: Well, sorry to bring this back from the grave but after some hours debugging I've come to realize that I'm having the same problem has Bernardo. So I was wondering, has

[web2py] Re: count of reference usage

2013-11-13 Thread Massimo Di Pierro
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=db.person.id.count%28%29 On Wednesday, 13 November 2013 19:21:31 UTC-6, webpypy wrote: Hi, I have three tables ( emp , dept ) and (many to many). How to get (for each dept), how many times each dept is

Re: [web2py] SQLFORM update upload field - override 'file' anchor text

2013-11-13 Thread Jim Steil
Any takers? Won't bother again if no response to this one... -Jim On Tue, Nov 12, 2013 at 1:36 PM, Jim S j...@qlf.com wrote: I have a SQLFORM.grid on my page. I have an upload field in the referenced table/query. In edit mode on the SQLFORM.grid the upload field is displayed as a link

Re: [web2py] Error uploading 60 character named .pptx file

2013-11-13 Thread Rahul
Hi Ricardo, Thanks for the response, but I don't understand why it should be a windows limit. I have many files with much larger names in windows, never had such a problem. Besides this only occurs when we are uploading it in web2py. Could SQLite database be a constraint ? I am using

[web2py] Re: count of reference usage

2013-11-13 Thread webpypy
Thank you , Massimo. Would please write down the statement for calculating the count of Things for every person? instead of for row in persons_and_things.select(): print row.person.name, row.thing.name Alex Boat Alex Chair Bob Shoes Curt Boat I would like to get Alex 2 Bob 1