Re: [web2py] Do not mask password field

2014-06-14 Thread Kenneth
Thank you Marin, that did it. Rob, the form is for creating new users and client complains about not seeing the password. Kenneth Den lördagen den 14:e juni 2014 kl. 01:31:15 UTC+3 skrev Marin Pranjić: Can you try if this works? db.auth_user.password.type = 'string' On Sat, Jun 14,

[web2py] orderby / case

2014-06-14 Thread Kenneth
Hi, I have a table that contains 5 items. Usually I order them by product name. Now I'd like to order them so a specific ID is first and then the rest. As everything else is ready I'm looking into making the SQL query do the ordering. I found a posting (

Re: [web2py] Re: How to use requires with list:reference

2014-06-14 Thread Mandar Vaze / मंदार वझे
This is brilliant !! Thanks a LOT Anthony What I ended up doing is : if request.args(0) == edit: db.child.parent.requires = IS_IN_DB(.) In my actual setup - user does not create new record - so new is not an issue *for me*. -Mandar On Thu, Jun 12, 2014 at 4:57 PM, Anthony

[web2py] How do I use getattr in web2py

2014-06-14 Thread Maurice Waka
http://stackoverflow.com/questions/24218339/how-to-use-getattr-in-web2py# My code: from applications.Folders1.modules.myfolder1.main import mainfrom applications.Folders1.modules.myfolder1.list1 import GAMES0 code. name3 = main() class Filters(object): def Filter_cause(self):

[web2py] Re: orderby / case

2014-06-14 Thread Niphlod
there's no simple way to do it. I'd suggest you fetch the first record, then every other record (ordered as you like) and then merge the resultsets. On Saturday, June 14, 2014 8:39:32 AM UTC+2, Kenneth wrote: Hi, I have a table that contains 5 items. Usually I order them by product name.

Re: [web2py] Do not mask password field

2014-06-14 Thread Niphlod
yep, and that's why the usual input type=password / works out of the box in mobiles just as you describe. If you want to replicate the same behaviour even for desktop browsers, you need to override the standard password input with your own. -- Resources: - http://web2py.com -

Re: [web2py] orderby / case

2014-06-14 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 14-06-2014 07:39, Kenneth escreveu: Hi, I have a table that contains 5 items. Usually I order them by product name. Now I'd like to order them so a specific ID is first and then the rest. As everything else is ready I'm looking into making

[web2py] Re: ERROR when MYSQL try to CAST() to LONGTEXT

2014-06-14 Thread Massimo Di Pierro
Yes. Is this sufficient? https://github.com/web2py/web2py/blob/master/gluon/dal.py#L2671 On Friday, 13 June 2014 12:25:15 UTC-5, André Kablu wrote: Sure. Did you pushed it? I cannot find it there... Many thanks! On Friday, June 13, 2014 1:45:44 PM UTC-3, Massimo Di Pierro wrote: I have a

[web2py] Re: Is there a method to force a user to change their password?

2014-06-14 Thread Massimo Di Pierro
I usually do this: for user in db(db.auth_user).select(): auth.email_reset_password(user) and it emails each of them a password reset link. On Friday, 13 June 2014 12:45:25 UTC-5, Michael Beller wrote: Thanks Massimo, Is there a method to force a user to change their password, e.g.,

[web2py] Re: orderby / case

2014-06-14 Thread Oli
try this copy the first part of the field in for example Orderfield1 and the second part of the field in for example Orderfield2. Then you can sort the result as you want. Original Field 01 A... 02 B... 03 C... Orderfield1 Orderfield2 01 A... 02 B... 03

[web2py] Loading random images with associated data from database

2014-06-14 Thread Ajeigbe Yekeen
Hello, I would like to build a page with images (and data) that constantly cycles through the corresponding information in the database. The idea is an homepage with a continually changing face for each user(or reload). I have this in my model: db.define_table( 'product',

[web2py] Trying to use the LOAD helper, if a button is clicked

2014-06-14 Thread Omri Levy
Hi , So I have a ticket system, and I want to allow user to edit the ticket without leaving the page. I don't want to LOAD the edit_page and hide it, but only load it once user is clicking on the ticket body. Another thing is, when user edits the ticket, he should again see changes on the same

[web2py] Unable to login on osx mavericks using postres

2014-06-14 Thread kammy smb
I keep getting this error when I try to login to my application: ('ERROR', 'XX000', 'constraint 28615 is not a foreign key constraint') Database is postgres What is strange is that I can access the database and from the administration site. I can access the application as long as I don't try to

[web2py] Re: Create other autoincrement field besides the id on MongoDB

2014-06-14 Thread Leonardo Tada
I understood, but have a way to make other field like auto-increment? Em domingo, 8 de junho de 2014 01h38min56s UTC-3, Massimo Di Pierro escreveu: If you use db = DAL('mongodb:...') tables get automatically an integer id field. It is not auto-increment and it is stored as a UUID by mongo.

[web2py] Re: Web2py with postgresql and DB triggers

2014-06-14 Thread Chris Farrar
Hi Massimo, I'm simply recording in another table that an insert has been made in the reorder table. Here's the full function: def oncreatereorderhandler(form): myid = form.vars.id newreorderrow = db.reorder(myid) #now do something with newreorderrow

Re: [web2py] Re: ERROR when MYSQL try to CAST() to LONGTEXT

2014-06-14 Thread Kablu®
Thanks Massimo! The fix is working fine! On Sat, Jun 14, 2014 at 12:39 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Yes. Is this sufficient? https://github.com/web2py/web2py/blob/master/gluon/dal.py#L2671 On Friday, 13 June 2014 12:25:15 UTC-5, André Kablu wrote: Sure.

[web2py] Re: orderby / case

2014-06-14 Thread Kenneth
Hi, is it possible to merge two resultssets so I have only one resultssets. That way I would only need to add an extra query. Kenneth Den lördagen den 14:e juni 2014 kl. 16:53:09 UTC+3 skrev Niphlod: there's no simple way to do it. I'd suggest you fetch the first record, then every

[web2py] Re: eStore appliance

2014-06-14 Thread LoveWeb2py
Did this ever materialize? I hate prestashop and would LOVE to use web2py as a replacement. On Friday, July 24, 2009 3:07:13 AM UTC-4, Benigno wrote: Hello Teru, I expect that if they develope something, it will certainly be an improvement over what is already in existance, and will

[web2py] Re: Loading random images with associated data from database

2014-06-14 Thread Francisco G. T. Ribeiro
{{product=db().select(db.product.ALL, orderby='random')[0]}} and change your variable names within the view accordingly. Francisco On Saturday, 14 June 2014 17:08:51 UTC+1, Ajeigbe Yekeen wrote: Hello, I would like to build a page with images (and data) that constantly cycles through the

[web2py] Re: Loading random images with associated data from database

2014-06-14 Thread Francisco G. T. Ribeiro
if you want 20 tiles in the same page, you can make: {{products=db().select(db.quotes.ALL, orderby='random')[:20]}} and then wrap your view code in a loop that goes through the all the selected products. Francisco On Sunday, 15 June 2014 03:36:52 UTC+1, Francisco G. T. Ribeiro wrote:

[web2py] Can I include wordpress plugin in web2py (e.g. woocommerce) ?

2014-06-14 Thread Sarbjit
Is it possible to include wordpress plugins in web2py? I want to use woocommerce (link http://demo2.woothemes.com/?name=superstore) theme (look and feel for web2py app). I saw that http://www.nammuhats.com/ is listed as being developed using web2py but this site seems to be using woocommerce

Re: [web2py] Can I include wordpress plugin in web2py (e.g. woocommerce) ?

2014-06-14 Thread Marco Mansilla
El Sat, 14 Jun 2014 22:11:24 -0700 (PDT) Sarbjit sarbjit1...@gmail.com escribió: Is it possible to include wordpress plugins in web2py? I want to use woocommerce (link http://demo2.woothemes.com/?name=superstore) theme (look and feel for web2py app). I saw that http://www.nammuhats.com/ is