[web2py] Re: web2py 2.24.1 released

Thanks četvrtak, 23. mart 2023. u 06:20:20 UTC+1 Massimo Di Pierro je napisao/la: > Hello everybody, > > web2py 2.24.1 has been released. > > Thanks to Leonel, Cem, and Mark for bug fixes including: > - handling corrupt disk cache > - broken application packaging > - compare function logic > > >

[web2py] Re: Unable to calculate values of a selected Index

To be clear I didn't come up with this (see my previous post)... Based on the provided code, it seems that the quantity variable is being assigned the same value every time, which is the value of details.quantities[index] for the first item in the list. This is because the details.quantities

[web2py] Re: Unable to calculate values of a selected Index

Try... Field('quantities', 'list:integer', required=True)) On Sunday, 26 March 2023 at 15:04:29 UTC+1 mostwanted wrote: > I want to be able to calculate subtotal by multiplying quantity and price > but I cant because > *var quantity = parseInt("{{=details.quantities[index]}}");* in the >

[web2py] ChatGPT's advice re adding a table to an existing db

I had a 'conversation' with ChatGPT about adding a table and found it enlightening maybe others will... *I want to add a new table to existing web2py DAL db what migrate setting should i use* Web2py's DAL (Database Abstraction Layer) supports migrations, which are used to apply database

[web2py] Re: pyCharm

ects here > except: > pass > > That way you'll be able to use the code completion in web2py - should work > with VS Code, PyCharm or any modern IDE. > > -Jim > > > On Wednesday, November 16, 2022 at 7:18:57 AM UTC-6 Peter wrote: > >> Have been out of t

[web2py] pyCharm

Have been out of the loop for a while but while getting back in to things upgrading and migrating a web2py app to Python 3 (all went well!). In the process I renewed a subscription with JetBrains PyCharm and am discovering (see below) they have dropped support for web2py. The only reason for

Re: [web2py] QR code generation from markmin

embedded and linking the said URL. -- I can write custom code to do it, but didn't want to reinvent the wheel if Web2py already had it! Thanks! --Peter On Wednesday, March 3, 2021 at 2:38:31 AM UTC-5 kell...@gmail.com wrote: > Hey Peter! > > I don't see any code in the markmin pyth

[web2py] QR code generation from markmin

eems a useful feature if it really exists in there! :) Thanks, --Peter -- 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 a

[web2py] Re: File Manager plugin

Work fine on python 2.7 but on python 3.6 or python 3.7 I have an error: ERROR:Rocket.Errors.Thread-4:Traceback (most recent call last): File "/web2py/gluon/rocket.py", line 1319, in run self.run_app(conn) File "/web2py/gluon/rocket.py", line 1812, in run_app self.environ = environ

[web2py] Re: [py4web] - how to disable some auth actions?

This is exactly what I need/ do. One vote for this request. субота, 28. март 2020. 21.55.06 UTC+1, Paolo Caruccio је написао/ла: > > In my case I only need login and logout. > The creation of an account will be done by other users with privileges > established by the administrators. The

[web2py] email form

I am a newbie. I have forms on my website with a send button. Actually they work fine without an error, but there is a significant problem. I do not receive the by clients filled out forms in my G-mailbox. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Changes to stripe

According to stripe, we need to change the checkout methodology for stripe, at least in Europe. The example they give now is. client.html https://js.stripe.com/v3";>Pay client.js var stripe = Stripe('pk_test_TYooMQauvdEDq54NiTphI7jx'); var checkoutButton =

Re: [web2py] download for mac not working

Ah, thanks Nico! I’ll check over there! -- 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 the

[web2py] download for mac not working

n and the normal users version, and in both cases I get the same error. I'm running on a macbook air with macOS 10.12.6. I've got older versions of web2py (v 2.17.2) that I downloaded in the same way, and these work fine on this same machine. Thoughts? Thanks! --Peter -- Resources: - http://web2p

[web2py] Re: SQLFORM.smartgrid exportclasses

tricking the smartgrid > code into finding what it is looking for. > > Anthony > > > On Tuesday, November 14, 2017 at 12:57:25 AM UTC-5, Peter wrote: >> >> I need only csv export method from SQLFORM.smartgrid so I want to >> disable default expor

[web2py] Re: Problem with wsgihandler.py Apache/Python3

In my environment this work. Of course, after that you should enable admin through http or configure https. This correction only enable to see what is problem. web2py/applications/admin/models/access.py # original code elif not request.is_local and not DEMO_MODE: raise HTTP(200, T('Admin

