[web2py] Re: float field search and grid/smartgrid

2014-10-16 Thread Mirko
Hi all, maybe I should elaborate a little bit more: here's my model: db.define_table('myTable', Field('myDate','datetime'), Field('myString','string'), Field('myFloat','float'), ) here's my controller: def index(): grid = SQLFORM

[web2py] Re: SAML2 Service Provider app in web2py?

2014-10-16 Thread Prasad Muley
Hi Wel, Did you test SAML2 app? there is an experimental saml2 app in web2py_2.9.6 I need to use saml2(web2py app) as service provider with onelogin (which is idp) I am getting an error (Screen shot is attached PFA). here is my config settings 1) *private/sp_conf.py* # Make sure the

Re: [web2py] Web Hosting Services in USA UK INDIA MALAYSIA HONGKONG INDIA

2014-10-16 Thread Robby O'Connor
Can people not spam? --Rob Sent from my cell, please excuse any typos. On Oct 16, 2014 11:59 PM, "rock arch" wrote: > Ave Infosys is a leading professional in Web Designing Company in > Hyderabad India for the E-Business Industry.Ave Infosys are providing Best > Website Development and Design Se

[web2py] Re: Apostrophe causes new column in PYFPDF

2014-10-16 Thread Massimo Di Pierro
can you send a patch to Mariano (author of pyfpdf) and to me? On Wednesday, 15 October 2014 13:05:38 UTC-5, Leonel Câmara wrote: > > I have found the problem. It's not the HTML helpers that are escaping > twice. > > The problem is that gluon.contrib.generics.pyfpdf_from_html calls sanitize > on

[web2py] Re: Error starting up scheduler with postgresql - "type oid 114 not mapped to py"

2014-10-16 Thread Sebastian Echeverria
Hello, Thanks for the reply! So in fact, the issue is the same one the other poster was facing. Do you have any hints on how to use psycopg2 instead? Where would I have to change that? Is there a configuration for that, or would I have to make that change somewhere in the code? Thanks, Sebast

[web2py] Shopping cart concept without the payment

2014-10-16 Thread Joe
This is what I am trying to do: I want the user to be able to select images, using a select button under each image. My plan to achieve this is: 1. define a table for all the images and define an other table for the images the user will select. 2. create a function with an SQLFORM to process

[web2py] Configure web2py for catalan language

2014-10-16 Thread Oscar Chic
I try to add catalan language to web2py When Create Language ca.py I get a new file ca.py but also an error "gluon/contrib/plural_rules/ca.py not found" I make a test translating a string but does not work I appreciate your help Òscar -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] How to create subdomain in web2py app.

2014-10-16 Thread Jawad K.
Hi, I am a new developer and I have data management app using web2py. I want to know how to create subdomain functionality that perform the following operations. - Each account should be associated with a sub-domain entered by user on account sign-up - On new account signup user sho

[web2py] Web Hosting Services in USA UK INDIA MALAYSIA HONGKONG INDIA

2014-10-16 Thread rock arch
Ave Infosys is a leading professional in Web Designing Company in Hyderabad India for the E-Business Industry.Ave Infosys are providing Best Website Development and Design Services in Hyderabad.Our company offers the Best Web Design & Web Development services, *Web Hosting Services

[web2py] smartgrid add button override

2014-10-16 Thread Alen Cerovic
Hi, how to change url for Add button in smartgrid. I also tried create=False but dont know how to add new button on the same position thnx -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2

[web2py] One AutoComplete overrides another

2014-10-16 Thread Tim Nyborg
I've run into an odd problem with autocomplete: I have a factory form doing an autocomplete lookup on the field idb.module.code, with custom help_fields, etc., and it works well: browseform = SQLFORM.factory(Field('code', widget=SQLFORM.widgets. autocomplete(request, idb.module.code, id_field=id

Re: [web2py] How can I prevent a user from pressing the browser's back button?

2014-10-16 Thread Fotis Gioulekas
Thank you for the reply. On Saturday, August 30, 2014 9:31:00 AM UTC+3, Marin Pranjić wrote: > > You can't. This is something you should take care of on server side. > Use session to store user's state, or store it in DB. > > > On Tue, Aug 26, 2014 at 11:36 PM, Fotis Gioulekas > wrote: > >> Hell

[web2py] Re: How can I prevent a user from pressing the browser's back button?

2014-10-16 Thread Fotis Gioulekas
Hello, do you how is this possible to be performed? The user is not logged in. On Saturday, August 30, 2014 5:28:20 PM UTC+3, Anthony wrote: > > The details will depend on exactly how you want to control access to quiz > questions, but the general solution would be to store the user state in th

[web2py] Re: What are .table files in sqlite databases?

2014-10-16 Thread Dave S
On Thursday, October 16, 2014 1:03:00 AM UTC-7, Mirek Zvolský wrote: > > .table file will change only, when you change table definition (usually > defined in model like db.py). > So if you decide to backup them, you can reuse them later, if they relate > to the same (not changed) table structur

[web2py] Re: Replace 'Welcome' next to username without modifying source code.

