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

2018-05-24 Thread mostwanted
Hi guys, my menu is not opening on cellphones, i can not access my menu when i open my website on a cell phone, i am using 2.16.1-stable version. Is there something wrong with this version or the problem is my application? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Docu

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

2018-05-24 Thread mostwanted
s good too, it works. Thank you guys. On Thursday, May 24, 2018 at 6:37:58 PM UTC+2, mostwanted wrote: > > Hi guys, my menu is not opening on cellphones, i can not access my menu > when i open my website on a cell phone, i am using 2.16.1-stable version. > Is there something wrong with t

[web2py] reference gives error table company has no column named....

2018-08-30 Thread mostwanted
I have a database which i recently updated by adding a new table called *tlamelo*, the new table is referenced in one of the old tables called *company, *when i try to save data into the table *company* i get the error bellow *(table company has no column named tlamelo)!* I do not understand w

[web2py] Getting wrong results from a tootip after a for loop ina a view

2018-09-10 Thread mostwanted
I have contact details of different places in my DB, the names of these different places are displayed as links in a page, what i want is for the contact details of a place to be displayed in a tooltip when i click on the link name of that place. But that is not happening! What happens is that

[web2py] Ajax Live Search (auto-complete)

2018-09-12 Thread mostwanted
I have been looking at the code for the Ajax Live Search auto-complete under Ajaxing your search functions of the web2py cookbook, i want to implement the No results function if the search does not return anything but i'm not sure where and how to implement it. The Ajax live search code is her

[web2py] How can i select an item from the database only once?

2018-09-21 Thread mostwanted
How do i get a value stored in the database to be selected only once by users? I am creating a hotel system and in this system i have to make sure that a room can not be double booked, it can only be selected once for one client. Regards Mostwanted -- Resources: - http://web2py.com - http

[web2py] Re: How can i select an item from the database only once?

2018-09-23 Thread mostwanted
Field('available', 'boolean'), Field('occupant', 'reference client'))* On Saturday, September 22, 2018 at 1:06:24 AM UTC+2, Dave S wrote: > > > > On Friday, September 21, 2018 at 2:35:33 PM UTC-7, Dave S wrote: >> >>

[web2py] How do i get the details of a user in db.auth_user displayed by referencing it in my db?

2018-09-23 Thread mostwanted
;, args=bookings.id))}} {{= bookings.Name}} Room {{=bookings.Room.Room_Number}} {{=bookings.Room_Status.Room_Status}} {{if auth.user:}} {{=bookings.Booked_By.first_name}} {{pass}} {{pass}}

[web2py] what is '\x00'

2018-09-24 Thread mostwanted
I opened my App this morning to work on it & i got this error * '\x00' *, can anyone please assist? What does it mean??? When i went to sleep everything was ok. Regards Mostwanted -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com

[web2py] How to capture auth_user login time & logout time

2018-09-26 Thread mostwanted
Hi guys, i was wondering if there is a way for me to capture user login time and user logout time Regards Moatwanted -- 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

[web2py] Re: How to capture auth_user login time & logout time

2018-09-27 Thread mostwanted
Thank you guys On Thursday, September 27, 2018 at 6:18:57 PM UTC+2, Joe Barnhart wrote: > > What Anthony said. Only sessions rarely log out. They mostly time out, > which does not show up as an event. > > Joe > > On Wednesday, September 26, 2018 at 12:13:25 PM UTC-7, mostw

[web2py] Re: How can i select an item from the database only once?

2018-09-27 Thread mostwanted
Thank you Dave but this URL https://web2py.com/boobs/default/29/07/forms-and-validators#SQLFORM-and-insert-update-delete

[web2py] Object not found

2018-09-27 Thread mostwanted
ails in one view by clicking on the owner's name but i keep getting the *Object not found *message caused an attempt at opening an edit for the Purchases table, what am i doing wrong, is there a better way of doing this? Regards Mostwanted *MODELS* db.define_table('Customer',

[web2py] Re: Object not found

2018-09-28 Thread mostwanted
nt_Update(): > client=request.args(0,cast=int) > > > > > > > On Friday, September 28, 2018 at 8:04:57 AM UTC+2, mostwanted wrote: >> >> I have 3 table, Items, Client & Purchases, the Client table stores the >> details of the customer, the items table