[web2py] Re: SQLFORM.smartgrid exportclasses

Thank you. I will consider this option on next project :) On Wednesday, December 5, 2018 at 1:16:52 PM UTC+1, Tomasz Wrona wrote: > > Maybe this information will help you. If you use SQLFORM.grid it will > work. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Problem with wsgihandler.py Apache/Python3

Similar situation can happen when you try to access admin page through simple http protocol over network. Web2py will raise exception and we got that error: TypeError: sequence of byte string values expected, value of type str found Code responsible for that error is: if request.is_https:

[web2py] Re: Problem with wsgihandler.py Apache/Python3

ure release.") > [Thu Nov 15 05:03:10.875093 2018] [wsgi:error] [pid 9668] [remote > XXX.XXX.XXX.AF:34126] result = self._query(query) > > Is it possibly related to this?: > > stackoverflow: TypeError: sequence of byte string values expected, value > of type str foun

[web2py] Re: Problem with wsgihandler.py Apache/Python3

Try to remove all session files. I think that problem is in pickle which is different in python 2 and python 3 (data type is not same in python 2 and python 3). -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Ubuntu web2py

No pressure! but Ubuntu 9.04 is unsupported at this stage and probably not even getting security updates. There may be good reason not to (e.g. impact on other apps/requirements) but I would recommend a fresh install of Ubuntu 18.04 LTS (or Linux Mint 18 which is based on Ubuntu ) rather

[web2py] Re: heroku, web2py and gunicorn

In case it's of any benefit. Just installed LinuxMint 18 on my laptop, installed gunicorn from the software manager python anyserver.py -s gunicorn starting gunicorn on 127.0.0.1:8000... [2018-08-03 02:09:42 +] [31660] [INFO] Starting gunicorn 19.4.5 [2018-08-03 02:09:42 +] [31660]

[web2py] Re: web2py internal error

Glenn the answer above I have got from pythonanywhere. my hosting is overthere. Op dinsdag 17 juli 2018 00:18:34 UTC+2 schreef Anthony: > > On Monday, July 16, 2018 at 3:18:44 PM UTC-4, Peter Hendriks wrote: >> >> Ticket issued: >> malta_advies/141.8.9.39.2018-07-16.13-

[web2py] Re: web2py internal error

I can go in to the admin by typing https://www.maltaa-advies.nl/admin then I get the login screen for admin. Op dinsdag 17 juli 2018 00:12:29 UTC+2 schreef Dave S: > > > > On Monday, July 16, 2018 at 12:18:44 PM UTC-7, Peter Hendriks wrote: >> >> Ticket issued: >>

[web2py] web2py internal error

Ticket issued: malta_advies/141.8.9.39.2018-07-16.13-01-34.2270ef94-db9a-47a5-8866-f081bdf9715f Since this morning the above I see when I type my website. for

[web2py] Payment integration documentation needs update

ago, but hopefully some of the other paths will be more fruitful! Thanks, --Peter --Peter -- 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

[web2py] Re: VIEW NAME NOT ID

instead of this code: {{=row[db.product_input.product]}} try this (not tested) {{=row.product.SOME_FIELD_NAME_FROM_PRODUCT_TABLE}} On Monday, April 30, 2018 at 7:53:20 PM UTC+2, Ayron Rangel wrote: > > I have this: > > db.py: > db.define_table('product_input', > Field('product',

[web2py] Re: Import application from staging to production server

I don't understand the 'local_import' in this line pygal = local_import('pygal') > > Can't find it in the documentation for web2py, pygal or searching python local_import... but pygal works for me using just... import pygal > -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] SQLFORM.smartgrid exportclasses

I need only csv export method from SQLFORM.smartgrid so I want to disable default export methods. Seems to me that SQLFORM.smartgrid(exportclasses=dict(json=False)) doesn't work in newer versions of web2py (2.14.6). My code: export_classes = dict(json=False, html=False,

[web2py] Re: back button

Hi Andrea, The solution is probably in this post ... https://groups.google.com/forum/#!topic/web2py/z6lOXNgGws8 Hope this helps! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Parent - Child (multiple rows / grid) form development

the Company and Line_items tables). (If I understand it correctly, this is where web2py Components, mentioned by Dave, would come in useful, allowing re-use of code. With a bit of tweaking I think the same code could provide both views). Regards Peter On Wednesday, 12 July 2017 13:55:46 UTC+1

[web2py] Re: Parent - Child (multiple rows / grid) form development