2014-10-16 Thread LoveWeb2py
One last thing, Anthony. Is it possible to make prefix equal a class? I'd like to use font awesome as the prefix. On Thursday, October 16, 2014 10:02:16 PM UTC-4, LoveWeb2py wrote: > > Just realized it goes in layout.html... /slaps self with large trout > > lol > > Thanks, Anthony. You're the bes

[web2py] Re: Replace 'Welcome' next to username without modifying source code.

2014-10-16 Thread LoveWeb2py
Just realized it goes in layout.html... /slaps self with large trout lol Thanks, Anthony. You're the best!! On Thursday, October 16, 2014 9:56:54 PM UTC-4, LoveWeb2py wrote: > > Wow... awesome, Anthony. Thank you. I figured it was something easy. Where > should I put that exactly? I've tried pu

[web2py] Re: Replace 'Welcome' next to username without modifying source code.

2014-10-16 Thread LoveWeb2py
Wow... awesome, Anthony. Thank you. I figured it was something easy. Where should I put that exactly? I've tried putting it in db.py and menu.py and even my controller, but its not taking. On Thursday, October 16, 2014 9:49:10 PM UTC-4, Anthony wrote: > > auth.navbar(prefix='Howdy') > > Anthony

[web2py] Re: Replace 'Welcome' next to username without modifying source code.

2014-10-16 Thread Anthony
auth.navbar(prefix='Howdy') Anthony On Thursday, October 16, 2014 8:26:29 PM UTC-4, LoveWeb2py wrote: > > Is it possible? I see the code in tools.py, but I don't see any methods > for the class. I guess I could do something like menu = auth.navbar() and > try to take it from there? I went throu

[web2py] Replace 'Welcome' next to username without modifying source code.

2014-10-16 Thread LoveWeb2py
Is it possible? I see the code in tools.py, but I don't see any methods for the class. I guess I could do something like menu = auth.navbar() and try to take it from there? I went through the book and didn't see anything so just want to know if I missed something. -- Resources: - http://web2py

[web2py] Re: Filter with IS_IN_DB without changing record presentation format

2014-10-16 Thread Anthony
Yes: http://web2py.com/books/default/chapter/29/07/forms-and-validators#Database-validators On Thursday, October 16, 2014 5:02:16 PM UTC-4, Álvaro José Iradier wrote: > > Thanks, perfect, that was just what I was looking for! > > Is that in the book or the docs somewhere? > > > On Thursday, Octob

[web2py] Re: Filter with IS_IN_DB without changing record presentation format

