Re: [web2py] Re: Application Issues After MySQL Database Update

gt; conn = self.driver.connect(**self.driver_args) >> File >> "/home/ubuntu/api_server/web2py/gluon/contrib/pymysql/__init__.py", line >> 90, in Connect >> return Connection(*args, **kwargs) >> File >> "/home/ubuntu/api_server/web2py/

Re: [web2py] py4web new docs

@Massimo, Thanks for sharing. On Sat, Nov 28, 2020 at 11:22 AM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > > https://py4web.com/_documentation/static/en/index.html > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2p

[web2py] Why web2py App performance has degraded all of sudden with SQLLITE

I do not see a solution to this problem . Can some one really help what is the solution to this Regards Sandeep sandeep.bon...@gmail.com -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p

Re: [web2py] py4web nw version and new example

Hello Martin, Three are a couple of ways to try the new version, You can create a new virtual environment and install the newest version by pip or if you want to update the version in exiting ENV so you can also update by using pip command. Thanks & Regards Sandeep On Mon, Feb 10, 2020 a

[web2py] I need a Training in Web2py

Hello I am looking out for a training for developing web app using we2py , I am a experienced IT professional but currently have started on my own , I need to upgraded myself with Web2py as this is the only framework i found less complex or confusing. However there are not many tutorials av

Re: [web2py] Re: Web2py survey ??

@ I agree with you. On Wed, 8 Jan, 2020, 6:27 PM Ari Lion BR Sp, wrote: > Good Idea > > Em quinta-feira, 26 de dezembro de 2019 13:23:54 UTC-3, Ramos escreveu: >> >> Hi all, i think that it could be important to question users about many >> things to be known by us all. >> I think it could serve

Re: [web2py] Re: py4web has now a grid ...

@Massimo, Grid not working properly, Only seeing a blank page. Please, Give me some direction. Thanks Sandeep On Mon, Sep 16, 2019 at 2:49 AM isi_jca wrote: > Hi! > > This is output from console and the browser is Google Chrome Versión > 66.0.3359.181 (Build ofici

Re: [web2py] Re: Unable to add auth.signature in table - PY4WEB

Massimo, Thanks a lot. Now it's working fine. Thanks Sandeep Patel On Mon, Sep 23, 2019 at 6:30 AM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Posted a new _scaffold. Now both db and auth are defined in common. If you > import common from models, you are fine.

Re: [web2py] Re: Unable to add auth.signature in table - PY4WEB

;), Field('pin'), auth.signature() ) On Sat, Sep 21, 2019 at 9:07 PM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Minor change of behavior. In py4web you need auth.signature() notice the () > > On Saturday, 21 September 2019 07:20:02 UTC-7, sandeep patel w

Re: [web2py] Re: How can add new fields in the existing table in PY4WEB?

ms. > Maybe I will make this easier later. > > You can also make another table that refences auth_user and create your > own forms to handle it. > > On Saturday, 21 September 2019 05:11:59 UTC-7, sandeep patel wrote: >> >> Hello Massimo, >> >&g

Re: [web2py] Re: Does Database validators work in PY4WEB?

Thanks Massimo, Now, it's working fine. On Sat, Sep 21, 2019 at 9:06 PM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > They work the same as in web2py but you must import them > > from pydal.validators import * > > On Saturday, 21 September 2019 08:15:43

[web2py] Does Database validators work in PY4WEB?

Hello Massimo, I have added *IS_EMPTY_OR* validator in the field. I am getting an error. Is there any way to add a validator in the field in py4web? Please have a look at attached file. Thanks SP -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.c

[web2py] Unable to add auth.signature in table - PY4WEB

Hello, I am getting an error to add auth.signature in the table. #model.py from . import common auth = common.auth db.define_table('organization_info', Field('name'), Field('date_of_birth', 'date'), Field('village'), Field('block'), Field('district'), Field('state'), Field('country'), Field('pin

