[web2py] Re: Argument problem with left join

Anyone can help with this? Trying to update web2py again but still having this same problem. Any left join in this oracle db get this type of error. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.c

[web2py] Argument problem with left join

I'm trying to move an app from a old version of web2py (2.14) to latest version. After updating some code i'm stuck on the error below. If i remove the left join the query works. And I dont find anything about changes on 'left' syntax. Someone knows whats wrong? left_join() takes exactly 2 a

Re: [web2py] Re: Legacy table with reserved keyword in column name

Wow, thanks! The rname parameter of Field solved the problem. 2017-10-27 6:14 GMT-02:00 Nico de Groot : > No, that just changes how the DAL checks for conflicts with reserved SQL > words. It depends on the backend which words are problematic. See the book. > If you really want to use a reserved

[web2py] Legacy table with reserved keyword in column name

Hi! How to put in the DAL a legacy table whose column name matches reserved SQL words? Traceback: SyntaxError: invalid table/column name "Message" is a "ALL" reserved SQL/NOSQL keywor thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2p

Re: [web2py] Re: HTML5 widgets on SQLFORM.factory

Great Anthony! Field('year', 'integer', label='Year', widget=lambda f, v: SQLFORM.widgets.string.widget(f, v, _type='number' )) worked perfectly! Thanks! 2017-09-11 19:59 GMT-03:00 Anthony : > On Monday, September 11, 2017 at 4:30:40 PM

[web2py] HTML5 widgets on SQLFORM.factory

Hi @ll! How to use HTML5 widgets on SQLFORM.factory? I have this peace of code: form = SQLFORM.factory(Field('year', 'integer', label='Year')) I like use this HTML5 input type="number" widget. Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.c

[web2py] How to install NLTK?

Hi all, How to install NLTK on web2py? Thanks, Fabiano. -- 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 because you are

[web2py] Rocket server crashing with socket error

environment: Debian 7.11; python 2.7.3; web2py 2.14.5 running on rocket background: An application that have many clients periodically sending data, some are http posts some others json. About 2 month ago it started to eventually throwing this error on console: 2017-08-01 15:50:37,966 - Rocket

[web2py] Re: web2py crashing

I got too many of this error lately. And its getting worse every day. I have no idea what to do to stop these errors. I have to reset rocket every few hours. Was this fix eventually reverted ? Someone knows the file it is this workaround? -- Resources: - http://web2py.com - http://web2py.com/

Re: [web2py] Sites Powered by web2py

Thanks Alex! 2017-04-05 11:43 GMT-03:00 Alex : > Thanks Fabiano. > > Each subdomain refers to an own application, each with it's own database > since the breeds are not related to each other. > > Alex > > On Wednesday, April 5, 2017 at 2:52:00 AM UTC+2, Fabiano

Re: [web2py] Sites Powered by web2py

Hi Alex! Great design ! Congratulations! I see use of subdomain to breeds, how do you do it? thx, Fabiano. 2017-04-02 17:58 GMT-03:00 Alex : > The section for "Sites Powered by web2py" does not look very promising and > also seems outdated. Most pages don't have a screen

Re: [web2py] Re: edit or delete child or detail table on SQLFORM.grid with left join

Thanks Massimo, I will try this. 2017-03-20 11:41 GMT-03:00 Massimo Di Pierro : > Unfortunately not out of the box. You need a custom button that does a > ajax query. > > > On Friday, 3 March 2017 17:52:30 UTC-6, 黄祥 wrote: >> >> is it possible to edit or delete child or detail table on SQLFORM.gr

[web2py] Radius Authentication

Hi All! Is it possible to authenticate web2py users through the freeradius server? Thx -- 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

Re: [web2py] Re: Open Sourced dating website

Wow! Thanks for sharing! New ideas! New features! Thanks a lot and best regards! Fabiano 2017-02-26 21:03 GMT-03:00 Jaimee S : > Yea, dude. There definitely aren't ‎many new ideas under the sun so its > always best to find one and improve it a little. > > David Shaver

Re: [web2py] Re: Non-Editable field in SQLFORM

db.table.field.writable = False -> don't write db.table.field.readable = False -> don't show (hide) 2016-12-12 14:17 GMT-02:00 lyn2py : > It will always be allowed to take a value in insert, a value that you > assign it to, for example, via "default", like so: > db.table.field.default = some_val