[web2py] Re: Object not found

2018-09-28 Thread mostwanted
On Friday, September 28, 2018 at 1:40:56 PM UTC+2, mostwanted wrote: > > Hey Matthew, i have another view called viewPurchases that has a link that > sends my args to the client_update controller, i didnt include it in the > above code i thought is wasn't important i

[web2py] Reading information from an external CSV file through SQLFORM.smartgrid

2018-10-03 Thread mostwanted
Is it possible for me read information from a CSV file saved somewhere in my computer into my application through SQLFORM.smartgrid without uploading the CSV file into the application? Regards Mostwanted -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http

[web2py] Re: Reading information from an external CSV file through SQLFORM.smartgrid

2018-10-03 Thread mostwanted
t; Anthony > > On Wednesday, October 3, 2018 at 3:15:36 AM UTC-4, mostwanted wrote: >> >> Is it possible for me read information from a CSV file saved somewhere in >> my computer into my application through SQLFORM.smartgrid without uploading >> the CSV file into t

[web2py] Re: Reading information from an external CSV file through SQLFORM.smartgrid

2018-10-03 Thread mostwanted
Yes it is Dave On Wednesday, October 3, 2018 at 11:10:53 PM UTC+2, Dave S wrote: > > > > On Wednesday, October 3, 2018 at 12:15:36 AM UTC-7, mostwanted wrote: >> >> Is it possible for me read information from a CSV file saved somewhere in >> my comput

[web2py] Re: Reading information from an external CSV file through SQLFORM.smartgrid

2018-10-04 Thread mostwanted
ine_table('my_csv_temp_table', ...) > temp_db.my_csv_temp_table.import_from_csv_file(...) > grid = SQLFORM.smartgrid(temp_db.my_csv_temp_table) > > Anthony > > On Wednesday, October 3, 2018 at 10:20:00 AM UTC-4, mostwanted wrote: >> >> I like the first suggestion* (You cou

[web2py] How to hide the the SQLFORM.grid results until a search is done & returns something

2018-10-08 Thread mostwanted
VWb80A <https://groups.google.com/forum/#!newtopic/web2py/web2py/9_Lz5VWb80A>* I was hoping there was a way to also hide the results and only display them when a search returns something. Regards Mostwanted -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http

[web2py] How to set my menu to hamburger menu for tablet devices when they open my webapp

2018-10-12 Thread mostwanted
something but I came out blank, maybe i don't know what i am looking for. Regards: Mostwanted -- 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 rec

[web2py] Re: How to set my menu to hamburger menu for tablet devices when they open my webapp

2018-10-12 Thread mostwanted
Thanks Dave On Friday, October 12, 2018 at 9:37:07 PM UTC+2, Dave S wrote: > > > > On Friday, October 12, 2018 at 3:06:58 AM UTC-7, mostwanted wrote: >> >> Can anyone assist me in figuring out how to set my menu to hamburger menu >> for tablet devices when they o

[web2py] Infringement issues over creating licenced sofware with web2py

2018-10-17 Thread mostwanted
Hi guys, i wanna know if there would be any infringement issues if i created licensed standalone software using the web2py framework. Will i be overstepping some copyright laws which will make me liable to be penalized?? Regards: Mostwanted -- Resources: - http://web2py.com - http

[web2py] Re: Infringement issues over creating licenced sofware with web2py

2018-10-18 Thread mostwanted
hahahaha thanks Leonel, i wont be a "dick"thanks for the clarification. On Thursday, October 18, 2018 at 4:32:01 PM UTC+2, Leonel Câmara wrote: > > No you don't need to worry, web2py is LGPL licensed which means that you > may: > > - redistribute web2py with your apps (including official web2

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

2018-10-19 Thread mostwanted
("Record Made") elif form.errors: response.flash = T('Error') return locals() *I am using web2py version **2.17.2:* I am mentioning this but i don't know if it will help. Is there something wrong with my above code? Regards: Mostwanted -- Resources: -

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

2018-10-20 Thread mostwanted
se.flash = T('Error') > return locals() > > In *form.process().**accepted *does not need request.vars and session > arguments. > > Best/ > sp > > On Fri, Oct 19, 2018 at 6:27 PM mostwanted > wrote: > >> Before taking my application online i was

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

2018-10-20 Thread mostwanted
w can i achieve this in web2py? *Model:* db.define_table('logging', Field('startingDistanceValue','integer', requires= IS_NOT_EMPTY()), Field('endingDistanceValue','integer', requires=IS_NOT_EMPTY ()),

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

2018-10-20 Thread mostwanted
ngDistanVealue'] * r['endingDistanceValue']))) > > Every time summited form distanceTravelled field calculated automatically. > > Best > SP > > On Sat, Oct 20, 2018 at 2:46 PM mostwanted > wrote: > >> I was hoping to get assistance here, i have a databa

[web2py] How to get members of groups to view only what their group members post

2018-10-20 Thread mostwanted
'layout.html'}} {{for details in details:}} Infomation: {{=details.body}} Date: {{=details.posted_on}} Poster: {{=details.posted_by.first_name}} {{pass}} How can I change my *details controller* to be able to achieve the above task? Regards: Mostwanted -- Resources: - http://web2py.com - http://w