[web2py] How can add new fields in the existing table in PY4WEB?

Hello Massimo, In web2py, We can add new fields in the existing table by *auth.settings.extra_fields*. In Py4web. we can do the same? Thanks Sandeep -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

Re: [web2py] Website automatically gets logged out

Hey Saranya, I have successfully depoyed PayUMoney payment gateway in web2py apps. Here is code repo for that. Please have a look at it. Thanks SP On Thu, Sep 5, 2019 at 4:58 PM Saranya S wrote: > Website automatically logs out after 'PayUMoney

Re: [web2py] Re: web3py -> py4web

Absolutely Great!! But http://py4web.com/_documentation/static/ though 404 On Wed, Jul 24, 2019 at 11:28 AM Dave S wrote: > > > On Tuesday, July 23, 2019 at 10:40:27 PM UTC-7, Massimo Di Pierro wrote: >> >> OK. I know. I am not good with names. >> But there are lots of requirements to be ful

Re: [web2py] Re: Error: Exporting CSV file in SQLFORM.grid

les]) To - sfields = reduce(lambda a, b: a + b, [list(filter(is_searchable, t)) for t in tables]) Note: Web2py version 2.17.2 and Python 3 Thanks Sandeep On Wed, Mar 13, 2019 at 11:02 AM wrote: > Could you share your solution? > > On Wednesday, January 14, 2015 at 7:31:56 PM UTC+2,

Re: [web2py] How can I return file name after inserting?

If you are using the form to summiting data. You can use form vars to summiting data into multiple tables. form = SQLFORM(...) if form.process().accepted: db['table name'].insert(**form.vars) Even you only want to insert a specific field to the table you can do so. db.['table name'].insert

Re: [web2py] Over ride SQLFORM defaults

@Ben I don't think that Field has a _style attribute but in SQLFORM.factory you can use _style attribute. This style applies for all input Fields in form. You can try this way. in_form = SQLFORM.factory( Field('userid', label='User Id: ', requires=IS_NOT_EMPTY()), Field('password',

Re: [web2py] Error importing csv file in python3.6

')): db['table name'].insert(**i) except Exception as e: print(e) form.errors.csvfile = 'Invalid file format.' Thanks SP On Mon, Feb 11, 2019 at 11:45 PM Lovedie JC wrote: > Works. > But I can't access the data. &

Re: [web2py] Error importing csv file in python3.6

In fact, this is an open issue <https://github.com/web2py/web2py/issues/2015> for the same problem. You can check that as well On Mon, Feb 11, 2019 at 11:27 PM sandeep patel wrote: > I had the same issue. I have solved this way. > Please try this > You have to changing li

Re: [web2py] Error importing csv file in python3.6

I had the same issue. I have solved this way. Please try this You have to changing line 926 of gluon/packages/dal/pydal/objects.py from reader = csv.reader(csvfile, delimiter=delimiter, quotechar=quotechar, quoting=quoting) to reader = csv.reader(codecs.iterdecode(csvfile,'utf-8'), delimiter=delimi

Re: [web2py] Increment the value of a variable in one page by clicking a link in a different page

, I dont know if i am > missing something. > > On Sunday, February 10, 2019 at 3:24:38 PM UTC+2, sandeep patel wrote: >> >> >> @Mostwanted >> I think you can achieve this functionality by a couple of ways. >> One, you can store every clicks value in session but you

Re: [web2py] Increment the value of a variable in one page by clicking a link in a different page

@Mostwanted I think you can achieve this functionality by a couple of ways. One, you can store every clicks value in session but you can only store for the time being. Another way you can directly store every clicks values in DB. You can try this code #Model db.define_table('countclick', Field

Re: [web2py] Re: Need to change text Size of the header

@Arindas Please see an attached layout.html file. You get the idea. Thanks SP On Sun, Feb 10, 2019 at 2:00 PM Arindam Dasgupta wrote: > Hi Sandeep, > > As always, Thank you so much. > > I still need to know where do I use these classes in the layout file. The > following c

Re: [web2py] Re: Need to change text Size of the header

@ Arindam, Lionel says that create a new .css and store in static/css folder and add that path in the layout.html file. Add that path after bootstrap.css Even you can directly put a style tag in the layout.html file. Style tag will be inside the end of the head tag. Change the font size according t

Re: [web2py] standalone templates

all...@cfg.jovenclub.cu> wrote: > Hi sandeep patel, thanks for your answer. > > In my use case I am using the template module outside web2py as a > standalone package, and I need to inject some objects in the template by > default. I am not using the whole web2py framework. > &

Re: [web2py] standalone templates

@ Carlos I think you can use the current app modules folder. This executes all the .py files on the top label of every request For more information here Thanks SP On Wed, Jan 23

Re: [web2py] Form Validation not working (v2.17.2)

@lyn2py instead of using Field Type Integer use double Like This Field('one_field_only', 'double')) Thanks SP On Thu, Jan 17, 2019 at 3:47 PM lyn2py wrote: > My code did not change, but upgrading web2py caused my Form Validation to > fail. > > Older (working) version: Version > 2.17.1-stable+ti