[web2py] treat url error

How to capture and treat the url before displaying error? For example, the User entered the url with a controller that does not exist, and the application takes the url points to an existing controller for any action to be done. Thanks, Fabiano. -- Resources: - http://web2py.com - http

Re: [web2py] WEB2PY Creating Controls Dynamically

Hi! See http://www.web2pyslices.com/slice/show/1724/cascading-dropdowns-simplified 2016-05-25 14:43 GMT-03:00 Venkat : > Hi > > I have a requirement of displaying data from database from 4 tables i used > join to pull all the data but i should display that data in dropdown for > each column, h

[web2py] Re: Downloading from "private" folder

's own way when needed.. Fabiano. On Thursday, June 24, 2010 at 9:30:31 AM UTC-3, mdipierro wrote: > > My convention is: > > static: files that are public > uploads: files that are uploaded into the system and may be subject to > access control > private: files tha

Re: [web2py] Re: random generator of stupid pages

Great work! 2016-03-07 3:24 GMT-03:00 Dave S : > On Sunday, March 6, 2016 at 8:49:15 PM UTC-8, Massimo Di Pierro wrote: >> >> http://mdipierro.github.io/stupid.css/themes/random.html >> > > > Nice! Thank you! > > /dps > > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Docume

Re: [web2py] custom form no submiting

ame .label}} {{=form.custom.widget.middle_name}} {{=db.stud_person.last_name .label}} {{=form.custom.widget.last_name}} {{=form.custom.submit}} {{=form.custom.end}} Fabiano. 2016-03-03 14:58 GMT-03:00 prashant joshi :

Re: [web2py] Re: How to install web2py on CentOS 6.5 with Apache?

ou have to sign-in. > > I think You have to checkscripts/setup-web2py-centos7.sh > > good lock > > > El viernes, 19 de febrero de 2016, 9:48:59 (UTC-5), Fabiano Almeida > escribió: >> >> Hi all, >> >> How to install web2py on CentOS 6.5 wi

Re: [web2py] Re: Rich Text

Thanks Leonel! 2016-02-24 7:33 GMT-03:00 Leonel Câmara : > Use Tim's plugin it works great > > https://github.com/timrichardson/web2py_ckeditor4 > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.

[web2py] Rich Text

Hi all, How field type is used to store rich text (with formatting, table, figure) in db? How to use ckEditor or other rich text editor in web2py? Thanks, Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code

Re: [web2py] Re: How to install web2py on CentOS 6.5 with Apache?

> -Jim > > > On Friday, February 19, 2016 at 8:48:59 AM UTC-6, Fabiano Almeida wrote: >> >> Hi all, >> >> How to install web2py on CentOS 6.5 with Apache? >> >> Tks! >> >> Fabiano. >> > -- > Resources: > - http://web2p

[web2py] How to install web2py on CentOS 6.5 with Apache?

Hi all, How to install web2py on CentOS 6.5 with Apache? Tks! Fabiano. -- 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

Re: [web2py] Re: A guide how to install your web2py app on your own server (using DigitalOcean droplets)

Great! Thanks for sharing! 2016-02-15 9:30 GMT-02:00 'M Bailey' via web2py-users < web2py@googlegroups.com>: > Wow just read your blog. Really useful, clear instructions - thank you. > > > On Monday, 15 February 2016 10:54:01 UTC, Dragan Matic wrote: >> >> Hey guys, I wrote a guide for beginners

Re: [web2py] Re: web2py included on Synology DSM

+1 2016-02-10 13:16 GMT-02:00 Ron Chatterjee : > +1 > > > On Wednesday, February 10, 2016 at 8:44:46 AM UTC-5, xmarx wrote: >> >> +1 >> >> 10 Şubat 2016 Çarşamba 15:32:24 UTC+2 tarihinde Gerd yazdı: >>> >>> Hi! >>> >>> I would like to see web2py as a package for the Synology NAS, so i wrote >>> a

Re: [web2py] Virtual field in SQLFORM.grid