[web2py] Re: How to get members of groups to view only what their group members post

2018-10-22 Thread mostwanted
Yes i am using group memberships in my Auth tables On Monday, October 22, 2018 at 8:58:06 AM UTC+2, Dave S wrote: > > > > On Saturday, October 20, 2018 at 12:30:07 PM UTC-7, mostwanted wrote: >> >> I can get registered users to view only what they post and not what >

[web2py] Creating a CSV backup for the database file in the app

2018-10-23 Thread mostwanted
response.flash = T("BOOKING FAILED! Please observe the form!") return locals() Regards: Mostwanted -- 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

[web2py] Re: Creating a CSV backup for the database file in the app

2018-10-24 Thread mostwanted
ble=False, user_signature=False) return locals() Regards Mostwanted On Tuesday, October 23, 2018 at 10:11:55 PM UTC+2, Dave S wrote: > > > > On Tuesday, October 23, 2018 at 11:44:41 AM UTC-7, mostwanted wrote: >> >> I have a folder in my desktop that contains a CSV

[web2py] Re: Creating a CSV backup for the database file in the app

2018-10-24 Thread mostwanted
I got the answer here: https://stackoverflow.com/questions/52976228/accessing-and-importing-data-from-a-private-csv-file-using-os-path-join/52981326#52981326 Regards: Mostwanted On Wednesday, October 24, 2018 at 3:01:52 PM UTC+2, mostwanted wrote: > > I am able to save some informatio

[web2py] Re: reference gives error table company has no column named....

2018-10-24 Thread mostwanted
grate=True. >6. Remove the comment from #2 above and run another request -- pyDAL >will now create the missing field. > > Anthony > > On Thursday, August 30, 2018 at 4:13:02 PM UTC-4, mostwanted wrote: >> >> I have a database which i recently updated by addi

Re: [web2py] Re: reference gives error table company has no column named....

2018-10-25 Thread mostwanted
ame it > brhe refresh or restart web2py. > > On Thu, 25 Oct 2018, 09:36 mostwanted > > wrote: > >> When i do all this it gives me error saying table Customer exists! >> >> On Friday, August 31, 2018 at 2:53:18 AM UTC+2, Anthony wrote: >>> >>> fake

Re: [web2py] Re: reference gives error table company has no column named....

2018-10-25 Thread mostwanted
Thu, 25 Oct 2018, 13:52 mostwanted > > wrote: > >> If i delete it from the database folder and refresh my browser with the >> table using the same name will it not throw the *table exists *error? >> >> On Thursday, October 25, 2018 at 11:13:31 AM UTC+2, Lovedie JC w

[web2py] Re: mobile friendly login page

2018-10-25 Thread mostwanted
The attachment link gives *error 404* On Thursday, October 25, 2018 at 2:06:15 PM UTC+2, lbjc...@gmail.com wrote: > > The default login page on the desktop looks absolutely good. The mobile > page,see attached needs some workup. Is there a way to align the buttons? > Regards > -- Resources: - h

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