Re: [web2py] Check an empty upload field in database

You can use an if-else or try-except block for that Like this. def index(): form = SQLFORM(db.orders) if form.process().accepted: if form.vars.pic_upload: makeThumbnail(db.orders,form.vars.id,(175,175)) else: #do whatever you want else:

[web2py] Getting SQL syntax error during import as CSV file in gird - 2.17.2

#x27; at line 1') Version web2py™ Version 2.17.2-stable+timestamp.2018.10.06.18.54.02,python 3.6.6 Thanks Sandeep -- 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 Is

Re: [web2py] Editing the default formstyle styles

@mostwanted In my case your code working as you expected. what web2py version you are using? You can try this def search(): form=SQLFORM.factory(Field('SEARCH', requires=IS_NOT_EMPTY()), widget = lambda field, value: SQLFORM.widgets.string.widget( field, va

Re: [web2py] Re: modular web2py - need help

Thank you, Massimo, Now it's working Thanks & Regards Sandeep On Sat, Jan 5, 2019 at 11:42 PM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > > If you are getting the error: > > ImportError: cannot import name 'Cookie' > > Either your are not

Re: [web2py] Re: modular web2py - need help

@Stifan OS Windows 10, Python 3.6.6 The shell sign is indicated in *nix environment because I am using Git Bash CLI. Thanks SP On Thu, Jan 3, 2019 at 8:13 PM 黄祥 wrote: > pls provide your environment (os and python version), the log errors > indicate in windows but the shell sign is indicate in

Re: [web2py] Re: modular web2py - need help

is because > it either is not imported in gluon or pydal, so, I think that you are not > using the modular branch of pydal. Start the steps again as @sitfan post in > his last message. > > Greetings. > El 3/1/19 a las 12:33 a.m., sandeep patel escribió: > > @Carlos Cesar C

Re: [web2py] Re: modular web2py - need help

@Carlos Cesar Caballero, I have taken the same steps as you suggested but I am getting the same error. Robodia@DESKTOP-E4IOU2U MINGW64 /d/TestingWeb3py/web2py/gluon/packages/dal (modular) $ python ../../../setup.py Traceback (most recent call last): File "../../../setup.py", line 4, in fro

Re: [web2py] Re: modular web2py - need help

I am getting an ImportError error during setup. Steps: git clone --recursive https://github.com/web2py/web2py.git git checkout modular python setup.py Traceback (most recent call last): File "setup.py", line 4, in from gluon.fileutils import tar, untar, read_file, write_file File "D:\T

Re: [web2py] Happy New Year

Happy New Year to you too, I wish, Developer Tool Kit, which mak working on web3py fun and easy. On Wed, Jan 2, 2019 at 12:30 AM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Happy new year everybody. I hope this is the year we can have a minimalist > web3py for everybody to play with.

Re: [web2py] Re: Upload CSV file though app admin getting an error in 2.17.2

Please Refer attached image. Seeing a flash message from web2py unable to parse CSV. iterator should return strings, not bytes (did you open the file in text mode?) Thanks On Tue, Jan 1, 2019 at 12:39 PM Dave S wrote: > On Monday, December 31, 2018 at 10:17:38 PM UTC-8, sandeep patel wr

[web2py] Upload CSV file though app admin getting an error in 2.17.2

Hello All, I am getting an error while uploading a CSV file to table though app admin. [image: error.PNG] I am using python3.6 and web2py 2.17.2. Thanks SP -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://cod

Re: [web2py] Error Handling in the view

@Mostwanted This is because of try-except block under if block. when price value has None than if condition false. I have tested this code than is work fine for me. .{{ for price in pricing: try: vat=round(price.total*0.12, 2) except: redirect(URL('notRegistered')) else:

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

@Arindas, Are you using one app for Payment and one app for a web application or both of contains in one app? Thanks On Sat, Dec 22, 2018 at 6:10 PM Arindam Dasgupta wrote: > Hi Stifan, > > I have already web2py 2.17.2 installed and I dont have a option to select > python 3.6.6. In the list it

Re: [web2py] Creating charts and trends from db

@Maurice This code is working good. you can check here <http://13.127.38.120/PayUmoney/default/test#>. It would be easy to inspect the problem if you can show your controller code what you have written. Thanks On Fri, Dec 21, 2018 at 1:55 PM Maurice Waka wrote: > Hello Sandeep, &

Re: [web2py] Creating charts and trends from db

You can achieve this way. Controller.py import pygal def chart(): response.files.append(URL('default','static/js/pygal-tooltips.min.js')) response.headers['Content-Type']='image/svg+xml' import pygal from pygal.style import Style custom_style = Style( background='trans

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

@Arindas, I have updated default.py and index.html in the git repository . Please check it. Now transactions make in one click and Even you can change user info and pricing programmatically in a wen2py way. Let me know if you have any questions Tha

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

:50 PM Arindam Dasgupta wrote: > Hi Sandeep, > > I have used your method and used the following ids : > def index(): > MERCHANT_KEY = "hKiHd2aX" > key="hKiHd2aX" > SALT = "byRHoBc0pq" > PAYU_BASE_URL = "https://sandbox

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

t your /view/default folder. 4. Change MERCHANT_KEY, Key, SALT with real ids Now Payment Gateway will work. Thanks Sandeep Patel On Sun, Dec 16, 2018 at 3:32 PM Lovedie JC wrote: > What about python 2.7 compatibility > > On Sat, 15 Dec 2018 at 15:02, Arindam Dasgupta > wrote: >

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

, 2018 at 2:03 PM Arindam Dasgupta wrote: > Hi Sandeep, > In my pythonanywhere page I can see the following version . So my version > is 2.7.6 or 2.14.6 ? > Now I am getting a upgrade option here to version 2.17.2 but it is telling > that is is an experimental one. So how do I upgra

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

I think this error getting because of version. I have tested on both versions 2.16.1 and 2.17.2 that working fine. Here is demo <http://13.127.38.120/PayUmoney> Thanks On Sat, Dec 15, 2018 at 1:32 PM Arindam Dasgupta wrote: > Hi Sandeep, > > I installed the app in pythonany

Re: [web2py] Re: Need to integrate paytm payment gateway in my app

s for accepting payments. > > Regards, > Arindam > > > > On Sat, Dec 15, 2018 at 8:56 AM Arindam Dasgupta > wrote: > >> Hi Sandeep, >> I chose paytm gateway because I know it will work in India. Also I did >> not find resources for PayUMoney in the intern

[web2py] Web2py- PayUMoney Secure Online Payment Gateway.

Hello All, I have customized PayUmoney <https://www.payumoney.com/>python SDK for the Web2py user. This <https://github.com/coodblooded/Web2py-PayUmoney>app can in integrate with any web2py app and customize according to your needs. Thanks Sandeep Patel -- Resources: - http:

Re: [web2py] Need to integrate paytm payment gateway in my app

@Arindam, I have made a PayuMoney payment gateway for web2py apps. if you need help on that please let me know. Thanks SP On Fri, Dec 14, 2018 at 9:36 PM Arindam Dasgupta wrote: > Hi, > I need to integrate the paytm payment gateway in my application . For that > I have already created an accou

Re: [web2py] removing / hiding SQLFORM.grid links in the view, edit, add forms?

@Paul, You can do this way, grid = SQLFORM.grid(query, editable=False,details=False,create=False,..) Thanks SP On Wed, Dec 12, 2018 at 4:40 AM Paul Ellis wrote: > I have a grid with some links. One of the buttons is a placeholder which > some Jquery attaches to. How do I stop this button from

Re: [web2py] Conditional Checks on output from DB.Select statements?

Yes, Arjun you are right you are comparing row object to a string.so first you have to extract value from row object. You can use first or last function to get values. if measure_1.first()['name']=='DBD': instead, store a row object in variables you can store values which you want to compare. m

Re: [web2py] Unable to display dropdown lists in forms

html Add this script in your view file. $(document).ready(function(){ $("#test").click(function (evt) { $("#test").val("") }); }); Thanks SP On Tue, Dec 4, 2018 at 11:04 PM Arindam Dasgupta wrote: > @ sandeep. > Thanks a lot for your solution and it is working f

Re: [web2py] Unable to display dropdown lists in forms

@Arindam: Try the following code instead def test(): form = FORM(LABEL("File(s):"), INPUT(_name='pic_upload', _type='file', _multiple=''), BR(), LABEL("Comments:"), INPUT(_name='comments'), BR(), LABEL("Print Size:"), INPUT(_name='print_size'),

Re: [web2py] Re: Unable to update database entry after compute=lambda r: calculation of some field values in the DB

I think there is a problem in field type in Days because the default is a string so days have a string value, you are multiplying string with an integer in the computed field. # 1 db.define_table('ClientDetails', Field('CheckIn', 'date', label=SPAN('Check-In Date', _style="font-wei

Re: [web2py] How to strip away and get rid of (… days, 0:00:00) from a value acquired from a date calculation

*You can directly count days from date type.this belongs to datetime class.db.define_table('hotels',Field('Hotel'), Field('Bookin', 'date'),Field('Bookout', 'date'), Field('days', compute=lambda r: (r['Bookout']-r['Bookin']).days), Field('guests', 'integer'),Fi

Re: [web2py] Re: mobile friendly login page

@lbjc Add some margin between the buttons. you can try this. Add this in user.html file .btn{ margin-left: 10px; margin-top: 10px; } Best/ SP On Thu, Oct 25, 2018 at 6:34 PM mostwanted wrote: > The attachment link gives *error 404* > > On Thursday, October 25, 2018 at 2:06:15 PM UTC+

Re: [web2py] Making a calculation of two database fields set a value for the third database field

There are many ways to solve this problem. you can achieve by computed fields. #modal db.define_table('logging', Field('startingDistanceValue','integer', requires= IS_NOT_EMPTY(),default=0), Field('endingDistanceValue','integer', requires=IS_NOT_EMPTY (),default=0),

Re: [web2py] My SQLFORM() is not saving anything after putting my APP online

Try this def index(): form=SQLFORM(db.vehicleLogging) if form.process().accepted: response.flash = T("Record Made") elif form.errors: response.flash = T('Error') return locals() In *form.process().**accepted *does not need request.vars and session arguments. Best/

Re: [web2py] Re: Future of web2py

I am also in one of them which use groups, permission, and role very often. Best, Sandeep On Sun, Oct 7, 2018 at 10:55 PM Martin Weissenboeck wrote: > Me too (not #metoo :-) > I like groups and permissions and I use both very often. > Regards, Martin > > Am So., 7. Okt. 20

[web2py] Strange behaviour of calendar size in grid?

Hello, I am using bootstrap3_stacked formstyle in grid. Everything works fine except one thing (calendar size) please refer image for more information. NOTE- I am using Version-2.16.1 #modal db.define_tabel('name', Field('date_of_entry','date',default=date.today(),label=

[web2py] how to break migration at table defining label

Hello, My question is break migration when defining a new table in modal. #modal.py db = DAL('mysql://*@*.amazonaws.com/ware1', pool_size=configuration.get('db.pool_size'), migrate_enabled=configuration.get('db.migrate'), check_reserved=['all

Re: [web2py] how to customize user registration form

What do you want to modify in form? If you want to add more fields in the form so you can add this way. #modal.py auth.settings.extra_fields['auth_user'] = [ Field('new filed name') ] If you want to customize look and feel of the form or even you can change entry form according to your

Re: [web2py]

You can use *request.vars *in your controller function you will get your form input values under the Storage class. Best On Thu, Sep 13, 2018 at 6:41 PM elisha bere wrote: > Hie, > > i would like to know how i can create a form in html and then get the > input as variables in my controls. > N

[web2py] name 'unicode' is not defined in 2.17.1

l\objects.py", line 1755, in store dest_file = self.uploadfs.open(unicode(newfilename), 'wb') NameError: name 'unicode' is not defined Error snapshot [image: help] <https://sandeep.smartyari.com/admin/default/ticket/institute/43.239.145.103.2018-08-13.23-15-08.2cc6bf

Re: [web2py] Re: web2py 2.17.1

Thanks, @Leonel Câmara Now works fine! /sp On Mon, Aug 13, 2018 at 5:30 PM Leonel Câmara wrote: > Sandeep I think that's this issue: > > https://github.com/web2py/web2py/issues/1972 > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documen

Re: [web2py] web2py 2.17.1

n\views\default/plugin.html", line 165, in path=[] TypeError: sequence item 0: expected str instance, bytes found Thanks, Sandeep On Sat, Aug 11, 2018 at 9:34 PM Nico Zanferrari wrote: > Hi, > > I've found that the style bug described in > https://github.com/web2py/web2py/i

Re: [web2py] Re: update multiple tables from one csv and get row id after update_or_insert

@Mattew J Watts, #Model db.define_table('person', Field('name'), Field('age'), Field('country'), format='%(name)s') db.define_table('thing', Field('person_id,'reference preson')

Re: [web2py] Re: widget not working with list:string

Thanks, Anthony! now. it's working One more question I am using plugin_ckeditor so can I get the same functionality in SQLFORM using widget=ckeditor.widget instead of widget = SQLFORM.widgets.list.widget. sandeep/ On Sun, Jul 29, 2018 at 6:15 PM Anthony wrote: > In case 1, the defaul

[web2py] widget not working with list:string

Hello All, In my case widget and list: string Field is not working properly. *Case 1 (Without Widget)* In this case, my form work proply with list:string Field # db.py db.define_table('content_ck', Field('title', length=255), Field('public_ck', 'boolean', default=True), Field('text_c

Re: [web2py] Re: How to go publick with web2py

@Stauros >From where you are an executing your app?.in you local computer or from any cloud-based virtual environment like (heroku, amazon, google cloud). On Sat, Jul 28, 2018 at 6:56 PM Stauros Mpol wrote: > I do this but i cant accses it and the ip is 127.0.0.1 as you see.. gonna > check my fi

Re: [web2py] Re: Sum/Total of the column values in SQLFROM.grid?

Thank Anthony, The error was getting just because I used {{=sum(b)}} in my view. now this works fine. Best On Thu, Jul 26, 2018 at 5:12 PM Anthony wrote: > On Thursday, July 26, 2018 at 7:39:05 AM UTC-4, sandeep patel wrote: >> >> @Anthony, This gives me an error.becouse of so

Re: [web2py] Re: Sum/Total of the column values in SQLFROM.grid?

@Anthony, This gives me an error.becouse of some values float type in the field. ('float' object is not iterable) How can I successfully sum all the values within this solution? Thanks On Thu, Jul 26, 2018 at 4:09 PM Anthony wrote: > #controller.py >> >> grid = SQLFROM.grid(query,..,...) >> a

Re: [web2py] Re: Sum/Total of the column values in SQLFROM.grid?

way to do that!! Best, Sandeep On Thu, Jul 26, 2018 at 3:13 AM Anthony wrote: > On Wednesday, July 25, 2018 at 5:41:26 PM UTC-4, Anthony wrote: >> >> On Wednesday, July 25, 2018 at 3:49:09 PM UTC-4, pbreit wrote: >>> >>> How about JavaScript? >>> >

[web2py] Sum/Total of the column values in SQLFROM.grid?

Hello, I have a grid that is worked as I expected. now I want to sum all the values that have in "number_of_bags" Field. So that I have used grid.rows (*sum([int(grid.rows[i].number_of_bags) for i in range(len(grid.rows))])*) but this gives me sum of first 10 records but i want sum of all the v

Re: [web2py] Deleting a db table row

You can delete row this way!! db((db.table.id==id_s)&(db.table.created_by == auth.user.id)).delete() if you want delete rows upto a certain limit so you can you put this quarry under for loop. Best, On Sun, Jul 22, 2018 at 4:43 PM Maurice Waka wrote: > I have tried this example but I get this er

Re: [web2py] Web2Py Smartgrid - it is possible to link to a pdf file?

Hello Annika, You can try this. grid = SQLFORM.grid(query,selectable=[(' Link to PDF-File ',lambda ids :redirect(URL('default','file.pdf',vars=dict(id=ids Best/ On Thu, Jul 5, 2018 at 12:52 PM wrote: > Hello, > > I have my sqlgrid working but would need a link to a pdf f

Re: [web2py] Required field label

If yor are using SQLFROM than You can try this labels={'field_name':P('name',B('*',_style:'color:red'))} Best On Tue, Jun 19, 2018 at 11:24 PM Tu Duong wrote: > Hi, what is the best way to add red * (or any indication that the field is > required for user) in the label of the required field? Th

Re: [web2py] Re: Send args from a button in views

egroups.com> wrote: > Thanks for your help all! > i'll give these a go. Sorry if i want that clear, but i'm not trying to > use a grid, i'm trying to redirect from a button in views > > >{{=A('Cancel',_href=URL('my_collections'),_clas

Re: [web2py] Re: Send args from a button in views

@Matthew J Watts You can try this grid = SQLFORM.grid(query,selectable=[('Name',lambda ids :redirect(URL('default','func',args=ids)))]) best sandeep On Fri, May 25, 2018 at 4:00 AM, 黄祥 wrote: > pls try (not tested) > {{=A('Finish',_href=

Re: [web2py] Re: it's possible to use Autocomplete widget in SQLFORM.grid ?

uot;this.style.backgroundColor='yellow'", _onmouseout="this.style.backgroundColor='white'" ).xml() for k in selected]) Thanks Sandeep On Fri, May 25, 2018 at 11:21 AM, Sandeep Patel wrote: > > @isi_jca > I have read some old threads, i

Re: [web2py] Re: it's possible to use Autocomplete widget in SQLFORM.grid ?

Just want to update you and others. Thanks for your advice. Greatly appreciated On Fri, May 25, 2018 at 2:19 AM, isi_jca wrote: > Sandeep: > > Look at this link: http://web2py.com/books/default/chapter/29/07/forms- > and-validators?search=autocomplete#Autocomplete-widget > >

Re: [web2py] Re: Menu option on We2py 2.16.1-stable doesnt open on cellphones

Change The default layout.html with this ** than menu will open in cellphone too. Thank sandeep On Fri, May 25, 2018 at 6:23 AM, Dave S wrote: > > > On Thursday, May 24, 2018 at 9:37:58 AM UTC-7, mostwanted wrote: >> >> Hi guys, my menu is not opening on cellphones, i c

[web2py] it's possible to use Autocomplete widget in SQLFORM.grid ?

Hello, Can anyone, let me know how to work Autocomplete widget with SQLFROM.grid in the search filed. I have used Autocomplete widget in SQLFROM that's work fine but in the grid, nothing in happen. Please give me some direction how to do that Thank's Sandeep -- Resourc

[web2py] How to show conditional fields with multiple conditions

Hello, I want to show form fields based on the user input so I used conditional fields, what happens to me whenever I select ''*FIRE*" or " *FIRE1*" fields appear in my form but when I select "*Both*" nothing appear in my form what going wrong with my code, please correct me # Model.py auth.se

Re: [web2py] Re: How to iterate through column items and display its rows data

Try this rows = db(db.person.id>0).count() On Tue, May 1, 2018 at 8:33 AM, Maurice Waka wrote: > I get this error : AttributeError: 'Rows' object has no attribute 'count' > > On Mon, 30 Apr 2018, 22:10 pbreit wrote: > >> I would think something like: >> >> rows = db(db.person.id>0).select() >

[web2py] How to manage web2py app and php application under the same Apache server

ble to access php application from the web . NOTE- I have to install AMPPS server on EC2 (windows machine) Please give me direction Thank's Sandeep -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.g

[web2py] Problem enabling Email services

. However, I am still receiving an Error Message -* WARNING:web2py:email not send.* Can anyone help me out here please? Any help would be greatly appreciated. Thanks Sandeep --- from: patelsandeep...@gmail.com to: sand...@robodia.com subject: welcome

[web2py] What is the diffrence between Web2py local host and Apache local host (wamp server)

Hello Everyone, I hosted my web2py on AWS ec2 and Connected it with AWS RDS and ran web2py server (0.0.0.0:8000) locally. This provided me a global access. Now, I am curious as to what would have been the difference if i chose to host my web2py app on Apache local host (wamp server). Would gr

[web2py] How to insert data into Database?

I want to take data from the user using my HTML template and insert that data into my database without using SQLFROM and FROM in my controller file. can I do it? Actually, I am new in web2py, please give me direction. Here file #model file from gluon import DAL, Field mysql = DAL('mysql://*

[web2py] redirecting to another page

hii all, how can i redirect from the registration page to another page* instead of login page* after completion of registration. I am using default registration from web2py -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Doubts about post and comment tables

Sir, is there a other way to link comments to a particular post without using post.id or any Field of post table has reference post Field in comment table -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.go

[web2py] Need support for web2py application with over 1 million users.

We run major application in India with over 1 million users, and relatively high concurrent users traffic, which spikes twice a day. Recently we are experiencing a lot of troubles in scaling. We would love to get opinion from any consultant who provides support for web2py application in India.

[web2py] Re: Error : unable to open database file

to > access, it may timeout. > > On Thursday, 26 June 2014 16:29:05 UTC-5, Sandeep Kumar wrote: >> >> Hi, >> I am getting this strange error one in 10 times in my app. The error >> is " unable to open database file". I >> am getting this erro

[web2py] Error : unable to open database file

Hi, I am getting this strange error one in 10 times in my app. The error is " unable to open database file". I am getting this error after i replaced the *databases* folder with one from my backup app which is running on a different server. I think the plugin_wiki is has some problem. I wa

[web2py] Multiple AJAX POST requests get serially serviced

for this purpose but without creating a separate thread/async task. Could somebody guide me as to what could be the bottleneck (nginx/uwsgi/web2py app?) and how should I debug this further? Br Sandeep -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/