Thanks for correcting this Dave. (Will have to read up on components). Peter -- 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

[web2py] Re: Parent - Child (multiple rows / grid) form development

elds to represent the invoice lines))) return dict(invoice_header=invoice_header, invoice_lines=invoice_lines) and the view... {{extend 'layout.html'}} {{=invoice_header}} {{=invoice_lines}} Hope this helps! Peter On Monday, 10 July 2017 20:56:58 UTC+1, Ramesh Meda w

[web2py] Re: change login page layout

Hi Anthony, I wasn't sure if what I was doing was just a hack or how far it might impact. e.g if the application included some function with 'user' in the name like 'def ..user..()' it too would pick up the alternate layout (I think). Peter -- Resources: - http://web2py.com - http

[web2py] Re: How to debug via admin?

before the error occurs (or several breakpoints). then use 'Step' (or the other options) to step/skip through the code and observe whats happening on the lead up to the break. Hadn't looked at debug before but it's cool! Regards Peter -- Resources: - http://web2py.com - http://web2py.com

[web2py] Re: change login page layout

'}} with {{if not 'user' in request.env.path_info:}} {{extend 'layout.html'}} {{else:}} {{extend 'mylayout.html'}} Regards Peter -- 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: ValueError: invalid literal for long() with base 10:

the > error. In the event that the error-handling page itself returns an error, web2py > will fall back to its old static responses. > Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.co

Re: [web2py] Re: SQLFORM.grid with selectable checkboxes that export CSV files on submit

so the loop in the calling function doesn't continue to any subsequent request) I would be interested to here if "buttons_placement = 'right' " does what I think it is is supposed to... Did the check-boxes, in your initial coding, appear on right? Regards Peter -- Resourc

Re: [web2py] Re: SQLFORM.grid with selectable checkboxes that export CSV files on submit

Based on previous code, the companies query/function would look something like... def csv_companies(): # assumes there is a table called 'company'with field 'name' query = db.company.id > 0 companies = db(query).select(db.company.id,

[web2py] Re: SQLFORM.grid with selectable checkboxes that export CSV files on submit

utput reports: received vars run report csv_activities run report csv_companies Hope this helps! Peter -- 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

[web2py] Re: FPDF "ne commence pas par '%PDF-' "

Usually I'm the one getting the help J-Michel, So I'm very happy to have helped someone out for a change! Regards Peter -- 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: FPDF "ne commence pas par '%PDF-' "

Have been outputting pdfs for a while and this is what works for me ... note, I don't close the pdfpdf.close? but this allows the user to either open or save the file anywhere on their machine (Linux and Windows) pdf.cell( ln=0, h=9.0, align='R', w=178.0, txt="%s %s" %

[web2py] Re: How to use FORM, INPUT to create a field with dropdown list?

held in the cookie 'session.your _name' but if you want the table id then, replace...session.your_name = form.vars.your_name with something like ... session.person_id = form.vars.id Hope this helps. Peter -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: query re grid signature

That sorted it Stefan - Thanks ! (one more thing to remember when I'm migrating the app to the cloud or I might just leave it as it as doesn't seem to get in the way of anything). Regards Peter On Tuesday, 13 June 2017 02:16:25 UTC+1, 黄祥 wrote: > > i think it's normal, seems you didn

[web2py] query re grid signature

t just normal with a grid? Regards Peter -- 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 the

[web2py] Re: Trying to use a variable as a field name in a table insert

nd others give to the forum and noobs like me - I'd be lost without it!* Incidentally, I may have another query to post, so hoping for some more support shortly! Regards Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/

[web2py] Re: Trying to use a variable as a field name in a table insert

. Will give it a go so, thanks Anthony! Thanks Peter -- 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

[web2py] Re: Trying to use a variable as a field name in a table insert

f=payment.id, invoice_ref=record.id, amount_allocated=allocation) Thanks for talking the time to explain Anthony! Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: Trying to use a variable as a field name in a table insert

Thanks for that Anthony! (I have a feeling of deja vu about that one) If you have time can you tell me what you mean... That's not valid Python code I'm not sure what it refers to and would like understand where I am doing something wrong. Regards Peter -- Resources: - http

[web2py] Trying to use a variable as a field name in a table insert

