Re: [web2py] Date null display

2013-02-15 Thread Simon Ashley
Thanks Bruno, that works. (had tried that earlier, but didn't get it. Time to flex off for the weekend, me thinks) -- --- 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

[web2py] Re: web2py + exceptions(tickets) service?

2013-02-15 Thread Niphlod
Thanks for the answer Niphlod, but didn't understand the last part about being alerted(besides taking a look at the admin app). Cheers! http://web2py.com/books/default/chapter/29/13#Collecting-tickets and https://github.com/web2py/web2py/blob/master/scripts/tickets2email.py If you need

[web2py] Re: 2 grids loaded in a single form: back button reference

2013-02-15 Thread Niphlod
uhm. Can you try passing different formname(s) to the grids ? i.e. grid = SQLFORM.grid(db.dogs, ., formname='wholetthedogsout') #and grid = SQLFORM.grid(db.fleas, .., formname='itwasthefleas') -- --- You received this message because you are subscribed to the Google Groups

Re: [web2py] Re: web2py + exceptions(tickets) service?

2013-02-15 Thread Luciano Laporta Podazza
Whenever I think web2py can't surprise me with cool stuff it happens again :P Thanks Niphlod, you rock :D On Fri, Feb 15, 2013 at 7:00 AM, Niphlod niph...@gmail.com wrote: Thanks for the answer Niphlod, but didn't understand the last part about being alerted(besides taking a look at

[web2py] Re: delete session strange behaviour

2013-02-15 Thread Anthony
In the second and third cases, you delete session.order[id] but then try to return it, which will generate an error (so the response to the Ajax call will be a 500 error). This doesn't happen in the first case because the redirect happens before the return. Anthony On Thursday, February 14,

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

2013-02-15 Thread Anthony
I like the idea of including the ANY and CUSTOM validators (we don't need ALL, though, right? -- that's the default behavior for a list of validators). Anthony On Thursday, February 14, 2013 10:04:03 PM UTC-5, rochacbruno wrote: It gives me the idea of a CUSTOM validator class

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

2013-02-15 Thread Martin Weissenboeck
Very good ideas! Ok, ALL is not necessary, but it could make a program more readable if there is ANY in teh same program. 2013/2/15 Anthony abasta...@gmail.com I like the idea of including the ANY and CUSTOM validators (we don't need ALL, though, right? -- that's the default behavior for a

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

2013-02-15 Thread Anthony
Maybe the custom validator could also allow for transformations: class CUSTOM(object): def __init__(self, validate=lambda value: None, transform=lambda value:value ): self.validate = validate self.transform = transform def __call__(self, value): # the validate

[web2py] Re: custom auth table on separate file not in db.py

2013-02-15 Thread Anthony
when upgrade to the new version, web2py will updated the scaffolding that generated by default (like db.py, menu.py, default.py, layout.html, css, etc), isn't it? Well, it won't actually update your specific application files, which are just a copy of the welcome app (it will only update

[web2py] Send Email with Web2py on GAE development framework

2013-02-15 Thread José Manuel López Muñoz
Hi, I'm trying to send an email from GAE (mac OS), and I've config the mail settings. Now I'm getting this into the LOG: INFO 2013-02-15 10:19:36,770 mail_stub.py:138] MailService.Send From: x...@gmail.com To: x...@gmail.com Reply-to: u...@example.com Subject:Identificador 8E de

[web2py] Re: How to include a select field in a many to many relationship

2013-02-15 Thread José Manuel López Muñoz
Thank you Derek, I've search an example. I will try it. On Thursday, February 14, 2013 9:14:01 PM UTC+1, Derek wrote: You could make it a list:reference and then process that on accept by assigning the appropriate groups. On Wednesday, February 13, 2013 11:58:02 PM UTC-7, José Manuel

[web2py] Re: 2 grids loaded in a single form: back button reference

2013-02-15 Thread Simon Ashley
Thanks Niphlod, that worked. (Eventually. Had some weird caching going on. The submit was originally redirecting to an unrelated controller and function. Eventually cleared itself after deleting and reinserting the formname attribute. Using current trunk) -- --- You received this message

[web2py] Submit button Id

2013-02-15 Thread waqasiqbal . knysys
I want to access submit button id but the button is created in CRUD form, is there any way possible to access the id of submit type button?? I want to show fancy popup using that ID.. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To

[web2py] Re: Submit button Id

2013-02-15 Thread Niphlod
$('form :submit').attr('id') ? On Friday, February 15, 2013 1:10:30 PM UTC+1, waqasiqb...@gmail.com wrote: I want to access submit button id but the button is created in CRUD form, is there any way possible to access the id of submit type button?? I want to show fancy popup using that ID..

[web2py] Re: Submit button Id

2013-02-15 Thread Anthony
The submit button doesn't have an ID, but you can identify it in the DOM via type=submit. Or you can add an ID: form.element(_type='submit').update(_id='myid') Anthony On Friday, February 15, 2013 7:10:30 AM UTC-5, waqasiqb...@gmail.com wrote: I want to access submit button id but the button

[web2py] Re: 2 grids loaded in a single form: back button reference

2013-02-15 Thread Niphlod
the problem is that by default the referrer (i.e. the last page browsed, that of course is used to fill the back link) is stored in a session variable: fortunately it is formname dependant. https://github.com/niphlod/web2py/blob/master/gluon/sqlhtml.py#L1833 Maybe we could use a formname='auto'

[web2py] Scheduler Task + Worker + Run with DAL

2013-02-15 Thread operE Aperte
Hi all, I need to merge scheduler task, worker and run tables to get in one Rows object all the tasks, their assigned workers and the last run for each task. With sql I can achieve this with something like: rows_sch=db.executesql(SELECT t.*,w.*,r.* FROM SCHEDULER_TASK AS

[web2py] restrict multiple services decorators?

2013-02-15 Thread ecall
I'd like to have a service using multiple decorators. e.g. @service.run @service.json def concat(a,b): return a+b Calls such as: http://127.0.0.1:8000/app/default/call/run/concat/hello/world http://127.0.0.1:8000/app/default/call/json/concat/hello/world But XML works as well? How can I

Re: [web2py] Re: Submit button Id

2013-02-15 Thread Waqas Iqbal
i will try both of these , i think one of them will be the optimum solution. thanks alot Anthony and Niphlod. Best Regards, Waqas Iqbal | Associate Software Engineer [image: Inline image 1] http://www.knysys.com/ W +92-21-34972358 | M +92-342-3146972 Gtalk: waqasiqbal.knysys|

[web2py] anyone using the Issue Tracker appliance?

2013-02-15 Thread Jim S
I can't get it to upload through the admin interface. I just get a message saying 'unable to install application ticket'. Jim -- --- 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

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

2013-02-15 Thread Bruno Rocha
Great idea Anthony, CUSTOM can be used in many ways when a builtin validator does not match the requirements. I documented this here: http://rochacbruno.com.br/more-web2py-custom-validators/ @Massimo Can we include at least the CUSTOM in gluon.validators ? -- --- You received this message

[web2py] Re: Scheduler Task + Worker + Run with DAL

2013-02-15 Thread Niphlod
DAL can abstract some deal of queries but not such complex ones. Either you use executesql or you create a view and access it inside web2py as a fake table defining it with migrate=False. PS: unless for some weird requirements, that select is incredibly expensive. You'd be better off fetching

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

2013-02-15 Thread Andrew Buchan
Here's the exception I get: Traceback (most recent call last): File C:\Program Files\Hub Pages\web2py\gluon\restricted.py, line 212, in restricted exec ccode in environment File C:/Program Files/Hub Pages/web2py/applications/HubFormsTidy/views/appadmin.html

Re: [web2py] requires _ verification = True , no Flash?

2013-02-15 Thread António Ramos
Its not working the flash message def checkInbox(form): print on_accept triggered response.flash = Por favor verifique a sua caixa de correio print end after my auth custom fields and auth.define_tables() i have auth.settings.register_onaccept = checkInbox I see in console log the

[web2py] Database connection error

2013-02-15 Thread Hector Magnanao
Can someone help me out with an annoying database connection problem ? I have a local database in my PC using MySQL. I created the tables and loaded the data. But whenever I try to start my application, it keeps saying that some table already exist

[web2py] Re: Database connection error

2013-02-15 Thread Niphlod
yep, but you have either to: 1. copy over the databases/ folder (the .table files holds the state of the tables on the db as far as web2py knows, so the 2nd one if doesn't find the table files thinks it has to create them) 2. set migrate=False for the tables on the 2nd app (so web2py will trust

[web2py] Re: delete session strange behaviour

2013-02-15 Thread 黄祥
thank you so much for your detail explaination about the differnce logic, anthony. according to your explaination about return so that i've modified into : *#controllers/default.py* def order_callback(): id=int(request.vars.id) if request.vars.action=='add':

[web2py] Re: Database connection error

2013-02-15 Thread Hector Magnanao
Awesome !!! Option 2 worked. Thanks. On Friday, February 15, 2013 10:00:54 AM UTC-6, Niphlod wrote: yep, but you have either to: 1. copy over the databases/ folder (the .table files holds the state of the tables on the db as far as web2py knows, so the 2nd one if doesn't find the table

[web2py] Re: custom auth table on separate file not in db.py

2013-02-15 Thread 黄祥
thank you so much for your detail explaination anthony. i understand now, so that i'm just focus on the created the layout.html and created layout_custom.html for example which is often update when the new vesion is arrive. -- --- You received this message because you are subscribed to the

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

2013-02-15 Thread Massimo Di Pierro
I changed the IS_EXPR validator to allow the same notation suggested for CUSTOM. Can you check? On Thursday, 14 February 2013 21:04:03 UTC-6, rochacbruno wrote: It gives me the idea of a CUSTOM validator class CUSTOM(object): def __init__(self, function): self.function =

[web2py] Re: delete session strange behaviour

2013-02-15 Thread Anthony
Yes, you can have multiple return statements in different logic branches of a function. Anthony On Friday, February 15, 2013 11:44:02 AM UTC-5, 黄祥 wrote: thank you so much for your detail explaination about the differnce logic, anthony. according to your explaination about return so that

Re: [web2py] Connecting to MySQL via SSL

2013-02-15 Thread Richard Vézina
Better use SSH with port fowarding... Something like that in terminal : ssh -L3307:localhost:3306 linux_user@ip_address Then you should be able to use this connection string : db=DAL('mysql://user:pwd@127.0.0.1:3307/database', ...) Not tested... Richard On Thu, Feb 14, 2013 at 6:08 PM,

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

2013-02-15 Thread howesc
i did some grepping of my code and found some things - it seems that cache.ram is automatically set to GAE memcache when you are using GAE. it's part of the GAE setup web2py does for you. - the code above looks OK for storing sessions in memcache. FWIW, I gave up using memcache for

Re: [web2py] Re: Integrating iPhone device tokens into web2py auth

2013-02-15 Thread howesc
Yes, that sounds similar to what i do. - i created a custom auth user table, it happens to be called end_user (though it can be called auth_user): auth.settings.table_user_name = 'end_user' auth.settings.table_user = db.end_user.table auth.define_tables() - My end_user

[web2py] Re: serving php and python in shared hosting

2013-02-15 Thread José Eloy
Thanks howesc. I'll read these documents. Regards. -- --- 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 options,

[web2py] Re: custom auth table on separate file not in db.py

2013-02-15 Thread LightDot
I'd say that common work flow when creating new web2py applications is: - create a new application trough admin. Name it for example init (if you want it to be the default, without touching the routes) or something else - edit it, either trough admin's embedded editor or by other means - once

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

2013-02-15 Thread Bruno Rocha
Cool! but it does not allow the transformation. class CUSTOM(object):you can use a function or a lambda to validate or/and transform the field in the way you wantit is the same as onvalidation and onsuccess form callbacksbut it can be used per field in models or controller level

[web2py] How to remove items that a user owns when selecting rows from db?

2013-02-15 Thread bracquet
I have a quick question. If we take this database setup: https://github.com/mdipierro/web2py-appliances/blob/master/PosOnlineStore/models/db_pos.py How does one query for all products that the current auth.user.id hasn't bought yet (ie, return all items excluding those in sales for this user)?

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

2013-02-15 Thread Niphlod
on the too fast eviction issue, I remember that something was added to set the default expiration time, a time_expire parameter. On Friday, February 15, 2013 7:32:42 PM UTC+1, howesc wrote: i did some grepping of my code and found some things - it seems that cache.ram is automatically

[web2py] Re: instantpress app fails on server, ok locally

2013-02-15 Thread greaneym
Thanks, Andrew Replogle. The fix was to update the os environment on openshift so that it could see the modules. The file named application was updated with the appended path, and then the app worked fine with no restart. Also I tried the older version of instantpress and this worked

[web2py] Re: instantpress app fails on server, ok locally

2013-02-15 Thread greaneym
details are on github in Andrew Replogle's area. On Friday, February 15, 2013 2:23:37 PM UTC-6, greaneym wrote: Thanks, Andrew Replogle. The fix was to update the os environment on openshift so that it could see the modules. The file named application was updated with the appended

[web2py] field of password type is displayed as cleartext in smartgrid form

2013-02-15 Thread wwwgong
Hi, I am using web2py v2.3.2 and see that field of password type is displayed as cleartext in smartgrid form (screenshot is attached). Is this design behavior or a bug? but password is hidden in edit view -- --- You received this message because you are subscribed to the Google Groups

Re: [web2py] field of password type is displayed as cleartext in smartgrid form

2013-02-15 Thread Bruno Rocha
You should apply the CRYPT() validator when storing the password -- --- 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

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

2013-02-15 Thread Christian Espinoza
Hi all!, could somebody get me a hand in order to improve this code, please? I'm getting a array of dicts here, every device have it last event attached in the dict... I'm want delete the iteration over the events table, I don't think it is efficient enough maybe it could be changed doing a

[web2py] Re: Database connection error

2013-02-15 Thread Hector Magnanao
Will these options also work for database that is on a linux server ? On Friday, February 15, 2013 10:44:05 AM UTC-6, Hector Magnanao wrote: Awesome !!! Option 2 worked. Thanks. On Friday, February 15, 2013 10:00:54 AM UTC-6, Niphlod wrote: yep, but you have either to: 1. copy over the

[web2py] Re: Database connection error

2013-02-15 Thread Niphlod
web2py is multiplatform. it behaves in the same exact way in every os it runs into. On Friday, February 15, 2013 11:25:10 PM UTC+1, Hector Magnanao wrote: Will these options also work for database that is on a linux server ? On Friday, February 15, 2013 10:44:05 AM UTC-6, Hector Magnanao

[web2py] how to select all rows in Google Appengine, to produce a SQLFORM.grid for a whole table?

2013-02-15 Thread Luca
I need to form a SQLFORM.grid in Google Appengine that will select all rows. Normally, I would use something like: q = (db.table.id 0) grid = SQLFORM.grid(q, ...) But in GAE, there are restrictions on inequality queries, so it seems silly to use an inequality to get all rows. Is there a

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

2013-02-15 Thread Alan Etkin
Try this. Not tested but should work: events = db(db.events.device_id==db.devices.id).select().as_dict() -- --- 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] Re: how to select all rows in Google Appengine, to produce a SQLFORM.grid for a whole table?

2013-02-15 Thread Luca
Found: q = db.table seems to work. Aha! --Luca On Friday, February 15, 2013 3:03:34 PM UTC-8, Luca wrote: I need to form a SQLFORM.grid in Google Appengine that will select all rows. Normally, I would use something like: q = (db.table.id 0) grid = SQLFORM.grid(q, ...) But in GAE,

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

2013-02-15 Thread howesc
sorry, i was unclear GAE will forcibly evict data when some unpublished limits are reached. i don't know if these limits are time or space, or a space-time continuum, but when i was storing sessions in memcache my max life was about 5 mins. On Friday, February 15, 2013 11:41:30 AM UTC-8,

[web2py] Re: Problem reading xls with xlrd

2013-02-15 Thread Brian M
I'm pretty sure that archivo='/home/lu/web2py/applications/pruebas/uploads/'+form.vars.pago doesn't actually contain the path to your file (and you should also probably be using os.path.join() rather than just concatenating) Here's some old code from an app I had that was allowing upload of

[web2py] Re: Send Email with Web2py on GAE development framework

2013-02-15 Thread howesc
the snarky/mean person in me says If you have sendmail installed you can use it by using the server with --enable_sendmail i've failed at getting sendmail setup. i find it's much easier to add the switch to the GAE SDK that prints the email contents in the log (i don't remember that switch

[web2py] Re: DAL return number of rows affected?

2013-02-15 Thread howesc
isn't that the return value? i know it is for delete On Thursday, February 14, 2013 5:47:36 PM UTC-8, Cliff Kachinske wrote: Is it possible to get the number of rows affected by an update in the DAL? -- --- You received this message because you are subscribed to the Google Groups

[web2py] Re: anyone using the Issue Tracker appliance?

2013-02-15 Thread Andrew Replogle
Jim, Is this in GAE or an environment that doesn't have a file backed store? I believe initially the tickets are created as files but you can configure it to be records in a db. Regards, Andrew On Friday, February 15, 2013 8:54:01 AM UTC-6, Jim S wrote: I can't get it to upload through

[web2py] Re: DAL return number of rows affected?

2013-02-15 Thread Massimo Di Pierro
it is. affected_rows = db(...).update(...) strange. i responded to this yesterday but my post does not show. On Friday, 15 February 2013 17:20:43 UTC-6, howesc wrote: isn't that the return value? i know it is for delete On Thursday, February 14, 2013 5:47:36 PM UTC-8, Cliff Kachinske

[web2py] Re: delete session strange behaviour

2013-02-15 Thread 黄祥
thank you so much for your explaination, antony, i thought it was an illegal operation in web2py work flow or programming logic. but some times it's wise to decide it whether use redirect or return locals(), or is there any other options to do this except using redirect or return locals()?

[web2py] Re: custom auth table on separate file not in db.py

2013-02-15 Thread 黄祥
thank you very much for your detail explaination, lightdot. it makes me clear right now. is that hard way is same like build minimalist web2py ( http://web2py.com/books/default/chapter/29/14#Building-a-minimalist-web2py) or it just pure build it from scratch? i'm usually create the application

[web2py] Re: suggestion for markmin qr to use google chart

2013-02-15 Thread Massimo Di Pierro
I agree. Would you be able to submit a patch. On Friday, 15 February 2013 18:32:32 UTC-6, 黄祥 wrote: hi, recently i know that markmin in web2py can support auto generate for qr code that is redirect to kaywa, i would suggest is it possible to change the default to redeirect to google

Re: [web2py] Re: web2py + exceptions(tickets) service?

2013-02-15 Thread Alec Taylor
On Fri, Feb 15, 2013 at 8:00 PM, Niphlod niph...@gmail.com wrote: Thanks for the answer Niphlod, but didn't understand the last part about being alerted(besides taking a look at the admin app). Cheers! http://web2py.com/books/default/chapter/29/13#Collecting-tickets and

[web2py] Re: suggestion for markmin qr to use google chart

2013-02-15 Thread 黄祥
how to submit a patch in web2py? i've already search in book http://www.web2py.com/book/default/chapter/01#Contribute but don't know which file that must be update. ive already take a look in https://github.com/web2py/web2py/blob/master/gluon/contrib/markmin/markmin.html, but can't find the

[web2py] Re: How to remove items that a user owns when selecting rows from db?

2013-02-15 Thread 黄祥
what do you mean by sales? is it in the session order or is it in the table? -- --- 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

Re: [web2py] ipython is your friend!

2013-02-15 Thread wwwgong
I like IPython On Sunday, February 10, 2013 6:20:30 AM UTC-5, Ramos wrote: +1 for a VIDEO of this... 2013/2/9 JimK jke...@gmail.com javascript: One of the nice things about python modules that are not c-compiled is the fact that you can read the source code. The bad part is that the

[web2py] Re: suggestion for markmin qr to use google chart

2013-02-15 Thread Massimo Di Pierro
The file is gluon/contrib/markmin/markmin2html.py You can simply email me the changed file. On Friday, 15 February 2013 20:30:52 UTC-6, 黄祥 wrote: how to submit a patch in web2py? i've already search in book http://www.web2py.com/book/default/chapter/01#Contribute but don't know which file

[web2py] Re: delete session strange behaviour

2013-02-15 Thread Anthony
What error occurs if you return locals()? If the view is expecting a particular variable to be returned but that variable is not in locals(), that would cause an error -- is that the issue? Anthony On Friday, February 15, 2013 7:39:17 PM UTC-5, 黄祥 wrote: thank you so much for your

[web2py] SmartGrid and New button 1 to many

2013-02-15 Thread Dan Kozlowski
Does anyone know if I smartgrid to can create another button next to View, Edit, Delete that will allow it to open a new search screen ? I have a customer ( 1 to many notes) and would like a Notes button that takes you to another search screen to allow you to view 1 to many Notes a

Re: [web2py] Re: anyone using the Issue Tracker appliance?

2013-02-15 Thread Jim Steil
I didn't specify anything, just tried importing it into my environment through the admin interface and it failed. On Fri, Feb 15, 2013 at 5:22 PM, Andrew Replogle andrew.replo...@gmail.comwrote: Jim, Is this in GAE or an environment that doesn't have a file backed store? I believe initially

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

2013-02-15 Thread Jim S
This should be the default behavior if you have your tables and relations defined properly. If it isn't then you can provide other links using the 'links' parameter that you can pass to SQLFORM.smartgrid. If that doesn't make sense, post the code, table defs and call to SQLFORM.smartgrid and

[web2py] Re: delete session strange behaviour

2013-02-15 Thread 黄祥
hi anthony, sorry, i'm not sure what do you mean 'the view is expecting a particular variable to be returned but that variable is not in locals()' here is the code that return an error: for k, v in session.order.items(): if v==0: del session.order[k] *