[web2py] Re: Email and PGP

2014-01-29 Thread horridohobbyist
Okay, looks like nobody can help me. I guess not that many people use PGP email from web2py. Probably because it's so gnarly. This has been my second attempt to get PGP email working. My first attempt was 2 years ago, and at that time I had to give up for lack of support. I shall have to give u

Re: [web2py] Re: Default Login method using email not HTML5 ready?

2014-01-29 Thread Jim Steil
Perfect! Just what I was looking for, thanks for the help. -Jim On Wed, Jan 29, 2014 at 4:15 PM, Paolo Valleri wrote: > You should customize the widget, try something like: > > > db.auth_user.email.widget = lambda f,v: SQLFORM.widgets.string.widget(f, > v, _placeholder='Email', _type='email')

[web2py] Re: DAL: tables that reference tables that reference tables...

2014-01-29 Thread Alex
from the book: requires is a validator or a list of validators. This is not used by the DAL, but it is used by SQLFORM therefor fields like Field("manufacturer", requires=IS_IN_DB(db, db.test_manufacturer)), will probably get the default type (string). So you should define it with the apropriat

[web2py] add the session value to an existing session

2014-01-29 Thread 黄祥
hi, is it possible to add the session value to an existing session? let say i have the session purchase_order that store quantity, user can input price in form field, i want to store it in session then calculate it. e.g. *views/**transaction/**purchase_order.html* {{price = 5}} {{grand_total =

[web2py] Re: Querying rows over several many-to-many tables.

2014-01-29 Thread Apple Mason
Can you quickly explain the difference between: (db.clothing.id==db.clothing_person.clothing_Id) & (db.person.id==db.clothing_person.person_id) and (db.clothing_person.clothing_id==db.clothing.id) & (db.clothing_person.person_id==db.person.id) On Wednesday, January 29, 2014 5:15:51 PM UTC-5,

Re: [web2py] Re: update via ajax getting error.

2014-01-29 Thread אבי אברמוביץ
Ooops. Great thanks. On Jan 30, 2014 1:04 AM, "Anthony" wrote: > Should be .update(api_key=uuid.uuid4()). > > Anthony > > On Wednesday, January 29, 2014 5:09:40 PM UTC-5, Avi A wrote: >> >> Hi, >> I am trying something like that: (render current api key and update it if >> clicking) >> >> on the

[web2py] Re: update via ajax getting error.

2014-01-29 Thread Anthony
Should be .update(api_key=uuid.uuid4()). Anthony On Wednesday, January 29, 2014 5:09:40 PM UTC-5, Avi A wrote: > > Hi, > I am trying something like that: (render current api key and update it if > clicking) > > on the view: > > Get new api key > {{=LOAD('default','api_key.load',ajax=True)}} > >

[web2py] Re: update via ajax getting error.

2014-01-29 Thread Avi A
I also get on the error log on the Variables : ).update undefined On Thursday, January 30, 2014 12:42:03 AM UTC+2, Avi A wrote: > >db(db.auth_user.id == auth.user.id).update(api_key == uuid.uuid4()) > TypeError: update() takes exactly 1 argument (2 given) > > > On Thursday, January 30, 2014 12

[web2py] Re: update via ajax getting error.

2014-01-29 Thread Avi A
db(db.auth_user.id == auth.user.id).update(api_key == uuid.uuid4()) TypeError: update() takes exactly 1 argument (2 given) On Thursday, January 30, 2014 12:30:04 AM UTC+2, Avi A wrote: > > Thanks, > I'm still getting the same error. > > On Thursday, January 30, 2014 12:18:35 AM UTC+2, Niphlo

[web2py] Re: Weird problems generating menu from database

2014-01-29 Thread web2pygroup
Hi again all! Upon further trying to expand and experiment I stuck at something that maybe I need to be clarified on or I'm doing wrong. Basically what I did is create a "store.py" in that I specified the database exactly like it was in db.py (except. Then what I did in menu.py was simply ch

[web2py] Re: update via ajax getting error.

2014-01-29 Thread Avi A
Thanks, I'm still getting the same error. On Thursday, January 30, 2014 12:18:35 AM UTC+2, Niphlod wrote: > > the syntax is wrong > it's > > db(condition).update(column_name=value) > > not > > db(condition).update(db.table.column_name=value) > > On Wednesday, January 29, 2014 11:09:40 PM UTC+

[web2py] Re: update via ajax getting error.

2014-01-29 Thread Niphlod
the syntax is wrong it's db(condition).update(column_name=value) not db(condition).update(db.table.column_name=value) On Wednesday, January 29, 2014 11:09:40 PM UTC+1, Avi A wrote: > > Hi, > I am trying something like that: (render current api key and update it if > clicking) > > on the v

[web2py] Re: Querying rows over several many-to-many tables.

2014-01-29 Thread Niphlod
You can't achieve it without a "custom function", but it's not that hard to write //totally untested// def search_whatever(people=[], items=[], clothings=[]): q = db.people.name.belongs(people) if items: q = q & (db.item_person.person_id == db.person.id) #the reference

Re: [web2py] Re: Default Login method using email not HTML5 ready?

2014-01-29 Thread Paolo Valleri
You should customize the widget, try something like: db.auth_user.email.widget = lambda f,v: SQLFORM.widgets.string.widget(f, v, _placeholder='Email', _type='email') Paolo On Wednesday, January 29, 2014 9:10:52 PM UTC+1, Jim S wrote: > > Is there a plan to add it? Anything I can do to help?

[web2py] update via ajax getting error.

2014-01-29 Thread Avi A
Hi, I am trying something like that: (render current api key and update it if clicking) on the view: Get new api key {{=LOAD('default','api_key.load',ajax=True)}} $(document).ready(function(){ $("#change_api_key").click(function(){ url = 'api_key.load/1' ; ajax(default/url, '

[web2py] Re: Querying rows over several many-to-many tables.

2014-01-29 Thread Apple Mason
Is there a more lenient version of what_I_want that will give me based on what I put in? For example, If I just want all people named Bob, it would return all people named Bob. If I just want all people named Bob or nicknamed Bobcat, then I wlll get all people named Bob or nicknamed Bobcat. If

[web2py] Re: Companies and Startups that use WEB2PY

2014-01-29 Thread NeoToren
How can one add a company to the list ? Here is something I have participated in its development (and it was so much fun learning W2P !!!): http://icd10doc.com/ On Wednesday, January 29, 2014 7:44:54 AM UTC-5, Francisco Costa wrote: > > List of some Companies and Startups that use Web2py: > ht

Re: [web2py] Re: Examples of customizing SQLFORM.grid add/edit/view screens?

2014-01-29 Thread Jim Steil
You can query request(0) for either 'new', 'edit', 'view' and I think 'delete' to see what operation you're acting on. -Jim On Wed, Jan 29, 2014 at 3:28 PM, Jim Steil wrote: > Here is what I would do. > > def manage_employees(): > company_id = 1 > employees_for_company1 = db().select(d

Re: [web2py] Re: Examples of customizing SQLFORM.grid add/edit/view screens?

2014-01-29 Thread Jim Steil
Here is what I would do. def manage_employees(): company_id = 1 employees_for_company1 = db().select(db.employees.company_id == company_id) if request(0) == 'new': db.employees.company_id.default = company_id db.employees.company_id.writable = False db.employees

[web2py] Re: Examples of customizing SQLFORM.grid add/edit/view screens?

2014-01-29 Thread A36_Marty
Thanks for your reply. Might be the clearest to respond with code: db.define_table('company', Field('name','string' )) db.define_table('employees', Field('company_id', db.company), Field('name', 'string')) def manage_employees(): employees_for_company1 = db().select(db.emplo

Re: [web2py] Re: Default Login method using email not HTML5 ready?

2014-01-29 Thread Jim Steil
Is there a plan to add it? Anything I can do to help? -Jim On Wed, Jan 29, 2014 at 2:08 PM, Niphlod wrote: > there are no HTML5 widgets whatsoever in web2py right now. > > On Wednesday, January 29, 2014 4:41:37 PM UTC+1, Jim S wrote: >> >> I have an app that is using the standard web2py login

[web2py] Re: binary(1024) field truncates to 255

2014-01-29 Thread Niphlod
post the code please. executesql('abc') just does cursor.execute('abc') cursor.fetchall() On Wednesday, January 29, 2014 12:55:51 PM UTC+1, Oleg Marin wrote: > > Hi! > > I'm using MSSQL2008 in readonly without tables definition, and when I run > stored procedure with executesql, it returns fi

[web2py] Re: Default Login method using email not HTML5 ready?

2014-01-29 Thread Niphlod
there are no HTML5 widgets whatsoever in web2py right now. On Wednesday, January 29, 2014 4:41:37 PM UTC+1, Jim S wrote: > > I have an app that is using the standard web2py login with NO username. > Therefore people login with an email address. When the INPUT element gets > created for the em

[web2py] Re: Examples of customizing SQLFORM.grid add/edit/view screens?

2014-01-29 Thread Jim S
So, do you want to modify the layout of the add/edit forms, or just default in the COMPANY on an add? this line:I see formargs, editargs, createargs, etc., but am having trouble finding examples (that I understand) of how to modify these forms and not recreate the wheel by making totally cu

[web2py] Re: Email and PGP

2014-01-29 Thread horridohobbyist
Yes, I can successfully sign a txt file. Works like a charm. So this means my key files are good, right? Thanks. On Wednesday, 29 January 2014 11:05:18 UTC-5, szimszon wrote: > > Can you sign some txt from command line with web2py's user? > > gpg --sign --default-key my_h...@gmail.com x.txt > >

[web2py] Re: ajax_error_500

2014-01-29 Thread Annet
Hi Paolo, Thanks for your reply. I'll leave it the way it is, I just wondered why. Annet -- 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 t

[web2py] Re: Pattern-based Application-Specific URL rewrite basic example?

2014-01-29 Thread User
Happy to say this is now working. One thing I was wondering is if the application specific url rewriting could route at the root level or not (e.g. route www.example.com/someapp/default/contat to www.example.com/contact) or if it was limited to having an app prefix (e.g. only route www.example

[web2py] Examples of customizing SQLFORM.grid add/edit/view screens?

2014-01-29 Thread A36_Marty
I've created a web2py grid of records based on the selection on the page. i.e. a table COMPANY has many EMPLOYEES -- someone selects a given COMPANY and a SQLFORM.grid of the related EMPLOYEES is shown. Question: How can I customize the web2py Add/Edit forms that appear when the respective b

[web2py] Re: Error when logging in

2014-01-29 Thread Leonel Câmara
I had this problem only if running web2py under apache/mod_wsgi/windows and if I had more than one web2py instalation. I tried to track it down and managed to make it somewhat less likely to happen. I ended up just migrating to Linux+nginx and uwsgi. -- Resources: - http://web2py.com - http://

[web2py] Re: Email and PGP

2014-01-29 Thread horridohobbyist
It says "gpg: gpg-agent is not available in this session". What does that mean? On Wednesday, 29 January 2014 11:05:18 UTC-5, szimszon wrote: > > Can you sign some txt from command line with web2py's user? > > gpg --sign --default-key my_h...@gmail.com x.txt > > > ? > > 2014. január 29., szerda

[web2py] Re: Email and PGP

2014-01-29 Thread szimszon
Can you sign some txt from command line with web2py's user? gpg --sign --default-key my_han...@gmail.com x.txt ? 2014. január 29., szerda 16:12:43 UTC+1 időpontban horridohobbyist a következőt írta: > > It says "expires: never" and "trust: ultimate" and "validity: ultimate", > and "usage: SC"

[web2py] Re: Email and PGP

2014-01-29 Thread szimszon
You must have a public key for the recipient. Web2py can send only encrypted mails if the recipient's public key is known. 2014. január 29., szerda 16:12:43 UTC+1 időpontban horridohobbyist a következőt írta: > > It says "expires: never" and "trust: ultimate" and "validity: ultimate", > and "us

[web2py] Default Login method using email not HTML5 ready?

2014-01-29 Thread Jim S
I have an app that is using the standard web2py login with NO username. Therefore people login with an email address. When the INPUT element gets created for the email address on the login form, the type is set to "text". Can we get that changed to "email" so keyboards on tablets/phone will

[web2py] Re: Email and PGP

2014-01-29 Thread horridohobbyist
It says "expires: never" and "trust: ultimate" and "validity: ultimate", and "usage: SC" for "pub" and "usage: E" for "sub". Looks good, I think. Just for the purpose of testing, I want to do one thing at a time. So first, I want to send an encrypted email. I don't care whether the receiver can

[web2py] Re: Email and PGP

2014-01-29 Thread szimszon
It could be that the key is not trusted. What is the status of the key if you look at: gpg --edit-key my_han...@gmail.com you can mark it as trusted with the trust command at gpg's cli. As I see in pgpme the problem is that there is no *suitable* key for signing rater than no key at all. Firs

[web2py] Re: Error when logging in

2014-01-29 Thread guruyaya
U. anyone? On Tuesday, January 28, 2014 10:37:13 AM UTC+2, guruyaya wrote: > > Hi friends. > I have a problem some time with one of the instances of web2py I have. > It's running using wsgi on apache, using web2py version 2.8.2. > For some unexplained reason, when I try to log in, using a reg

Re: [web2py] Unable to acces admin app in production

2014-01-29 Thread Richard Vézina
Make a clean update : package your app clear web2py install the new version set permissions on folder correctly then install your app see if it works, patch it if not and update the web2py files inside your app... :) Richard On Tue, Jan 28, 2014 at 7:54 PM, Julien Courteau wrote: > Yes I did a

[web2py] Re: Email and PGP

2014-01-29 Thread horridohobbyist
Absolutely. The private (and public) keys are there for "my_han...@gmail.com". Re: the receiver's public key, where do I put it and how do I incorporate it into the code that sends the email? (Excuse me for not understanding how PGP email works.) This second question is lower priority. Right no

[web2py] Companies and Startups that use WEB2PY

2014-01-29 Thread Francisco Costa
List of some Companies and Startups that use Web2py: https://angel.co/web2py-1 -- 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 message

[web2py] Re: ajax_error_500

2014-01-29 Thread Paolo Valleri
It is defined into web2py_ajax.html; it is used by web2py.js to notify an user when an error occurs. It was placed into web2py_ajax.html in order to translate the error message. You can freely move it in web2py.js but you will not be able to translate that string. The same thing is applied to 'w

[web2py] MSSQL binary(1024) field truncated to length of 255

2014-01-29 Thread Oleg Marin
Hi! I'm using MSSQL 2008, and when I run stored procedure with executesql, among other it returns field of type binary(1024) truncated to length of 255. Pyodbc directly works well. Is it a bug? Or maybe I have missed something? -- Resources: - http://web2py.com - http://web2py.com/book (Docum

[web2py] binary(1024) field truncates to 255

2014-01-29 Thread Oleg Marin
Hi! I'm using MSSQL2008 in readonly without tables definition, and when I run stored procedure with executesql, it returns field of type binary(1024) truncated to size of 255. Running same procedure directly with pyodbc works well. Is it a bug, or something I have missed? -- Resources: - htt

Re: [web2py] simplejson and datetime

2014-01-29 Thread Ricardo Pedroso
On Wed, Jan 22, 2014 at 3:31 PM, Arnon Marcus wrote: > What I am interested in doing, is have it turned back into a datetime object > when 'decoding' - and THAT is not supported even in the web2py flavor - and > I haven't found a single simple solution for it on the web for the standard > simplej

[web2py] Re: Selects as_trees

2014-01-29 Thread Alan Etkin
> > I am looking for a way to expand all referenced fields and have read about > the as_trees() method for selecting rows. I do not quite understand the > parent field requirement, but say we have the following > tables/relationships, was looking for a nested dict output which could be > JSONi

[web2py] ajax_error_500

2014-01-29 Thread Annet
While debugging an issue in Firefox 26.0 I noticed in the DOM tab that every Web2py page has an ajax_error_500 "An error occured, please reload the page" I wonder why. Kind regards, Annet -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/we

[web2py] Re: _link args

2014-01-29 Thread Annet
Hi Anthony, Thanks for your reply. {{=_name.replace('_', ' ').capitalize()}} .. works. Kind regards, Annet -- 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 Issue

Re: [web2py] Re: Wiki.auth 401 error

2014-01-29 Thread Alan Etkin
> > Any chance for steps on how to do that ? (For us that are new o web2py) > - Start the rocket built-in server (see the manual for instructions for windows) - Open the admin app and authenticate - Go to the app base address at http://localhost:8000/ and register web2py should now have creat

[web2py] Re: Is there a way to cache images from "download" function?

2014-01-29 Thread Niphlod
server-side it doesn't make any sense, so there's no native way to do it. It's not going to be faster than serving a static-file. On Wednesday, January 29, 2014 12:53:00 AM UTC+1, James Burke wrote: > > I'm exploring options. > > I want to be able to cache my images. Client side, server side it

[web2py] Re: caching TAG()

2014-01-29 Thread Anthony
Please show your exact code. The code I have shown works as expected. Anthony On Wednesday, January 29, 2014 1:45:03 AM UTC-5, Calvin wrote: > > Yes-you are right. I had meant XML object, but the issue still persists. > Even with the XML() function wrapping the cache output, the output rendered

[web2py] Re: Querying rows over several many-to-many tables.

2014-01-29 Thread Niphlod
why the hassle of using joins like those ones ? If you're not fond of searching through left joins, and you still want your whole dataset "consistent", and a search "a-la-fulltext".better do something like this whole_set = ( (db.person.id == db.clothing_person.person_id) & (db.clot

[web2py] Re: Email and PGP

2014-01-29 Thread szimszon
If you list your private keys is there a key for 'my_han...@gmail.com'? (gpg --list-secret-keys) And yes you need to have receiver's public key before you could send encrypted messages to him/her. 2014. január 28., kedd 22:27:44 UTC+1 időpontban horridohobbyist a következőt írta: > > GnuPG see