Error (taking ref_field literally and not substituting the variable's assigned value) Is this possible to achieve what I want? Any pointers would be appreciated. Thanks Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: How to access selected fields/objects in SQLFORM.grid as opposed to grid row ids

items." IT IS RETURNING THE task.id There was a one to one mapping of row position to actual task.ids and for reasons too long to go into at this hour I wasn't expecting the tasks to be in their natural .id order - reversing the sort order highlighted that it is in fact the task id

[web2py] How to access selected fields/objects in SQLFORM.grid as opposed to grid row ids

see, instead it appears to me to be returning the grid row ids for checked items. My problem is that I can't see how to convert/relate this list of selected grid row ids to the required task objects or db.task.id field? As always any help would be appreciated. Regards Peter -- Resources

[web2py] Re: SQLFORM.grid - trying to limit search filter to queried items not entire table items

it to the query filter, my view will only present activities belonging to the person negating any need to search by person. Peter The simplest alternative might be to use a computed field. Alternatively, > you could further develop your approach of adapting the db.task.person > field fo

[web2py] SQLFORM.grid - trying to limit search filter to queried items not entire table items

I have a person table and a task table, every task references some person. Both tables have a virtual field 'display_name' that constructs a meaningful coded name returned as a string to display on screen if person is a 'client'. SQLFORM.grid is used to provide a selectable list of

[web2py] Re: List reference counting elements

Have not tested this but it think something like adding the last line below... {{for row in formListar:}} {{=row.movies.title}} {{=row.movies.categories}} {{=len(row.movies.categories)}} On Tuesday, 30 May 2017 02:38:01

[web2py] Re: Can't get compute field or virtiual field to work for me

STOP PRESS - Got it! So I've learned something new - *thanks again Anthony!* Still not paying enough attention to the tracebacks - subsequent errors were a different problem. for the record this virtual field definition... db.person.display_name = Field.Virtual('display_name',

[web2py] Re: Can't get compute field or virtiual field to work for me

n the updated fields. The > compute function will not fetch non-updated fields from the database in > order to calculate the computed value. > > >> and for the seond method'DisplayName: %s' % person.display_name >> >> I get an attribute error... >>

[web2py] Re: how to compare date time in web2py?

I had some fun with this max_age_allowed = 20 * 60 # total seconds in 20 minutes update_age = request.now - person.created_on # Duration in datetime format since record created update_age = update_age.total_seconds() # Duration converted to seconds print "It is %s seconds since record

[web2py] Can't get compute field or virtiual field to work for me

e edited the table - which I understand should trigger the shortname update) I get 'ShortName: None' and for the seond method'DisplayName: %s' % person.display_name I get an attribute error... Traceback (most recent call last): File "/home/peter/web2py/gluon/restricted.py&qu

[web2py] How to import google-api-python-client in web2py?

successfully imported google-api-python-client into a web2py local instance? Is there a setup step I am missing? Full list of modules I am talking about is below, and the google instructions are here: https://developers.google.com/api-client-library/python/start/installation Thank you! Peter

[web2py] Re: 'Column table.id not found (SQLTABLE)'

from windows compiled distribution of web2py and everything works fine. I am guessing that there is some missing or misversioned library that creates a bad insert statement screwing up the db. Thanks, Peter Exhibit A - my install from source had problems. Here is how I installed web2py

Re: [web2py] Re: https causes site to be in text

