Re: [web2py] Re: How do I define a table that references itself

2013-02-19 Thread Niphlod
you'll better be off with an autocomplete: just creating the markup for a thousand options inside a select takes time: transferring it even more. http://web2py.com/books/default/chapter/29/07#Autocomplete-widget On Tuesday, February 19, 2013 5:47:46 AM UTC+1, Paul Whipp wrote: Thanks, This

[web2py] Re: Block oversized uploads serverside

2013-02-19 Thread Andriy
Right now I`m trying to host on my own windows server. On Rocket and CherryPy I have problems with some pages not loading static images and hanging in Opera (other users report problems with Chrome, but at the same time I have no problems with IE or Firefox). I can not figure out whats the

Re: [web2py] Re: type 'exceptions.KeyError' 'appadmin' on trying ot load data admin

2013-02-19 Thread Andrew Buchan
My setup is Windows + Microsoft SQL and I was asking if anyone had any luck with Windows + MySQL. ... Of course something MUST be different, I'm not that superstitious :-) It's just not anything in the models or the databases directories as I sync them, and both apps sit in the same web2py

[web2py] Re: after login redirect

2013-02-19 Thread nurul ain
ahh thank you for this post !! i found my solution also. never knew def can be put inside model. i did like this for the redirect url because auth.settings.login_next=URL('addarticle') wont work. dont know why. def redirect_login(form): if

[web2py] question with SQLFORM.grid

2013-02-19 Thread animnook
I am trying to create a new link with SQLFORM.grid to update the database from FALSE to TRUE. below is what I did. How do I link it to update the db? I am not able to find example anywhere. appove_links = [lambda row: A('Approve',callback=URL('approve'), args=('approve',row.id))]

Re: [web2py] Re: Block oversized uploads serverside

2013-02-19 Thread Ricardo Pedroso
On Tue, Feb 19, 2013 at 9:02 AM, Andriy unhappyhardc...@gmail.com wrote: Right now I`m trying to host on my own windows server. On Rocket and CherryPy I have problems with some pages not loading static images and hanging in Opera (other users report problems with Chrome, but at the same time I

Re: [web2py] Re: type 'exceptions.KeyError' 'appadmin' on trying ot load data admin

2013-02-19 Thread Niphlod
Nope, I use datetimes all over the place ^_^ On Tuesday, February 19, 2013 10:48:15 AM UTC+1, Andrew Buchan wrote: My setup is Windows + Microsoft SQL and I was asking if anyone had any luck with Windows + MySQL. ... Of course something MUST be different, I'm not that superstitious :-) It's

[web2py] Re: question with SQLFORM.grid

2013-02-19 Thread Niphlod
that way you need to have a approve function that takes two args: 'approve' and the id of the approved row. On Tuesday, February 19, 2013 2:44:39 AM UTC+1, animnook wrote: I am trying to create a new link with SQLFORM.grid to update the database from FALSE to TRUE. below is what I did. How

Re: [web2py] Re: How to get request.args from an index() function?

2013-02-19 Thread Alec Taylor
Didn't know that. Okay, modified my routes.py: routers = dict( BASE = dict( default_application = 'studentstartups', applications = ['admin', 'fruit'], default_controller = 'default', controllers = 'DEFAULT', default_function = 'index', ) ) Now with this

[web2py] Re: Default SQLFORM.grid / auth restrictions?

2013-02-19 Thread Matt House
Thanks Jim. Although off topic, appreciate the input on the table. Each portfolio might have multiple rows (i.e., portfolio value at Date 1, portfolio value at Date 2, etc.), so I'm using the portfolio_id field to identify all of the rows associated with a given portfolio. There may be more

[web2py] Re: Default SQLFORM.grid / auth restrictions?

2013-02-19 Thread Niphlod
signature in auth is meant as auth.signature, aka archive, aka save every update the auth_ * tables . http://web2py.com/books/default/chapter/29/09?search=auth.signature the _signature you see appended to the url is coming from the url generation with the user_signature=True parameter.

Re: [web2py] Re: Block oversized uploads serverside

2013-02-19 Thread Andriy
Yes there are 10+ images, about 3-5 js and css files referenced. I`ve tried limit server connections in Opera settings to 1-2 max - didn`t help. I tried numthreads=500, max=700 for CherryPy - didn`t help. Don`t know how to set HTTP header Connection: close so far, may be in web2py controller

Re: [web2py] Re: type 'exceptions.KeyError' 'appadmin' on trying ot load data admin

2013-02-19 Thread Andrew Buchan
Haha! Fair enough... On Tue, Feb 19, 2013 at 11:02 AM, Niphlod niph...@gmail.com wrote: Nope, I use datetimes all over the place ^_^ On Tuesday, February 19, 2013 10:48:15 AM UTC+1, Andrew Buchan wrote: My setup is Windows + Microsoft SQL and I was asking if anyone had any luck with

[web2py] How many apps do you have running with web2py?

2013-02-19 Thread António Ramos
Hello, i´m curious if any is using web2py for more than 1 app. ie in an enterprise context. I have 3 apps running with rocket inside my company and have more to come to the same web2py server. These 3 apps dont send emails. As far as enterprise framework i see a litle problem to solve. Emails

[web2py] Re: How many apps do you have running with web2py?

2013-02-19 Thread Niphlod
depends on how many mails are needed. I had 14 apps deployed in a Windows intranet, however emails weren't necessary. PS: queue emails is a quite common pattern that can be solved by web2py's scheduler. I'm planning to extend w2p_scheduler_tests to include more common patterns in a few weeks.

[web2py] Unable to import function from the appname\modules folder to my controllers

2013-02-19 Thread Alec Taylor
How do I import variables, functions and classes from my appname\modules folder? Following: http://rochacbruno.com.br/more-web2py-custom-validators/ I have a 'web2py\applications\appname\modules\validator.py' file, for simplicity I added this function to it: def hi(): print hello Now in

Re: [web2py] Unable to import function from the appname\modules folder to my controllers

2013-02-19 Thread Johann Spies
On 19 February 2013 15:30, Alec Taylor alec.tayl...@gmail.com wrote: How do I import variables, functions and classes from my appname\modules folder? from applications.appname.modules.modulefile import * Regards Johann -- Because experiencing your loyal love is better than life itself, my

Re: [web2py] Unable to import function from the appname\modules folder to my controllers

2013-02-19 Thread Alec Taylor
Perfect, thanks. On Wed, Feb 20, 2013 at 12:48 AM, Johann Spies johann.sp...@gmail.com wrote: On 19 February 2013 15:30, Alec Taylor alec.tayl...@gmail.com wrote: How do I import variables, functions and classes from my appname\modules folder? from

Re: [web2py] Unable to import function from the appname\modules folder to my controllers

2013-02-19 Thread Niphlod
if you have that file saved as modules\validator.py you mispelled the imports from validator*s* import hi vs from validator import hi The latter is perfectly fine. PS: if you use the shortcut instead of the longer applications.appname.modules.filename pattern be careful on which name you

Re: [web2py] Re: How to get request.args from an index() function?

2013-02-19 Thread Alec Taylor
Bug reported: http://code.google.com/p/web2py/issues/detail?id=1346 On Tue, Feb 19, 2013 at 10:34 PM, Alec Taylor alec.tayl...@gmail.com wrote: Didn't know that. Okay, modified my routes.py: routers = dict( BASE = dict( default_application = 'studentstartups', applications =

Re: [web2py] Validator: {Validator1 OR validator2} - Can I get that requires on a Field?

2013-02-19 Thread Alec Taylor
Thanks Bruno, works like a charm. Only caveat is that the error_message is always grabbed from the first validator… On Sat, Feb 16, 2013 at 6:21 AM, Bruno Rocha rochacbr...@gmail.com wrote: Cool! but it does not allow the transformation. class CUSTOM(object): you can use a function

[web2py] Re: auth.settings.login_next has no functionality?

2013-02-19 Thread Anthony
If you are using auth.navbar(), by default it adds a _next variable to the auth URLs that redirects back to the page where the navbar link was clicked. The _next variable overrides the auth.settings.[action]_next settings, which are only meant as fallbacks in case there is no _next referrer.

Re: [web2py] Re: web2py contains pyfpdf version 1.54b, but there is version 1.7 with utf-8 support

2013-02-19 Thread Mariano Reingart
On Tue, Feb 19, 2013 at 7:10 AM, Martin Weissenboeck mweis...@gmail.com wrote: Hi Mariano, thank you very much for your detailed answer. I know, you are not the creator of the library, but I think you do a very important job. Maybe my question could help others and me to use this program.

[web2py] Re: Setting up memcache on GAE - a basic question

2013-02-19 Thread Andy W
Thanks for the input. Niphlod: I tried cacheable=True but seemed to make no difference on GAE SDK Christian: adding .as_dict() rather than the suggested .to_dict on the select statement does seem to work. The caching code then becomes: students = cache.ram('students',

Re: [web2py] Re: auth.settings.login_next has no functionality?

2013-02-19 Thread Alec Taylor
I'm not using auth.navbar(). On Wed, Feb 20, 2013 at 1:46 AM, Anthony abasta...@gmail.com wrote: If you are using auth.navbar(), by default it adds a _next variable to the auth URLs that redirects back to the page where the navbar link was clicked. The _next variable overrides the

[web2py] PDF as an background when using pyfPdf

2013-02-19 Thread Kenneth
Hello, does anyone know if it is possible to use an PDF as an background when creating PDFs with pyfpdf? Kenneth -- --- 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

Re: [web2py] REF: Documentation Correction Proposal

2013-02-19 Thread Richard Vézina
Hello Teddy, Report this with book typo in the object, these kind of issue with the book are usally report like until now so the person reponsible to edit the book will flag them more easily. Richard On Tue, Feb 19, 2013 at 8:57 AM, Teddy Nyambe software@gmail.comwrote: Hi Massimo,

[web2py] web2py and google app engine

2013-02-19 Thread jjg0
I am new to both web2py and google app engine. Is there a good guide for running web2py on gae using python 2.7 from scratch? I've tried looking through some tutorials online but they all seem to be out of date and I can't get this working on either python 2.7 or 2.5. I've run into problems

[web2py] Re: web2py and google app engine

2013-02-19 Thread jjg0
There doesn't seem to be any mention of what to do for python 2.7 in the app.yaml file. Their example looks different than the app.yaml file that comes with the latest web2py, I don't see anything on using gaehandler.wsgiapp. Should I only be using python 2.5 and gaehandler.py? Still not

Re: [web2py] Re: Cannot get a div to update, once form inputs have been successfully processed and Ajax used.

2013-02-19 Thread Ann Gledson
Thanks. Sorry about the delay in response. In answer to your question, the .load function does not get called, that is, the body of the function(response) does not appear to get called. I tried just the line: $('#scan_info_previous').hide; and the div element with that ID does not become hidden.

Re: [web2py] Re: Sort order for related table grids in SQLFORM.smartgrid

2013-02-19 Thread wwwgong
Smartgrid is nice, but not well documented, how can we improve this? On Thursday, December 22, 2011 1:23:04 PM UTC-5, Adi wrote: *+1* -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving

Re: [web2py] Re: Sort order for related table grids in SQLFORM.smartgrid

2013-02-19 Thread Niphlod
for example, telling what is not documented ? https://github.com/web2py/web2py/blob/master/gluon/sqlhtml.py#L1721 43 parameters. http://web2py.com/books/default/chapter/29/07#SQLFORM.grid-and-SQLFORM.smartgrid are all documented in there. On Tuesday, February 19, 2013 5:59:13 PM UTC+1, wwwgong

Re: [web2py] Re: Cannot get a div to update, once form inputs have been successfully processed and Ajax used.

2013-02-19 Thread Niphlod
if the .load isn't fired, then it's possible that the first one $.post($(this).attr('action'), $(this).serialize() .. , isn't fired either ? did you debug it adding a console.log() or an alert() ? Can you confirm that this $.post is fired and returns something ? On Tuesday, February 19,

Re: [web2py] Re: auth.settings.login_next has no functionality?

2013-02-19 Thread Annet
Is 'profile' a custom profile function? otherwise, what about: auth.settings.login_next=URL('user',args='profile') Annet -- --- 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,

Re: [web2py] PDF as an background when using pyfPdf

2013-02-19 Thread Mariano Reingart
No, currently it's not possible to use or extend a previous PDF using pyfpdf. You could use an image as background, but to use other PDF, you should need to parse it using pypdf2 or some other third party tools. Best regards, Mariano Reingart http://www.sistemasagiles.com.ar

Re: [web2py] Re: auth.settings.login_next has no functionality?

2013-02-19 Thread Alec Taylor
It's a custom profile function. I have a controllers\profile.py file. On Wed, Feb 20, 2013 at 4:12 AM, Annet anneve...@googlemail.com wrote: Is 'profile' a custom profile function? otherwise, what about: auth.settings.login_next=URL('user',args='profile') Annet -- --- You received

Re: [web2py] Re: How is MongoDB for web2py DAL?

2013-02-19 Thread Phyo Arkar
Thanks alot. I will be already experimentintg... if my laptops aren't stolen during valentine ... On Feb 5, 2013 8:42 PM, samuel bonilla pythonn...@gmail.com wrote: look: mongodb on web2py http://www.web2pyslices.com/slice/show/1580/save-the-earth-from-a-total-data-mess-with-mongodbadapter

Re: [web2py] Re: auth.settings.login_next has no functionality?

2013-02-19 Thread Annet
I have a controller cms.py and in db.py auth.settings.login_next=URL('cms','on_login') the on_login function takes care of settings and redirects to cms/index. This works flawlessly in web2py 2.2.1. Kind regards, Annet -- --- You received this message because you are subscribed to the

Re: [web2py] REF: Documentation Correction Proposal

2013-02-19 Thread Teddy Nyambe
Ok will do! On Feb 19, 2013 6:24 PM, Richard Vézina ml.richard.vez...@gmail.com wrote: Hello Teddy, Report this with book typo in the object, these kind of issue with the book are usally report like until now so the person reponsible to edit the book will flag them more easily. Richard

Re: [web2py] Re: auth.settings.login_next has no functionality?

2013-02-19 Thread Anthony
OK, it would help then if you (a) show the links as well as the code that produces them, and (b) describe what is happening instead of the expected behavior. Note, if your profile function is in a separate profile.py controller, then URL('profile') may not generate the URL you need -- if you

[web2py] @service json and db.executesql

2013-02-19 Thread Christian Espinoza
Hi guys, for this json service I'm using simplejson implicitly because the result of db.executesql isn't serialized automatically by decorator, is this the normal behavior for db.executesql or something I'm missed here? @auth.requires_login() @service.json def test_trackers(): dthandler =

[web2py] Re: Improve this code about ( sql query, dict creation for json service)

2013-02-19 Thread Christian Espinoza
I'm using this query with executesql(), Thanks to all for the support!! El sábado, 16 de febrero de 2013 15:23:00 UTC-3, Niphlod escribió: neither let's leave alone event('name') that isn't in the table. that query returns the event id for each device_id in the events table, and attaches

Re: [web2py] @service json and db.executesql

2013-02-19 Thread Richard Vézina
db.executesql return a sql table object with no represent and other web2py fancy stuff (row_delete, id, etc.). I think you will have to translate the Niphold SQL into web2py query, like db(...).select(...) Richard On Tue, Feb 19, 2013 at 2:21 PM, Christian Espinoza chespin...@gmail.comwrote:

[web2py] Is there a fast way to grab all ids from DAL Rows?

2013-02-19 Thread bracquet
If I select all items in a database: rows = db(db.table).select() I can get the ids by doing something like: ids = [] for row in rows: ids.append(row.id) However, is there a better way to get the ids straight from the rows variable (without executing raw sql)? I feel like I'm iterating

Re: [web2py] Re: web2py contains pyfpdf version 1.54b, but there is version 1.7 with utf-8 support

2013-02-19 Thread Martin Weissenboeck
The result: the “ά” is not shown That is interesting, because the accent is important in the Greek language and it could change the meaning of a word..“ά” is replaced by a black square. Maybe the reportlab font does not know the Unicode character U+03AC? Sorry, I cannot help you with

Re: [web2py] Is there a fast way to grab all ids from DAL Rows?

2013-02-19 Thread Richard Vézina
You can try this and see what you can do with that : db(db.table).select(db.table.id).as_list() By selecting db.table.id you will prevent the overhead of web2py compute=, represent=, etc. Richard On Tue, Feb 19, 2013 at 4:26 PM, bracq...@gmail.com wrote: If I select all items in a database:

[web2py] Re: Is there a fast way to grab all ids from DAL Rows?

2013-02-19 Thread Niphlod
a .select() returns a Rows() object. iterating through that set of data to fetch what you need - if you need it - it's the only way. If you need only the id, you'd be better off doing rows = db(db.table).select(db.table.id, cacheable=True) and then iterating the reduced set because: - only one

Re: [web2py] Is there a fast way to grab all ids from DAL Rows?

2013-02-19 Thread Richard Vézina
May be better use .as_ditc() but not sure the id get mapped into dict key you have to check, but if the key id is the row id you can iterate directly over dict like this : for id in dict: ... On Tue, Feb 19, 2013 at 4:51 PM, Richard Vézina ml.richard.vez...@gmail.com wrote: You can try this

Re: [web2py] @service json and db.executesql

2013-02-19 Thread Niphlod
there's a way def executesql(self, query, placeholders=None, as_dict=False, fields=None, colnames=None) taken straight from docstring *The fields argument is a list of DAL Field objects that match the fields returned from the DB. The Field objects should be part of one or

Re: [web2py] Is there a fast way to grab all ids from DAL Rows?

2013-02-19 Thread Niphlod
as_dict() iterates on the Rows object (it's a method on the fetched resultset). It's not speedier by any measure than a loop. On Tuesday, February 19, 2013 10:55:07 PM UTC+1, Richard wrote: May be better use .as_ditc() but not sure the id get mapped into dict key you have to check, but if

Re: [web2py] Is there a fast way to grab all ids from DAL Rows?

2013-02-19 Thread Niphlod
@brac until now I interpreted your question in a performance-wise way. If you referred to the shortest way and not care about performance, it's ids = db().select(db.table.id).as_dict().keys() On Tuesday, February 19, 2013 11:02:23 PM UTC+1, Niphlod wrote: as_dict() iterates on the Rows

Re: [web2py] Re: web2py contains pyfpdf version 1.54b, but there is version 1.7 with utf-8 support

2013-02-19 Thread Mariano Reingart
On Tue, Feb 19, 2013 at 6:29 PM, Martin Weissenboeck mweis...@gmail.com wrote: The result: the “ά” is not shown That is interesting, because the accent is important in the Greek language and it could change the meaning of a word..“ά” is replaced by a black square. Maybe the reportlab

[web2py] RPC Versioning Scheme

2013-02-19 Thread Mike D
Hi, I'm using web2py to serve RPC methods to a desktop client that a user can download. I'd like to know if anyone has any thoughts on a good way to version my API so that I can keep the older versions available for users that haven't updated their clients. As a starting point, I'm thinking

[web2py] Re: RPC Versioning Scheme

2013-02-19 Thread Derek
Seems like a lot of hard work. Is your interface in production already but you are going to make changes to it? First, i'd suggest you treat your API as released and don't make changes to the parameters. If you do add parameters, have defaults set for the new parameters. If you need to change

[web2py] Re: very important! we need to help Python

2013-02-19 Thread samuel bonilla
try destroy the free software is impossible. live python ¡¡ El jueves, 14 de febrero de 2013 17:00:00 UTC-5, Massimo Di Pierro escribió: TLTR: a private company not affiliated with python.org is trying to claim copyright of the name Python in Europe for all software.

[web2py] Re: RPC Versioning Scheme

2013-02-19 Thread Mike D
Thanks Derek. This is exactly the kind of response I was looking for. I didn't know how it was in the real world but I figured I wasn't the first person to think abou the problem. This seems like a reasonable solution. Thanks again. On Tuesday, February 19, 2013 2:57:37 PM UTC-8, Derek wrote:

[web2py] callback cannot redirect

2013-02-19 Thread 黄祥
hi, i just create a callback function after it done, it will redirect to another page, it seems, that the redirect function is not working. for example : def order_callback(): id=int(request.vars.id) if request.vars.action=='add': session.order[id]=session.order.get(id, 0)+1

[web2py] Re: unable to remove jqmobile

2013-02-19 Thread greaneym
I figured out how to get my apps back to a state before the jqmobile plugin was added and I learned a lot in this process. I am making a suggestion that some more documentation or information be added for the jqmobile plugin. I thought that adding the plugin would get both the mobile view

[web2py] ajax update session data

2013-02-19 Thread 黄祥
hi, i'm trying to update session data variable using java and not working. for example : *#controller* def order_update(): id=int(request.vars.id) qty=int(request.vars.qty) #session.order.get(id, 0)=qty session.order[id]=qty return locals() *#view* table width=100% {{for id,

[web2py] Re: SmartGrid and New button 1 to many

2013-02-19 Thread Dan Kozlowski
Jim, Sorry to bother you again but still can't get this working. I need to join my 2 tables by a date and not the DB ID key. Not sure if this can be done since it looks like Web2Py looks to join by DB ID only. In SQL this would be a simple join by date after building a date index on the date

[web2py] Re: callback cannot redirect

2013-02-19 Thread Anthony
What do you mean it isn't working? What do you expect, and what is happening instead? How are you calling order_callback()? Is this an Ajax request? Can we see the code? On Tuesday, February 19, 2013 8:42:43 PM UTC-5, 黄祥 wrote: hi, i just create a callback function after it done, it will

Re: [web2py] Re: auth.settings.login_next has no functionality?

2013-02-19 Thread Alec Taylor
Anthony, I did try with URL('profile', 'index') but got some looping error which Firefox picked up… #controllers/profile.py def index(): return dict() On Wed, Feb 20, 2013 at 5:33 AM, Anthony abasta...@gmail.com wrote: OK, it would help then if you (a) show the links as well as the code

[web2py] Re: ajax update session data

2013-02-19 Thread Anthony
Please read the ajax() function documentation for proper usage: http://web2py.com/books/default/chapter/29/11#The-ajax-function. The ajax() function takes a URL as the first argument. Instead, you are supplying the following string: *'order_update, vars=dict(id={{=p.id}}, qty={{=qty}})'*. I

Re: [web2py] Re: SmartGrid and New button 1 to many

2013-02-19 Thread Jim Steil
Yes, that is true,you'd have to join by the primary ID field of the other table. But, looking at your table, couldn't you use the ID instead of the date? I guess I'm a bit anal about the way I like tables, I always use the ID fields. On Tue, Feb 19, 2013 at 9:30 PM, Dan Kozlowski

[web2py] Re: callback cannot redirect

2013-02-19 Thread 黄祥
hi anthony, *controller : default.py* def order_callback(): id=int(request.vars.id) if request.vars.action=='add': session.order[id]=session.order.get(id, 0)+1 if request.vars.action=='subtract': session.order[id]=max(0,session.order.get(id, 0)-1) if

[web2py] Re: ajax update session data

2013-02-19 Thread 黄祥
thank you so much for your hints anthony. actually i'm still confuse about session.order.get(id, 0), on book only have connect, secure and forget, so that i'm so lack of information what is session can do. do you have any information about that? many thanks before -- --- You received this

[web2py] Error mysql

2013-02-19 Thread Hassan Alnatour
Dear ALL , Am trying to connect to a mysql database but am getting this error , how can i solve this problem : connection string : *URI = 'mysql://root:@localhost/hasaad'* TICKET ID 127.0.0.1.2013-02-20.10-10-32.b8a942ff-fb3a-4ba0-b118-fd1fdac873bf *class

[web2py] Drop down on fancyBOx

2013-02-19 Thread waqasiqbal . knysys
hello everyOne!! i have a page with having name facility ,when i filled out all mandotry fields it takes me to next page where i ve check boxes to select groups ,after selecting groups it redirects me to the previous URL of facility, now all the information is filled and at this page now i have

[web2py] Re: login by ajax

2013-02-19 Thread yashar
i think login_bare needs to write again, in login() function, it first checks the login_methods and then local database and also create_or_get_user and update session.auth, but in login_bare it just check the database if user is there add it to session but not doing any of the login() steps