2014-10-16 Thread Álvaro José Iradier
Thanks, perfect, that was just what I was looking for! Is that in the book or the docs somewhere? On Thursday, October 16, 2014 8:29:37 PM UTC+2, Anthony wrote: > > You can pass the format as the third argument to the validator: > > IS_IN_DB(db(db.gang_users.gang == gang.id), db.gang_users.nickn

[web2py] Re: Filter with IS_IN_DB without changing record presentation format

2014-10-16 Thread Anthony
You can pass the format as the third argument to the validator: IS_IN_DB(db(db.gang_users.gang == gang.id), db.gang_users.nickname, db. gang_users._format) Anthony On Thursday, October 16, 2014 2:02:02 PM UTC-4, Álvaro José Iradier wrote: > > Hi, I have a field in table 'expenses' defined as: >

[web2py] Filter with IS_IN_DB without changing record presentation format

2014-10-16 Thread Álvaro J . Iradier
Hi, I have a field in table 'expenses' defined as: db.define_table('expenses', Field('gang', db.gangs, required=True, notnull=True), ... Field('payer', db.gang_users, label=T('Payer')), ... Table gang_users has a format like: db.defi

[web2py] Re: cache.disk.clear() crashes in appadmin

2014-10-16 Thread Leonel Câmara
I have found the problem in appadmin.py and fixed it. You can put it in your applications controllers replacing the one in controllers/appadmin.py to fix the problem. Here are the steps: 1. Replace appadmin.py with the one attached here. 2. Delete everything in the cache folder. 3. Problem Solve

Re: [web2py] Re: Have tickets delivered via email

2014-10-16 Thread Jim Steil
Perfect, thank you! Jim On Oct 16, 2014 9:35 AM, "Mirko" wrote: > There's a tickets2email.py file in scripts folder. Works like a charm. > > hth > - Mirko > > On Thursday, October 16, 2014 3:02:58 PM UTC+2, Jim S wrote: >> >> I looked through the book and the the forum here but can't find the

[web2py] float field search and grid/smartgrid

2014-10-16 Thread Mirko
Sorry, is the float search implemented in grid and smartgrid? I have a table with date, string and float fields and float fields are not searchable. Thanks, -Mirko -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - ht

[web2py] Re: cache.disk.clear() crashes in appadmin

2014-10-16 Thread Leonel Câmara
Humm nevermind, it seems these files that cause the problem are being created automatically by appadmin. So deleting them only temporarily solves the problem. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://cod

[web2py] Re: cache.disk.clear() crashes in appadmin

2014-10-16 Thread Leonel Câmara
Hey, I have found the problem and it's not due to a bug (more like there needs to be a bit of a cleanup before upgrading to this version and this should have probably been documented). In you applications cache folder you have a cache.lock and cache.shelve, delete them. Or just delete the entire

Re: [web2py] Re: Export view to a file client side

2014-10-16 Thread Sergio Leal
Thank you very much Anthony. I was stuck with this!! It works perfectly! Again thank you Anthony. Kind regards 2014-10-16 15:07 GMT+02:00 Anthony : > Are you saying you want the client to be able to download a fully rendered > HTML document (as opposed to actually displaying the HTML in the bro

[web2py] Re: Have tickets delivered via email

2014-10-16 Thread Mirko
There's a tickets2email.py file in scripts folder. Works like a charm. hth - Mirko On Thursday, October 16, 2014 3:02:58 PM UTC+2, Jim S wrote: > > I looked through the book and the the forum here but can't find the answer. > > Is there a way to configure it so that all web2py tickets are sent to

[web2py] Re: cache.disk.clear() crashes in appadmin

2014-10-16 Thread Eric
@Paolo: Done (http://code.google.com/p/web2py/issues/detail?id=1996) @Leonel: Thans! -- 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 received this me

[web2py] Re: cache.disk.clear() crashes in appadmin

2014-10-16 Thread Leonel Câmara
Hey, It's not a known issue, the disk cache implementation is completely new in this version. I managed to replicate the error and I'm investigating the cause. I'll get back to you in this thread soon. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.

[web2py] Re: Export view to a file client side

2014-10-16 Thread Anthony
Are you saying you want the client to be able to download a fully rendered HTML document (as opposed to actually displaying the HTML in the browser)? If so, you can do something like this: def export(): import cStringIO html = response.render(dict(test=test, stats=stats)) export = cS

[web2py] Have tickets delivered via email

2014-10-16 Thread Jim S
I looked through the book and the the forum here but can't find the answer. Is there a way to configure it so that all web2py tickets are sent to me via email? If I've missed it in the book, could someone please point it out to me? -Jim -- Resources: - http://web2py.com - http://web2py.com/bo

[web2py] Re: cache.disk.clear() crashes in appadmin

2014-10-16 Thread Paolo Valleri
Open a ticket on google code On Thursday, October 16, 2014 11:18:53 AM UTC+2, Eric wrote: > > Hi All, > > When I press the 'empty cache' button on the Appadmin I get a nice error: > > Traceback (most recent call last): > File "/home/eric/Projects/Web2Py/site/gluon/restricted.py", line 224, in >

[web2py] Export view to a file client side

2014-10-16 Thread CrC Nommack
Hi everybody. First of all thank you very much for your help it would be really appreciated. Well this is "my problem". I have a custom view and I want it to be save as a html file by the client. But I don't know how to do it!!! I tried: with open(filename, 'wb') as f: f.write(response

[web2py] Re: web2py 2.9.6 is out!

2014-10-16 Thread Prasad Muley
Hi Massimo, I have had followed your instructions and got following error. [Errno 2] No such file or directory: u'pki/mycert.pem' I think, there is a wrong path assigned in *applications/saml2/private/sp_config.py* for these keys I've resolved this error by changing two lines in CONFIG s

Re: [web2py] error in sample saml app in web2py.2.9.6

2014-10-16 Thread Prasad Muley
I've solved this error. I've made change in private/sp_conf.py changed CONFIG settings as - "key_file": "pki/mykey.pem", - "cert_file": "pki/mycert.pem"% PATH, + "key_file": "%s/pki/mykey.pem" % PATH, + "cert_file": "%s/pki/mycert.pem"% PATH, It successfully check whether I am login in idp or

[web2py] cache.disk.clear() crashes in appadmin

2014-10-16 Thread Eric
Hi All, When I press the 'empty cache' button on the Appadmin I get a nice error: Traceback (most recent call last): File "/home/eric/Projects/Web2Py/site/gluon/restricted.py", line 224, in restricted exec ccode in environment File "/home/eric/Projects/Web2Py/site/applications/cms/controller

[web2py] options widget

2014-10-16 Thread Annet
In a function I have: db.grp_membership.subgroupID.requires = IS_IN_DB(db(db.grp_subgroup.groupID==groupID), 'grp_subgroup.id', '%(name)s', zero='Selecteer een sub groep', error_message='Sub groep niet in database') In case of an error this adds a class="generic-widget form-control invalidinp

[web2py] Re: What are .table files in sqlite databases?

2014-10-16 Thread Mirek Zvolský
.table file will change only, when you change table definition (usually defined in model like db.py). So if you decide to backup them, you can reuse them later, if they relate to the same (not changed) table structure as is in your database backup. I use simple small application at alwaysdata ho

[web2py] error in sample saml app in web2py.2.9.6

2014-10-16 Thread Prasad Muley
Hi All, I am getting an error when I try to login in sample *saml2 app* ( http://127.0.0.1:8000/saml2/default/user/login?_next=/saml2/default/index) [Errno 2] No such file or directory: u'pki/mycert.pem' Did anybody use sample saml2? -- Resources: - http://web2py.com - http://web2py.co