the problem. I will suggest that the script for nginx and uswgi on centos 7 is updated. Thanks for your positive feedback Dave S. Thanks for you help everyone. Peter > >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (So

Re: [web2py] Re: https causes site to be in text

and https behaviour. Peter On Thu, Dec 1, 2016 at 8:23 AM, Dave S <snidely@gmail.com> wrote: > > > On Thursday, December 1, 2016 at 12:23:26 AM UTC-8, Dave S wrote: >> >> >> >> On Tuesday, November 29, 2016 at 9:35:10 AM UTC-8, peter wrote: >&

[web2py] Re: https causes site to be in text

In my routes.py I have routes_in = ((r'.*://spinjazz.net:\w* /static/$anything', r'/new_spin2/static/$anything'), presumably this is routing only http correctly can anyone tell me how I can get it to work for https Thanks Peter -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: https causes site to be in text

Thanks Leonel I am not missing the http equivalents, so where is routing different for https to http in web2py? Peter On Tuesday, 29 November 2016 17:05:35 UTC, Leonel Câmara wrote: > > You are missing a bunch of files > > (index):19 GET https://spinjazz.net/new_spin2/static/

[web2py] https causes site to be in text

Peter -- 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 the Google Groups "web2py-users&q

[web2py] Re: problem with sqleditable

db.purchase_order_product.created_by.readable=db.purchase_order_product.created_by.writable=True db.purchase_order_product.created_on.readable=db.purchase_order_product.created_on.writable=True Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: How to cleanly pass FPDF output object to os Download/Save dialogue box

Just to close this off. I think I am in a bit of a catch 22.. Because the behaviour *is exactly what I want *i.e. stream goes straight to download option, I don't get the open/save dialogue so can't change the setting and after reading this (possibly related Firefox bug report)*

[web2py] Re: How to cleanly pass FPDF output object to os Download/Save dialogue box

f? When I have finished checking it out I will post to confirm this is the solution and thanks again guys for your assistance! Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.go

[web2py] Re: How to cleanly pass FPDF output object to os Download/Save dialogue box

nt; filename="%s"' % rcpt_filename To summarise the issue, It is sufficient that the user is prompted to download and save the PDF - and this is working!. The only change that is needed now is how to prevent Adobe automatically opening the PDF as well? Regards Peter -- Reso

[web2py] Re: How to cleanly pass FPDF output object to os Download/Save dialogue box

On Sunday, 16 October 2016 05:24:10 UTC+1, Peter wrote: > > > > I have this code that doesn't work too well... > > > import os > import sys > pdf = receipt_PDF() > pdf.add_page() > rcpt_filename = "RCPT_%s_%s.pdf" % (session.rcpt_number,

[web2py] Re: How to cleanly pass FPDF output object to os Download/Save dialogue box

ly opens Adobe Reader as well and displays the file (a little overkill!) (It also creates temp files on the system that may/may not need to be cleaned up - but that's for another day.) *Can I stop it automatically opening the file in Adobe and if so how?* Peter -- Resources: - http://web2

[web2py] How to cleanly pass FPDF output object to os Download/Save dialogue box

object not this?) with Stringio in the mix? Any assistance with the specifics needed to accomplish what I am looking for above would be appreciated! Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - ht

[web2py] Re: Help needed to understand/utilise a CSS element

On Monday, 3 October 2016 16:08:32 UTC+1, Marlysson Silva wrote: > > 1. Have how you provide this project in github? Stay easier handle with > code , or it's private project? > I have a github account but I haven't figured out how to use it properly yet. > 2. A good practice it's generate

[web2py] Re: Help needed to understand/utilise a CSS element

Just to be clear This code (with 'type' being assigned) > { type: '{{=row.task.task_type}}', > title: '{{=row.task.task_status}} {{=row.task.task_type}} > {{=row.person.fullname.replace("'","\\'")}} ', > allDay: false, > start: new Date('{{=row.task.start_time.strftime('%B %d, %Y

[web2py] Re: Help needed to understand/utilise a CSS element

This is what my code looks like now but is still not working (page displays but there is no calendar) Can you explain using line reference numbers where it is wrong or where something is missing? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Help needed to understand/utilise a CSS element

oop) assigning them to a variable 'event' and passing that to eventRenderCallback? * I am really in the dark here! Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Repor

[web2py] Re: Help needed to understand/utilise a CSS element

{ background-color: black; border-color: black; color: blue; } then how to I call it from the calendar view included (see original post)? Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Help needed to understand/utilise a CSS element

w_task',args=row.task.id)}}' }, {{pass}} ] }); This works to display the calendar events but they all have the same background colour of blue How do I implement the CSS so each event background colour changes depending on {{=row.task.task_type}} Many thanks, Peter -- Resources: -

[web2py] Re: SQLFORM key error on simple table with one record

interest in the issue! Peter -- 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 the Google Groups

[web2py] Re: SQLFORM key error on simple table with one record

If there is anything stupid here Anthony, please remember I am a novice at this! db.define_table('invoice', Field( 'invoice_number' , 'integer' , writable=False), Field( 'company' , writable=False), Field( 'amount' , 'decimal(6,2)' , writable=False), Field(

[web2py] Re: SQLFORM key error on simple table with one record

ithout Traceback :-) for the record The default dal version with the web2py install is Version 16.03 and list open files confirms the dal in use is the web2py one. That got me out of a big hole Anthony! Go raibh mile maith agat! (*Thank you very much!*) Peter -- Resources:

[web2py] Re: SQLFORM key error on simple table with one record

ant app folder/s? And if so... - Will the gluon <https://github.com/web2py/web2py/tree/master/gluon>/ *__init__.py* code you highlighted still ignore it? And if so... - How do I force web2py to use its own versions? Thanks again for the interest and assistance Anthony Pete

[web2py] Re: SQLFORM key error on simple table with one record

I created a duplicate table db.payment2 which gave the same error so I went through the fields one by one... This one change in the table definition avoids the Traceback and the form displays as expected! Field( 'invoice_ref' ), Applied the same change to the original and it now opens

[web2py] Re: SQLFORM key error on simple table with one record

Just realised that the traceback shows web2py is using the system installed python pydal /usr/local/lib/python2.7/dist-packages/pydal all the files under this are dated May 17 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: SQLFORM key error on simple table with one record

1.2.6, Python 2.7.3) Is there another way to check and report on this? Peter -- 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

