[web2py] Re: delete session strange behaviour

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] *redirec

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

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 w

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

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 wrote: > Jim, > > Is this in GAE or an environment that doesn't have a file backed store? I > believe initially the tickets are creat

[web2py] SmartGrid and New button 1 to many

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 customer

[web2py] Re: delete session strange behaviour

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 explainat

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

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 f

Re: [web2py] ipython is your friend!

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 > > >> 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 >> source code is not

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

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 web2py+unsubscr...@googlegroup

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

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 qr

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

On Fri, Feb 15, 2013 at 8:00 PM, Niphlod 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 > https://github.com

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

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

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

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 t

[web2py] Re: delete session strange behaviour

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()? here

[web2py] suggestion for markmin qr to use google chart

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 chart : http://chart.apis.google.com/ ? because the kaywa is not free for create the other data (for example :

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

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 Kachins

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

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 t

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

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 "we

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

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 switc

[web2py] Re: Problem reading xls with xlrd

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 exc

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

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, N

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

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, ...) > > Bu

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

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 w

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

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 b

[web2py] Re: Database connection error

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] Re: Database connection error

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 ove

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

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 bett

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

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 m

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

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 "web2py

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

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 ap

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

> 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 w

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

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 automatica

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

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)?

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

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 l

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

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 y

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

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,

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

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 t

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

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 sessi

Re: [web2py] Connecting to MySQL via SSL

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, Osma

[web2py] Re: delete session strange behaviour

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 tha

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

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: custom auth table on separate file not in db.py

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 Go

[web2py] Re: Database connection error

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: delete session strange behaviour

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': session.order[id]=sess

[web2py] Re: Database connection error

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] Database connection error

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 " 127.0.0.1.2013-02-15.09-51-45.a00216cb-b

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

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

[web2py] 'appadmin' on trying ot load data admin

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"

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

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 t

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

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 b

[web2py] anyone using the Issue Tracker appliance?

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 fro

Re: [web2py] Re: Submit button Id

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] W +92-21-34972358 | M +92-342-3146972 Gtalk: waqasiqbal.knysys| wiq...@knysys.

[web2py] restrict multiple services decorators?

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 res

[web2py] Scheduler Task + Worker + Run with DAL

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] Re: 2 grids loaded in a single form: back button reference

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] Re: Submit button Id

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 but

[web2py] Re: Submit button Id

$('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] Submit button Id

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: 2 grids loaded in a single form: back button reference

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] Re: How to include a select field in a many to many relationship

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] Send Email with Web2py on GAE development framework

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: custom auth table on separate file not in db.py

> > 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 u

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

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 func

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

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 > 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

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

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 CUSTOM(

[web2py] Re: delete session strange behaviour

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, 20

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

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 wrote: > > >> Thanks for the answer Niphlod, but didn't understand the last part about >> being alerted(besides taking a look at the admin app)

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

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 "web2py-u

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

> > 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

Re: [web2py] Date null display

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 e