Hi Marcello, Can you see your tables in appadmin? And your lambda, you can create and call function to count in konsulta's table and return the number. Field.Virtual('total', lambda row: kontagem(row.id)) Att., Fabiano. 2016-01-19 15:09 GMT-02:00 Marcello : > Hello, &

Re: [web2py] Re: multi tenant

Great Massimo! Thanks a lot! Fabiano. 2016-01-17 23:00 GMT-02:00 Massimo Di Pierro : > That URL structure assumes you have a single app running at the domain. So > I am going to assume that is the case. > > first of all you have to map the tenant name ($domain) into > reques

Re: [web2py] Re: web3py

2016-01-15 17:29 GMT-02:00 Carlos Cesar Caballero Díaz < desarro...@spicm.cfg.sld.cu>: > Hi, I have written about my opinion before. The backward compatibility > should never affect the system maintenance, sometimes is better just remove > the old functionalities to make way for the new ones, the

[web2py] multi tenant

env.http_host,writable=False)) Seeing commercial sites that use the concept of multi-tenant offices, the url is usually www.domain.com/, and the code that differs from another tenant. It can deploy this type of multi-tenant access in web2py? how? thanks, Fabiano. -- Resources: - ht

Re: [web2py] Re: what is difference between ajax() and web2py_component() ?

Great! Can you show me examples of using web2py_component? thanks! Fabiano. 2016-01-07 13:57 GMT-02:00 Anthony : > The ajax() function provides basic functionality for making an Ajax > request, with some additional features, such as automatically sending > values from named input f

[web2py] Re: Role of users

for g in users_and_groups.select(db.auth_group.role, orderby=db.auth_membership.group_id): groups.append(g.role) # [...] Em quarta-feira, 2 de dezembro de 2015 14:31:14 UTC-2, Fabiano Almeida escreveu: > > Hi! > > I'm trying to create a list of roles for each user: >

[web2py] Re: Role of users

Hi Anthony! The auth.user_groups.value() is only for logged user or I can define user id to get for all users? Thanks! Fabiano Em quarta-feira, 2 de dezembro de 2015 14:47:50 UTC-2, Anthony escreveu: > > The roles for a user are stored as a dictionary in auth.user_groups, with >

[web2py] Role of users

uth_user.on(db.auth_user.id==db.auth_membership.user_id)]): groups.append(g.role) and the error: TypeError: reduce() of empty sequence with no initial value How to do this list? thanks, Fabiano -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/we

Re: [web2py] Re: record versioning

> > See > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Combining-rows > . > > Anthony > > > On Monday, November 30, 2015 at 12:31:46 PM UTC-5, Fabiano Almeida wrote: >> >> Hi All! >> >> I need create a repor

[web2py] record versioning

Hi All! I need create a report with record versioning. How to union table with table_archive? Thanks! -- 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) --- Yo

Re: [web2py] Re: new connection string in scaffold

thanks! 2015-11-13 23:13 GMT-02:00 黄祥 : > please take a look at appconfig.ini file in private folder and change the > uri value with your own settings : > e.g. > private/appconfig.ini > [db] > uri = mysql://MySQLUser:MySQLPassword@MySQLHost/MySQLDatabase > > best regards, > stifan > >> -- >

[web2py] new connection string in scaffold

Hi all, I will create a new app in web2py 2.12.3, and I see: db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size', cast=int), check_reserved=['all']) How to configure this to connect with remote mysql database ? Thx! Fabiano -- Resourc

[web2py] Indexes

Hi All! In book <http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=indexes#Indexes> I see example how to create index with executesql . How to use indexes in querys? Thx, Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documen

Re: [web2py] its possible get mac address?

Hi All! Got it. If the server and client are on the same network, including the web2py it is installed on the network server. How to get the mac address by ARP? Thanks again, Fabiano. 2015-11-04 21:40 GMT-02:00 Dave S : > > On Wednesday, November 4, 2015 at 11:58:07 AM UTC-8, Carlos

[web2py] its possible get mac address?

Hi! Web2py can obtain mac address from user? Thanks in advance, Fabiano. -- 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] How to filter table data in field of SQLFORM.factory?

ser.id)) need show only db.auth_user.id == auth.user.id Thx, Fabiano. -- 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 because you are subscr

[web2py] Re: How to show query on a grid?