[web2py] SQLFORM key error on simple table with one record

I'm punch drunk from looking at this one! Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. Traceback (most recent call last): File "/home/peter/web2py/gluon/restricted.py", line 227, in restricted exec ccode in environment File &q

Re: [web2py] Re: pysqlite2.dbapi2.OperationalError'> near "<": syntax error

The double db reference was definitely part of the problem but wasn't the whole story. I made a mistake in one of the field names... specifically AND (task.*task_status* = 'BILLABLE') should have been AND (task.*payment_status*="BILLABLE")); I actually had it correct in the SQL

Re: [web2py] Re: pysqlite2.dbapi2.OperationalError'> near "<": syntax error

Error after changing .select()to._select() Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. Traceback (most recent call last): File "/home/peter/web2py/gluon/restricted.py", line 227, in restricted exec ccode in environment File "/home/peter/web2py/appl

Re: [web2py] Re: pysqlite2.dbapi2.OperationalError'> near "<": syntax error

est.now , writable=False , readable=False ), format= '%(person)s %(start_time)s %(task_type)s %(task_status)s %(charge)s') with the modified code I am still getting the same error Traceback Traceback (most recent call last): File "/home/peter/web2py/gluon/restricted.py", line 227

[web2py] pysqlite2.dbapi2.OperationalError'> near "<": syntax error

elsewhere? You will have to trust me when I say I have put hours of frustration and reading into this and I only post here as a last resort! Many thanks for your consideration! Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Sourc

[web2py] Re: How to get dropdown options working on nav-bar

> That may be from the Bootstrap2 days. > I put some time in last night trying to understand the how/why and think I have a handle on it, thanks again for the pointers Dave. It may be useful to other noobs so my lessons learned... I started to develop using an existing Free CSS Template

[web2py] Re: How to get dropdown options working on nav-bar

Thanks Dave, stupid.css doesn't look so stupid! but there will be a learning curve for me to understand it and the more I look at the more I need to understand css better. The change to Bootstrap3 limited the nesting levels of submenus ... only 1 > sub-level now, I believe. This was a

[web2py] How to get dropdown options working on nav-bar

I am trying to get a menu item to display additional selectable drop down options... *default.pyif auth.user:response.menu=[ ( 'Home' , False , url( 'index' ) , []), ( 'Companies' , False , url( 'list_companies' ) , []),

[web2py] Re: Preserving objects sort order between controller and view

is not even responding to pings Re your comment... > Okay, we'll keep an eye out for a follow-up. Perhaps there was a browser > glitch involved. you are being very kind, I think in reality it's a Peter Glitch :-) but hey I'm learning! I've given up (for today) *but I will be back!

[web2py] Re: Preserving objects sort order between controller and view

was working are still there but currently not available until I do some adjustments to let them invoice again - so I will try them again tomorrow just to see if there was something in there that I am missing. Thanks again! Peter -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] First Post so not a question

Hi I'm Peter from Ireland, I've just joined this mailing list and I want to say thank you, before I start asking questions! So a huge thank to Massimo for web2py and Guido for Python! As a wannabe programmer I have spent considerable time over the last two or three years doing online

[web2py] Preserving objects sort order between controller and view

My first question and I hope it's not a dumb one! My controller retrieves a number of rows from a table and I use *orderby= 'start_time' *to sort the list into date order. I can see this produces the desired result because when I output the rows to the log file the dates appear in the required

[web2py] Re: Scheduler not finding module

. I hate not getting to the bottom of problems even when they appear to go away. Thanks again for your help Niphlod. Clearly it could well be an envelope issue. I had hoped that by explicitly using 'python2.6' the same python would always be used. Peter -- Resources: - http://web2py.com

[web2py] Re: Scheduler not finding module

I am in the wilds of France with very little access to Internet. Will continue in one week. Great support as ever Niphlod. Thanks Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py

  1   2   3   4   5   >