2018-10-25 Thread mostwanted
7;date'),Field('Bookout', 'date'), Field('days', compute=lambda r: r['Bookout']-r['Bookin']), Field('guests', 'integer'),Field('price', compute=lambda r: r['days&#x

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

2018-10-25 Thread mostwanted
It works SP, thank you. Regards: Mostwanted On Thursday, October 25, 2018 at 7:17:03 PM UTC+2, sandeep patel wrote: > > > > > > > > > *You can directly count days from date type.this belongs to datetime > class.db.define_table('hotels',Fie

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

2018-10-25 Thread mostwanted
Field('Days', compute=lambda r: (r['CheckOut']-r['CheckIn' ]).days), Field('Amount', compute=lambda r: r['Days']*r[ 'Number_of_Guests']*650)) *UPDATE CONTROLLER:* def clientUpdate(): details=db.ClientDetails(request

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

2018-10-25 Thread mostwanted
With this one there was no error traceback, the form just failed to submit showed a message that read *Error in form, please check it out *and i do have a field Number_of_Guests i just didnt include it coz i thought i was minimizing the whole code to show what could the root cause of the problem

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

2018-10-26 Thread mostwanted
was using. Regards Mostwanted On Friday, October 26, 2018 at 7:20:22 AM UTC+2, sandeep patel wrote: > > 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 fi

[web2py] Selecting a single item's entity with $('').clicking(function(){}

2018-10-31 Thread mostwanted
price}});$(".key").keyup(function() { var $num1 = ($.trim($(".num1").val()) != "" && !isNaN($(".num1").val())) ? parseFloat($(".num1").val()) : 1;var $price=($.trim($("#price").html()) != "" &&

[web2py] Re: Selecting a single item's entity with $('').clicking(function(){}

2018-11-02 Thread mostwanted
> > > > On Wednesday, October 31, 2018 at 1:45:16 AM UTC-7, mostwanted wrote: >> >> I am trying to create a simple point of sale system but i am having a >> hard time selecting an items, their prices and adding them up in a selected >> DIV. I am not doing something rig

[web2py] Glyphicons still not showing in version 2.17.1-stable

2018-11-07 Thread mostwanted
Was a solution ever provided/created for the not appearing glyphicons? Massimo promised a solutions to this last year (2017): https://groups.google.com/forum/#!msg/web2py/CSA-p4OSKM0/mziFoZ3KBQAJ;context-place=topic/web2py/Eii2yOpd_TU Whats the way around this problem? Mostwanted

[web2py] Request for direction to benchmark

2018-11-07 Thread mostwanted
i will be more than willing to send you what i have done to help me execute sales and save them. Thank you. Mostwanted -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: Request for direction to benchmark

2018-11-07 Thread mostwanted
Hey Stifan, i did look at it but id dint quite find what i was looking for but thanks for the suggestion. On Thursday, November 8, 2018 at 1:28:30 AM UTC+2, 黄祥 wrote: > > perhaps you can check on web2py appliances, there are some examples of that > ref: > https://github.com/mdipierro/web2py-appli

[web2py] Re: Request for direction to benchmark

2018-11-08 Thread mostwanted
I think you are right, i complicated the UI from the jump now i cant finish it, I should lay a more flexible foundation. On Thursday, November 8, 2018 at 10:19:39 AM UTC+2, Dave S wrote: > > > > On Wednesday, November 7, 2018 at 10:29:49 PM UTC-8, mostwanted wrote: >> >>

[web2py] HOW TO SET A DEFAULT VALUE FOR A TABLE REFERENCED IN ANOTHER TABLE

2018-11-08 Thread mostwanted
doesn't need a code example. Thank You Mostwanted -- 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 subsc

[web2py] Re: Glyphicons still not showing in version 2.17.1-stable

2018-11-09 Thread mostwanted
ame of your app* > /static/images/*your picture name*.png);background-repeat: no-repeat;} > > [image: ic.png] > HTML > class="glyphicon-user">Профиль > > среда, 7 ноября 2018 г., 12:43:53 UTC+3 пользователь mostwanted написал: >> >> Was a solution ever p

[web2py] Re: HOW TO SET A DEFAULT VALUE FOR A TABLE REFERENCED IN ANOTHER TABLE

2018-11-09 Thread mostwanted
Thanks On Friday, November 9, 2018 at 2:14:55 PM UTC+2, tim.n...@conted.ox.ac.uk wrote: > > You set the default in client: > > db.define_table( > 'client', > Field('city', db.city, default='Value here'), > ) > > > On Friday, 9 N

[web2py] Summing up values in a dabase table with compute r: r[' ']

2018-11-10 Thread mostwanted
Field('totalPrice', compute=lambda r: r['price']* r[ 'quantity']), *Field('Total', writable=False, compute=lambda r: (r['totalPrice']).sum()))* Mostwanted -- Resources: - http://web2py.com - http://web2py.com/book (Documentatio

[web2py] Re: Summing up values in a dabase table with compute r: r[' ']

2018-11-12 Thread mostwanted
I wanted to create an Invoice for clients orders, i wanted to be able to do all the calculations of the costs of their services as I enter values into the database. But I kinda found a way around this coz it was giving me a headache, so i decided to calculate the total in the controller like i d

[web2py] '<'

2018-11-12 Thread mostwanted
I'm pulling my hairs out over this error, it occurred from no where & I cant make sense of it because i had not made any updates to my code & got this error Here is the traceback if anyone can figure something out please help me, thank you in advance. Ticket ID 127.0.0.1.2018-11-12.20-51-42.

[web2py] Re: Summing up values in a dabase table with compute r: r[' ']

2018-11-12 Thread mostwanted
Thanks Stifan On Monday, November 12, 2018 at 9:29:50 PM UTC+2, 黄祥 wrote: > > perhaps you can learn from web2py appliance: pos > if i'm not wrong the code to calculate for sum is on the controller side > > ref: > https://github.com/mdipierro/web2py-appliances/ > > best regards, > stifan > -- Re

Re: [web2py] '<'

2018-11-14 Thread mostwanted
I had to re-create my database from scratch too, i don't know where this error came from. Thanks for replying. Mostwanted On Wednesday, November 14, 2018 at 11:02:00 AM UTC+2, Lovedie JC wrote: > > I used to get such esp. when on of my files was corrupted in the > databases. &

[web2py] How to convert my view to pdf

2018-11-14 Thread mostwanted
b.com/lucasdavila/web2py-appreport/wiki/Docs-and-examples but the results are not what i want. I wanna have a button on my view which when i click converts that view in to pdf straight away and have it saved. Is this possible and if so how can i achieve it? (Smiles :) Mostwanted. -- Reso

[web2py] Restricting values entered into a field to a certain minimum

2018-11-23 Thread mostwanted
How can I restrict a value entered into a database field to a certain desirable minimum? -- 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 thi

[web2py] Re: Restricting values entered into a field to a certain minimum

2018-11-24 Thread mostwanted
I ended up creating my custom validator, to handle this situation. On Friday, November 23, 2018 at 2:55:03 PM UTC+2, mostwanted wrote: > > How can I restrict a value entered into a database field to a certain > desirable minimum? > > -- Resources: - http://web2py.com - http://

[web2py] Re: Restricting values entered into a field to a certain minimum

2018-11-25 Thread mostwanted
ESS_THAN_TEN())) The problem i am facing now is that the validator disqualifies every value i enter even those greater than 10! When i change the comparison operator to greater than it accepts everything! If anyone sees the problem please point it out to me, thank you. Mostwanted On Sunday,

[web2py] Re: Restricting values entered into a field to a certain minimum

2018-11-25 Thread mostwanted
I initially tried converting but it didnt work but let me try it again, i moved the validator code to a different directory, i'll be importing it from modules, maybe it will work when i convert this time around. On Sunday, November 25, 2018 at 11:27:00 AM UTC+2, Val K wrote: > > Maybe convert va

[web2py] Re: Restricting values entered into a field to a certain minimum

2018-11-25 Thread mostwanted
Well its a miracle! coz now it works! Thanks Val K -- 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 subscribed to

[web2py] Re: Restricting values entered into a field to a certain minimum

2018-11-27 Thread mostwanted
I'll give it a go On Sunday, November 25, 2018 at 12:58:34 PM UTC+2, Val K wrote: > > Note that you can just turn requires into list and prepend it with > IS_NUMBER validator -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source cod

[web2py] How to solve '\x00' error

2018-11-30 Thread mostwanted
There was a electrical power cut in my area today, it happened while i was working on my application. When the power returned & I tried to continue with my application I got this error: *"'<'type 'exceptions.KeyError'> '\x00'"* Now my application is NOT working! This is not the first time, i ha

[web2py] Re: How to solve '\x00' error

2018-12-01 Thread mostwanted
Please refer me, what page, I will be lying if i said i looked it up! On Saturday, December 1, 2018 at 11:09:02 AM UTC+2, Val K wrote: > > It seems that dal-metafiles are broken. Did you try to fix it as the book > suggests? -- Resources: - http://web2py.com - http://web2py.com/book (Documentat

[web2py] Re: How to solve '\x00' error

2018-12-01 Thread mostwanted
other type meanwhile saving information in it. The other involves partial committing of complex transaction. I haven't encountered any of these so i'm still trying to figure out where my error falls & how I can apply the given solutions. Mostwanted On Saturday, December 1, 2018 a

[web2py] Using a value of one table as a default value of another table

2018-12-01 Thread mostwanted
e', 'integer'), #Field('vat', compute=lambda r: int(r['Days'])*r['Unit_Price']*r['No_of_Pax']*0.1), Field('Amount', compute=lambda r: int(r['Days'])*r[ 'Unit_Price']* r['No_

[web2py] Re: How to solve '\x00' error

2018-12-03 Thread mostwanted
What concerns me is that I developed a standalone application with web2py & every-time there is a sudden power cut which is an issue in my area, when switching on a computer to continue using the application we find that the application has crushed! Isn't there a away to avoid the application c

[web2py] Re: How to solve '\x00' error

2018-12-09 Thread mostwanted
Can you please explain further Leonel? On Wednesday, December 5, 2018 at 1:02:22 AM UTC+2, Leonel Câmara wrote: > > The application should be running with migration disabled in production in > which case this won't happen. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentat

[web2py] Error Handling in the view

2018-12-24 Thread mostwanted
In my view i have a section that does a calculation of a value plus its VAT(tax), the problem is if this value is not found i get an error like the one below: unsupported operand type(s) for *: 'NoneType' and 'float' What i want to be able to do is to be able to redirect to another page that

Re: [web2py] Error Handling in the view

2018-12-24 Thread mostwanted
Thank you very much SP for pointing that out, much appreciated Mostwanted On Monday, December 24, 2018 at 3:11:23 PM UTC+2, sandeep patel wrote: > > @Mostwanted > This is because of try-except block under if block. when price value has > None than if condition false. > I have t

[web2py] Displaying textfield information with ajax() function in different pages

2018-12-29 Thread mostwanted
fluences the degree of centrifugal force on bends? Mostwanted -- 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 becaus

[web2py] Re: Displaying textfield information with ajax() function in different pages

2018-12-29 Thread mostwanted
I have changed my controller abit according to your advice *CODE:* def echo(): session.name=request.vars.name return 'Welcome, ', session.name & in view 2 and other views i simply add {{=session.name}} and i get what I want, it works & i hope the semantics of how i used session are ok *

[web2py] Making my binary standalone apps function faster

2018-12-30 Thread mostwanted
Hi guys, I develop a-lot of stand alone apps with web2py but my problem is that i find the performing slower, every-time there is data entry or a query it takes a while to save information and or bring out the query results, is there a way in which i can make my apps faster? Mostwanted

[web2py] Web2py .exe pack custom

2019-01-05 Thread mostwanted
Hi guys, can anyone please explain to me how the .exe option under pack custom works? I have tried it and after packaging and unzipping the zipped folder I wasn't sure what is should be looking for. Regards Mostwanted -- Resources: - http://web2py.com - http://web2py.com/book (Document

[web2py] Deleting all items of a selecte ID at the same time

2019-01-06 Thread mostwanted
llows me to delete the invoice items one at a time, is there another function i can use that will allow me to delete them all at once? By deleteng the invoice items this will delete the entire invoice allowing the user to implement a new invoice. Please help! Mostwanted -- Resources: - http://web2

[web2py] Re: Deleting all items of a selecte ID at the same time

2019-01-06 Thread mostwanted
Hey Anthony, thanks for the heads up in the garbage code in the controller i will address it, with regards to deleting invoices i want to be able to delete all invoices in the db.invoice table but only for a specific selected client. I want to be able to delete an entire invoice by clicking the

[web2py] Re: Web2py .exe pack custom

2019-01-06 Thread mostwanted
ains your application, which you can then use to > distribute as a standalone binary, as described here > <http://web2py.com/books/default/chapter/29/14/other-recipes#How-to-distribute-your-applications-as-binaries> > . > > Anthony > > On Sunday, January 6, 2019 at 1:56:42

[web2py] Re: Deleting all items of a selecte ID at the same time

2019-01-06 Thread mostwanted
voice(request.args(0, cast=int)) remove=db(db.invoice.customer==query.id).delete() if remove: redirect(URL('registeredClients')) return locals() On Sunday, January 6, 2019 at 4:35:36 PM UTC+2, Anthony wrote: > > On Sunday, January 6, 2019 at 9:15:41 AM UTC-5, mostwa

[web2py] Re: Deleting all items of a selecte ID at the same time

2019-01-07 Thread mostwanted
oice for the selected client and not erasing everything in the database On Tuesday, January 8, 2019 at 12:05:15 AM UTC+2, Anthony wrote: > > On Monday, January 7, 2019 at 2:06:43 AM UTC-5, mostwanted wrote: >> >> My delete function is not working, I think I am doing doing somethi

[web2py] Editing the default formstyle styles

2019-01-09 Thread mostwanted
RCH.split() query=reduce(lambda a,b:a&b, [db.Client_Details.company.contains(k) for k in tokens]) company=db(query).select(orderby=db.Client_Details.company) else: company=[] return locals() Mostwanted -- Resources: - http://web2py.com - http://web2py.com/book (D

[web2py] Re: Editing the default formstyle styles

2019-01-09 Thread mostwanted
border! Sorry! False alarm! Mostwanted On Thursday, January 10, 2019 at 7:43:22 AM UTC+2, mostwanted wrote: > > Is there a way to edit and customize the default *formstyle* styling? I > am trying to place a form label on top of my sqlform.factory form with > formstyle='table3cols&#x

Re: [web2py] Editing the default formstyle styles

2019-01-09 Thread mostwanted
Sorry SP the problem was in my application CSS, i tried to explain it on my follow up message which i just posted seconds after your reply. But thanks for replying! Mostwanted On Thursday, January 10, 2019 at 8:02:49 AM UTC+2, sandeep patel wrote: > > @mostwanted > In my case your cod

[web2py] getting auth.settings.login_next = URL('function') to work

2019-01-10 Thread mostwanted
attention span! I have *auth.settings.login_next = URL('function') *defined in my *db.py* and i hoped this was enough to redirect my user to the defined page at login but nothing is happening! What should i add where to get it to work?? Mostwanted -- Resources: - http://web2py.com - http://web2py

[web2py] Re: getting auth.settings.login_next = URL('function') to work

2019-01-10 Thread mostwanted
Much appreciated. Mostwanted On Thursday, January 10, 2019 at 4:36:21 PM UTC+2, Anthony wrote: > > auth.settings.login_next is just a default -- it is overridden if there is > a _next variable in the URL query string (which will be the case if the > user arrives at login page via the au

[web2py] Problem with a link that displaying wrong information upon clicking

2019-01-10 Thread mostwanted
t: $(window).height() + 'px' }).css({ top:($(window).height() - hiddenSection.height())/2 + 'px',left:($(window).width() - hiddenSection.width())/2 + 'px' }).css({ 'background-color': 'rgba(0,0,0,0.6)' }).appendTo('body');$('img#cl

[web2py] decremental subtraction of values in DB field

2019-01-13 Thread mostwanted
'ODO_Reading'], requires=IS_NOT_EMPTY()),* Field('Fuel_Usage', compute=lambda r: r['Delta']/r[ 'Quantity'])) To get the delta field i have to subtract the previously entered ODO_Reading value from the newly entered ODO_Reading value but what i have

[web2py] Re: decremental subtraction of values in DB field

2019-01-13 Thread mostwanted
I am trying your formula but my Delta field is not getting updated. It is supposed to change as i enter a different value in ODO_Reading. On Monday, January 14, 2019 at 6:26:09 AM UTC+2, Anthony wrote: > > On Sunday, January 13, 2019 at 10:24:03 AM UTC-5, mostwanted wrote: >> >&g

[web2py] Re: Problem with a link that displaying wrong information upon clicking

2019-01-14 Thread mostwanted
in my code above* *var hiddenSection = * *$('#' + id);* Now my link is working properly, it no longer has a large opaque window in the background! But i do get my modal window displaying what i want! *Mostwanted* On Friday, January 11, 2019 at 8:22:50 AM UTC+2, mostwanted wrote: > >

[web2py] Re: decremental subtraction of values in DB field

2019-01-15 Thread mostwanted
t=0), before_update=fuelLogging_before_update) I guess i am doing something wrong somewhere! On Monday, January 14, 2019 at 11:37:10 PM UTC+2, Anthony wrote: > > On Monday, January 14, 2019 at 2:23:32 AM UTC-5, mostwanted wrote: >> >> I am trying your formu

[web2py] Re: decremental subtraction of values in DB field

2019-01-17 Thread mostwanted
its my first time using *callbacks on records*, i am not at all familiar with them! Mostwanted -- 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 rece

[web2py] Editing a compiled app

2019-01-18 Thread mostwanted
was no remove compiled, when i clicked on the design tab it said it can not design the app because it has been compiled. But i have to make updates on this specific app, how do I make my updates??? Please help! Regards Mostwanted -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: Editing a compiled app

2019-01-18 Thread mostwanted
ou use "Pack compiled" to pack just the compiled files of the app, > and then install that compiled version? If so, it does not include the > original source files. Presumably you saved the source files somewhere, > right? > > On Friday, January 18, 2019 at 8:22:13 AM UT

[web2py] Re: Editing a compiled app

2019-01-18 Thread mostwanted
ou use "Pack compiled" to pack just the compiled files of the app, > and then install that compiled version? If so, it does not include the > original source files. Presumably you saved the source files somewhere, > right? > > On Friday, January 18, 2019 at 8:22:13 AM UT

[web2py] Re: decremental subtraction of values in DB field

2019-01-22 Thread mostwanted
('fuelLogging', Field('ODO_Reading', 'integer'), Field('Delta', 'integer', default=0)) db.fuelLogging._before_update.append(fuelLogging_before_update()) I still have a hardtime getting results On Friday, January 18, 2019 at 8:43:36 AM UTC+2,

[web2py] adding fields dynamically in web2y forms

2019-01-23 Thread mostwanted
"), Field("price", "list:integer"), format='%(product)s') In my view i want these details displayed in an html table but they appear in list format, how do i remove them from the list to display them individually na d how do i sum up

[web2py] fixing .table appears corrupted on a compiled application

2019-01-31 Thread mostwanted
\c8b669d15150d7109e5f7ab36744a5b7_quotationClient.table appears corrupted) *but now i can not access the code because to add *migrate=False,fake_* *migrate=True *to the table! Now they can not access the saved information for all orders made What can i do Please help!!! Mostwanted -- Resources

[web2py] Re: fixing .table appears corrupted on a compiled application

2019-02-02 Thread mostwanted
I was able to solve this, i found an old version of the app, after installing it i overwrote it with corrupt version, that gave me the option to remove the compiled version and i was able to edit the code & fix my problem. On Thursday, January 31, 2019 at 7:08:15 PM UTC+2, mostwanted w

[web2py] Re: fixing .table appears corrupted on a compiled application

2019-02-09 Thread mostwanted
gods (nodding toward Greek mythonlogy) >> >> >>>> > Versioning systems for code, more so. > > Mostwanted, if you don't want to start with something heavy and unwieldy > as git, at the very least try Fossil <http://fossil-scm.org> > -- R

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

2019-02-10 Thread mostwanted
't have a code sample for this obviously coz i couldn't implement it, i only have this as an idea, if anyone understands how i could implement this please help out. Regards; Mostwanted -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/

  1   2   3   4   5   >