Delete the db before ((db.guest.id>0)... worked query = ((db.guest.id>0) & \ > (db.voucher.disp == False) & \ > (db.voucher.guest == db.guest.id) & \ > (db.auth_user.id == db.guest.fnd)) \ > .select(db.voucher.voucher, db.guest.name, db.auth_user.id , > db.auth_user

[web2py] How to show query on a grid?

(db.auth_user.id == db.guest.fnd)) \ .select(db.voucher.voucher, db.guest.name, db.auth_user.id , db.auth_user.first_name, db.guest.dia) form = SQLFORM.grid(query) How to show query on a grid? thx in advance, Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation

Re: [web2py] Re: qrcode

Hi Michael, 2015-10-14 16:00 GMT-03:00 Michael M : > {{=XML(img_tag)}} It worked! Grateful for all! Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Rep

Re: [web2py] Re: qrcode

Hi Richard, elaphe worked! thank you! How to show a text message with qrcode on same page? Thx 2015-10-13 21:07 GMT-03:00 Richard Vézina : > You can have a look on the side of elaphe : > https://bitbucket.org/whosaysni/elaphe/ > > For most type of code it works... But there were issue with bou

Re: [web2py] Re: qrcode

et the string > img_tag = '' % > output.getvalue().encode('base64').replace('\n', '') > return locals() > > > On Tuesday, October 13, 2015 at 2:05:23 PM UTC-7, Fabiano Almeida wrote: >> >> Hi all! >> >> How to dyn

Re: [web2py] Re: qrcode

Hi Niphlod, I trying to generate qr code with built-in feature, for local use, mobile for reading. thx 2015-10-13 18:20 GMT-03:00 Niphlod : > with any qrcode library or qrcode ondemand service out there ? What did > you try ? > > > On Tuesday, October 13, 2015 at 11:05:23 PM

Re: [web2py] Re: qrcode

Hi Stifan I installed the semanticwebexample and not found reference to qr code on it. thx 2015-10-13 18:28 GMT-03:00 黄祥 : > i think there is web2py appliances that create some thing like this before > : semanticwebexample > > best regards, > stifan > > -- > Resources: > - http://web2py.com > -

[web2py] qrcode

Hi all! How to dynamically generate qr code in web2py? grateful, Fabiano. -- 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] Authenticate with Radius Server

Hi @ll! I have an pfSense server with FreeRadius. Can I log in web2py app with users from FreeRadius? How? thx! -- 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] To display random questions one by one

s,1) ## how to query your question question=db(db.ins_ques.id == i).select(db.ins_ques.ALL).first() [...] Fabiano. 2015-07-28 5:51 GMT-03:00 Sai Harsh Tondomker : > I have trying to display random question for every login (Means client get > different questions for every login). > Here I g

Re: [web2py] Re: module vs plugin

mple would be: Lets say you are selling a base product to all > your customer at a price X. Now, based on customer requirement, specify > features/plugins can be added or attached to this base system. > > > > Regards, > Vikash Sharma > vikash0...@gmail.com > > On Wed

Re: [web2py] Re: module vs plugin

Hi Anthony, I think add plugins to build a system. Eg customer registration, product registration, shopping trolley, service order, reports, etc. thks Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] module vs plugin

Hi @ll! I think about modularize my aplication. Then the question is: module or plugin? What's the difference? Thanks! Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/i

Re: [web2py] Re: does every controller function require a view?

or init function name with double underscore: def __test(): pass the __ make function usable in your code, but not visible in browser. Fabiano. 2015-06-23 15:30 GMT-03:00 Niphlod : > if you plan to use functions in controllers that MAY NOT be seen by users, > just define them

[web2py] Convert picture to pdf

Hi! It's possible convert one or many pictures in unique pdf file in web2py? USer select one or more pictures stored in app and download a pdf file with selected images. Thanks, Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/w

[web2py] Re: Error background task with Redis

rt.py", line 85, in custom_importer modules_prefix, globals, locals, [itemname], level) ImportError: No module named modules Em terça-feira, 16 de junho de 2015 14:03:42 UTC-3, Fabiano Faver escreveu: > > I have tried to follow this tutorial: > http://www.web2pyslices.com/sli

[web2py] Error background task with Redis

I have tried to follow this tutorial: http://www.web2pyslices.com/slice/show/1579/web2py-and-redis-queue Just changed the arguments in the enqueue function to be fixed: def contato(): form = SQLFORM.factory(Field("name"), Field("message")) if form.accepts(request): # enqueue the e

Re: [web2py] Re: How to register custom events in auth_event?

Great! Thanks a lot! Fabiano. 2015-06-11 15:56 GMT-03:00 黄祥 : > please take a look at this discussion : > https://groups.google.com/forum/#!topic/web2py/sp4fpYz36HI > > best regards, > stifan >> >> -- > Resources: > - http://web2py.com > - http://web2

[web2py] Re: How to register custom events in auth_event?

origin = '' description='' db.auth_event.insert(time_stamp=request.now, client_ip=request.client, user_id=auth.user.id, origin=origin, description=description) Em quinta-feira, 11 de junho de 2015 13:20:29 UTC-3, Fabiano Almeida escreveu: > > Hi @ll! >

[web2py] How to register custom events in auth_event?

Hi @ll! After performing a specific operation system, I need the record in auth_event. How to do? thanks in advance, Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues

[web2py] Re: caching model data

Niphlod, I have a small app the DB is getting big quickly and was asked to do a cache layer..I just started started to learn about it and i'm already lost. Could you point the direction to a newbie how to do it? Is it just some code change in web2py? I saw there is this Redis but didn't read ye

[web2py] Redirect page after submit load form

def function3(): form = SQLFORM.factory(...) if form.accepts(request,session): (...code...) redirect(URL('default', 'index') elif form.errors: response.flash="Try again" else: response.flash="Please, fill the for

Re: [web2py] foreign key constraint failed

If your table definitions are right, try delete database and run your app again... 2014-09-22 18:01 GMT-03:00 Anna Kostikova : > Hi everyone, > > I am having an issue when editing content of one of the tables in my > database. When I try to edit a record in the table I have an error message > " f

Re: [web2py] SQLFORM.factory fails to save to database, id is null

try: db.table.insert(f_name=form.vars.f_name) 2014-09-23 6:10 GMT-03:00 Andy Joel : > I have a very simple form processing page in my controller: > > def new(): > form = SQLFORM.factory( > Field('f_name', label='Your name', requires=IS_NOT_EMPTY()), > ) > if form.process(

Re: [web2py] Recompute all instances of a computed field

Hi Johann, I recently update manually compute field. You have presented a better way, and still counter to monitor the process. Very nice! Congratulations! Fabiano. 2014-07-10 10:39 GMT-03:00 Johann Spies : > Sorry, I sent it before finishing > > > #!/usr/bin/python > # -*

Re: [web2py] Re: Virtual Fields in auth_user?

ct has no attribute 'dept_name' Can I use virtual field to display information from another table? Thanks, Fabiano. 2014-07-10 3:55 GMT-03:00 Massimo Di Pierro : > auth.settings.extra_fields['auth_user'] = [Field.Virtual(), ... ] > > > On Wednesday

Re: [web2py] Re: How to mark mandatory fields in SQLFORM.grid?

Hi Anthony, Great plugin! Thanks, Fabiano. 2014-07-09 18:15 GMT-03:00 Anthony : > There is also this plugin, which automates the process based on field > validators: http://dev.s-cubism.com/plugin_notemptymarker > > Anthony > > > On Wednesday, July 9, 2014 5:12:57 PM

[web2py] How to mark mandatory fields in SQLFORM.grid?

Hi @all! I am using SQLFORM.grid extensively in my application. How to visually mark the required fields on the form when the user adds record? Thanks in advance, Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Virtual Fields in auth_user?

Hi again, It's possible insert virtual field in auth_user? how? thanks, Fabiano. -- 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

Re: [web2py] Re: help with join

Great Leonel! Thanks a lot! Fabiano. 2014-07-09 13:31 GMT-03:00 Leonel Câmara : > list_of_users_in_all_groups = db( (db.auth_membership.group_id.belongs([2, > 3, 4])) & (db.auth_membership.userd_id == db.auth_user.id) > ).select(db.auth_user.ALL) > > -- > Resources:

[web2py] help with join

Hi, I'm trying to do a join table auth_user and auth_membership. I need the list of users with membership.group_id in [2,3,4]. I tried to create a query for membership before the join, but it did not work. Is to make this join? How? Thanks in advance, Fabiano. -- Resources: -

Re: [web2py] Re: query with multiple values

Hi Leonel, belongs solve my question. Thanks. Fabiano. 2014-07-09 13:02 GMT-03:00 Leonel Câmara : > q = db(db.auth_membership.group_id.belongs([2,3,4]).select() > > Also see: > > http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#belongs >

Re: [web2py] query with multiple values

Hi Vinicius, I tested it contains, but it did not work with integer field. Thanks, Fabiano. 2014-07-09 12:55 GMT-03:00 Vinicius Assef : > Use contains [1]. > > [1] > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#like--regexp--startswith--endswi

Re: [web2py] Re: SQLEDITABLE: redirect after submit

Thanks Kato! Fabiano. 2014-07-09 9:24 GMT-03:00 'kato' via web2py-users : > I was a little wrong. If you want to redirect, and will not work because > such in the ajax. > Please write as the following. > > def demo050(): > response.title = &

[web2py] query with multiple values

Hi, How to make a query with multiple values to field? q = db(db.auth_membership.group_id in [2,3,4]).select() thanks, Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p

Re: [web2py] Re: SQLEDITABLE: redirect after submit

Hi Kato, Thanks again!! Fabiano. 2014-07-09 8:52 GMT-03:00 'kato' via web2py-users : > Hi. > > You can write same as SQLFORM. > > example. > def demo070(): > response.title = 'demo070' > response.view = 'plugin_sqleditable/sample.htm

Re: [web2py] Re: SQLEDITABLE: redirect after submit

Hi Samurai, I tried other way: use 2 buttons: sqleditable submit to save grid, then a second button to process new data and redirect to other page. I think this is not the best way... Fabiano. 2014-07-09 5:33 GMT-03:00 samurai : > If u have got the answer then please share with us a

[web2py] SQLEDITABLE: redirect after submit

Hi, Has like 'accepted' attribute in SQLEDITABLE? I need redirect to other page after 'ok' click. Thanks, Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py

[web2py] Re: SQLEDITABLE : writable=False dosen't work

Sorry, my fault I configured writable = False for wrong field o.O thanks, Fabiano. Em terça-feira, 8 de julho de 2014 18h16min06s UTC-3, Fabiano Almeida escreveu: > > Hi!, > > I'm trying to use SQLEDITABLE plugin with readable and writable attributes. > > readable

[web2py] SQLEDITABLE : writable=False dosen't work

Hi!, I'm trying to use SQLEDITABLE plugin with readable and writable attributes. readable = False, hide the field. OK. writable = False, the field remains editable. How to leave only a few editable fields? Thanks, Fabiano. -- Resources: - http://web2py.com - http://web2py.com

Re: [web2py] SQLEDITABLE plugin

ble=editable) > > If you use "primarykey" and multiple key fields, you need to write list of > list in "record" parameter. > > > 2014-07-07 5:51 GMT-03:00 'kato' via web2py-users >: > >> Hi fabiano. >> >> It is not po

Re: [web2py] SQLEDITABLE plugin

How to filter table? Thanks, Fabiano 2014-07-01 10:12 GMT-03:00 'kato' via web2py-users : > Hi. > > I tried to make SQLEDITABLE plugin. > > demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html > > It is similar as gluon/contrib/spreadsheet. But, it is ea

Re: [web2py] How to choose a subcategory to create a post

Can you try use plugin: http://dev.s-cubism.com/plugin_lazy_options_widget 2014-07-03 6:53 GMT-03:00 Капылов Данил : > 1) Post created in a particular category. - > http://hostname/app/default/created_ad/ > > 2)The category tied subcategories. > > How to make that SQLFORM display only radio butt

Re: [web2py] create an update page (similar to profile page in default application)

Need convert request to int: int(request.post_vars.pid) Fabiano. 2014-07-02 8:05 GMT-03:00 Shubham Jain : > I want to create an update page just like profile page in default > application. Actually I am passing the primary key of a table by a button > click to the product_update pag

Re: [web2py] SQLEDITABLE plugin

Very Nice! Thank you very much! 2014-07-01 10:12 GMT-03:00 'kato' via web2py-users : > Hi. > > I tried to make SQLEDITABLE plugin. > > demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html > > It is similar as gluon/contrib/spreadsheet. But, it is easy to use more. > If you are inte

Re: [web2py] Re: lambda cannot contain assignment

Hi Anthony, It worked! Now I understand better how to use callback. Thank you very much!! Fabiano. 2014-06-12 16:13 GMT-03:00 Anthony : > lambda qset, f: > f.update(cadastro=request.now if f['status'] in ['Edição', 'Enviado'] > else None) --

[web2py] lambda cannot contain assignment

: f.cadastro=request.now if (f.status == 'Edição') or (f.status =='Enviado') else None) Thus returns the message "*lambda cannot contain assignment*" Any suggestions? Thanks in advance, Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentati

Re: [web2py] Uploading a Package

Hi, If you have application in tgz, unpack and copy to web2py_folder/application/your_application. 2014-06-10 6:26 GMT-03:00 Priyank Yadav : > Hello, > I am new to web2py. Somebody sent me a tgz file which contained the source > code. > I am trying to upload thar code in my admin interface but

Re: [web2py] create a link SQLFORM to another table with id.belongs

Hi, Good! db.table1.id.default = session.table1.id > This line is used to insert new record automatically by SQLFORM. For the id field is unnecessary, it is useful when you want to set a default value, eg FK. All beers!! -- Resources: - http://web2py.com - http://web2py.com/book (Documentatio

Re: [web2py] create a link SQLFORM to another table with id.belongs

'%(nome)s') 2014-06-09 17:09 GMT-03:00 LoveWeb2py : > Hi Fabiano, > > I'm still trying to get this > > For your Objeto.almoxarifado_id.default = session.almoxarifado > > Shouldn't there be a db.Objeto.almoxarifado_id ? If I try to just put > t

Re: [web2py] create a link SQLFORM to another table with id.belongs

=db.table1.id.belongs(joined_records) db.table1.id.default = session.table1_id grid=SQLFORM.grid(query, user_signature=False) return dict(grid=grid) 2014-06-09 17:09 GMT-03:00 LoveWeb2py : > Hi Fabiano, > > I'm still trying to get this > > For your Objeto.alm

Re: [web2py] create a link SQLFORM to another table with id.belongs

.almoxarifado_id > > > On Monday, June 9, 2014 1:30:49 PM UTC-4, Fabiano Almeida wrote: > >> Hi, >> >> Sorry for my poor english, by lazy, sometimes I use google translate >> (portuguese -> english), and don't check the translation. >> >> table1_in

Re: [web2py] Re: Adding information to certain input before added to db?

Other way is before and after callbacks http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#before-and-after-callbacks If necessary, you can call function: db.table1._before_insert.append( lambda f: my_function(f)) This way you do not need to manually enter the registry

Re: [web2py] create a link SQLFORM to another table with id.belongs

alm) > *session.almoxarifado*=alm# this line executes only if the > previous line no error > except ValueError: > pass > Objeto.almoxarifado_id.default = *session.almoxarifado* 2014-06-09 13:47 GMT-03:00 LoveWeb2py : > Hi Fabiano, > > Thank you for you

Re: [web2py] create a link SQLFORM to another table with id.belongs

y...except to resolve this. 2014-06-06 15:29 GMT-03:00 Fabiano Almeida : > Show your code > > > 2014-06-06 15:18 GMT-03:00 LoveWeb2py : > > Now I get this error when I try to click edit on the query database: >> >> invalid literal for int() with base 10: >>

Re: [web2py] create a link SQLFORM to another table with id.belongs

problem. > > > On Friday, June 6, 2014 1:17:39 PM UTC-4, LoveWeb2py wrote: > >> yes >> >> >> On Fri, Jun 6, 2014 at 1:09 PM, Fabiano Almeida >> wrote: >> >>> Are you logged in your app? >>> >>>> >>>&

Re: [web2py] create a link SQLFORM to another table with id.belongs

Are you logged in your app? 2014-06-06 14:07 GMT-03:00 LoveWeb2py : > That was it! THANK YOU! Why does it work without a signature though? > > > On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote: >> >> Try: >> >> grid = SQLFORM.grid(db.table,

  1   2   >