[web2py] Re: How to use HTML escapes in Field titles

2017-07-26 Thread Joe Barnhart
Thank you for your help, Anthony. -- Joe -- 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 Goog

[web2py] Re: Error with autocomplete in version 2.15.2

2017-07-26 Thread domezzzz
That array (# 1571) is contained in version 2.15.2 that I have. I'll post the problem on Github. Thank Anthony. El miércoles, 26 de julio de 2017, 22:56:53 (UTC-3), Anthony escribió: > > I suppose it must have been this commit: > https://github.com/web2py/web2py/commit/7a5f611e7694016889e33a0251

[web2py] Re: Error with autocomplete in version 2.15.2

2017-07-26 Thread domezzzz
Ok. I will try it and then confirm. El miércoles, 26 de julio de 2017, 22:56:53 (UTC-3), Anthony escribió: > > I suppose it must have been this commit: > https://github.com/web2py/web2py/commit/7a5f611e7694016889e33a02518de7eb8c5c99f2 > . > > Please post an issue on Github. > > Anthony > > On Wed

[web2py] Re: Error with autocomplete in version 2.15.2

2017-07-26 Thread Anthony
I suppose it must have been this commit: https://github.com/web2py/web2py/commit/7a5f611e7694016889e33a02518de7eb8c5c99f2. Please post an issue on Github. Anthony On Wednesday, July 26, 2017 at 8:18:31 PM UTC-4, dome wrote: > > Versión: web2py.exe para windows 2.15.2 > > When entering data

[web2py] Re: How to use HTML escapes in Field titles

2017-07-26 Thread Anthony
> > As far as my table comment, I meant that when I used the SQL table and its > Fields to create an SQLTABLE, the labels "just worked" and produced a > column header with the desired symbol instead of printing "≤" in the > column heading. So SQLTABLE behavior differed from SQLFORM in this man

[web2py] Re: How to use HTML escapes in Field titles

2017-07-26 Thread Joe Barnhart
Actually I've thought a little more about it and I think this construction is better. elapsed_time_field("lcm_gt",label=XML(T("LCM %s",(">",, elapsed_time_field("lcm_le",label=XML(T("LCM %s",("≤",, elapsed_time_field("scm_gt",label=XML(T("SCM %s",(">",, elapsed_time_field("scm_le",lab

[web2py] Re: Error with autocomplete in version 2.15.2

2017-07-26 Thread domezzzz
I did not clarify it in my post; That I had updated all the js in the app with those of the 2.15.2 of Welcome. The post is still open Anthony. El miércoles, 26 de julio de 2017, 21:18:31 (UTC-3), dome escribió: > > Versión: web2py.exe para windows 2.15.2 > > When entering data in the autoco

[web2py] Re: Error with autocomplete in version 2.15.2

2017-07-26 Thread Anthony
Not sure it will make a difference, but did you update web2py.js along with the framework? On Wednesday, July 26, 2017 at 8:18:31 PM UTC-4, dome wrote: > > Versión: web2py.exe para windows 2.15.2 > > When entering data in the autocomplete field, the candidate values are not > displayed. > Wh

[web2py] Re: How to use HTML escapes in Field titles

2017-07-26 Thread Joe Barnhart
Hi Anthony -- The problem is that I don't want "LT" but rather "LE", i.e. "less than or equal to." As far as my table comment, I meant that when I used the SQL table and its Fields to create an SQLTABLE, the labels "just worked" and produced a column header with the desired symbol instead of p

[web2py] Error with autocomplete in version 2.15.2

2017-07-26 Thread domezzzz
Versión: web2py.exe para windows 2.15.2 When entering data in the autocomplete field, the candidate values are not displayed. When you enter, it indicates an invalid value. And an image in transparent format appears and disappears from the first part of the displayed panel. The panel, is to inse

[web2py] Re: How to use HTML escapes in Field titles

2017-07-26 Thread Anthony
On Wednesday, July 26, 2017 at 7:43:14 PM UTC-4, Joe Barnhart wrote: > > It's even worse than I imagined. > > Leaving off the T() operation, I find that my field labeled "LCM >" is > actually sanitized at some point into: > > id="event_join_lcm_gt__label">LCM >: > > Yes, something in the process

[web2py] Re: How to use HTML escapes in Field titles

2017-07-26 Thread Joe Barnhart
It's even worse than I imagined. Leaving off the T() operation, I find that my field labeled "LCM >" is actually sanitized at some point into: LCM >: Yes, something in the process has *recognized* the character ">" and changed it to ">" But the field "LCM ≤" was sanitized into: LCM ≤:

[web2py] Re: best practice for create table base on user insert

2017-07-26 Thread 黄祥
yes, the new tables same for all which is base on detail_coa. the idea is to separate it is base on the case e.g. user input data on chart_of_account table e.g. : -cash -bank a -bank b the same thing goes for account table that automatically create chart_of_account table to maintain the data of

[web2py] Re: scheduler worker process looks frozen, stuck in state 'PICK'

2017-07-26 Thread Dave S
On Wednesday, July 26, 2017 at 7:41:58 AM UTC-7, Brendan Fox wrote: > > So I've noticed that every few days my scheduler task appears to be > frozen. New tasks are put into the queue, but are not being processed. > When I look at the status of the single worker process in the system the > db

[web2py] Re: One form for two relationshiped tables using SQLFORM.factory not working

2017-07-26 Thread Leonel Câmara
There's already a fix for this by Tim Nyborg waiting to be merged: https://github.com/web2py/web2py/pull/1692 -- 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) -

[web2py] Re: sqlform.grid maxtextlengths shoots blanks

2017-07-26 Thread Anthony
On Tuesday, July 25, 2017 at 8:32:55 PM UTC-4, Seth J wrote: > > I have a similar problem with maxtextlengths and I do have the "represent" > attribute set like so: > Field('f_last_change', type='text', > label=T('Latest Changes'), > defa

[web2py] Re: One form for two relationshiped tables using SQLFORM.factory not working

2017-07-26 Thread Anthony
Please open a Github issue (linking to this thread), as this is a bug that was recently introduced. Field objects must now be cloned, but the new code does not take into account that arguments to SQLFORM.factory can also be tables (which do not have a .clone() method). Anthony On Wednesday, Ju

[web2py] Re: Master-detail code example

2017-07-26 Thread Anthony
Have a look at http://www.web2pyslices.com/slice/show/1542/manage-users-and-memebership-in-the-same-form. You might also consider using SQLFORM.smartgrid. Anthony On Wednesday, July 26, 2017 at 10:42:04 AM UTC-4, Jota wrote: > > Hi > > I am looking for web2py example code of a maintenance form

[web2py] scheduler worker process looks frozen, stuck in state 'PICK'

2017-07-26 Thread Brendan Fox
So I've noticed that every few days my scheduler task appears to be frozen. New tasks are put into the queue, but are not being processed. When I look at the status of the single worker process in the system the db.scheduler_worker.status = 'PICK'. I don't see this in the web2py docs anywhere.

[web2py] Master-detail code example

2017-07-26 Thread Jota
Hi I am looking for web2py example code of a maintenance form for a master-detail tables (module, view and controller for learning) An example to share? Thanks in advance -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] MS-SQL DAL Problem

2017-07-26 Thread Jacob König
Hi all, since updating from 2.14.6 to 2.15.2 I have a problem with accessing a remote MS-SQL Database. It does not recognize certain fields and always gives me an "incorrect syntax" error. This is the test with the "old" gluon: >>> from gluon2146 import DAL, Field >>> py = DAL("mssql://DRIVER={

[web2py] One form for two relationshiped tables using SQLFORM.factory not working

2017-07-26 Thread joaovictor_rj
I'm trying to expose a form with 2 SQLite tables behind it. I read the documentation, did as recommended and got the following error: Traceback (most recent call last): File "/home/joao/Desktop/web2py/gluon/restricted.py", line 219, in restricted exec(ccode, environment) File "/home/joao/

[web2py] Re: best practice for create table base on user insert

2017-07-26 Thread Anthony
Is detail_coa the same or nearly the same for all of these tables? If so, do you really need separate tables, rather than a single table that simply includes an extra field on which to partition it? On Tuesday, July 25, 2017 at 11:12:34 PM UTC-4, 黄祥 wrote: > > let say i have table that will crea

[web2py] Re: upload an excel sheet to be added to the system

2017-07-26 Thread Anthony
Note, if you have a new question, it is better to simply create a new topic rather than adding to a thread that is several years old. On Wednesday, July 26, 2017 at 5:30:11 AM UTC-4, kesh wrote: > > how can i import excel row into a web2py sqlite table > > On Wednesday, 2 February 2011 16:30:26 U

[web2py] how to use sum() in grid

2017-07-26 Thread kesh
hello sir i hope you are ok, well i have been having a problem with some code here and have searched all over the internet but i was not able to get a solution MODEL db.define_table('t_stck_issue', Field('f_name', type='reference t_items', label=T('Name')), Field('f_stck_client',

[web2py] Re: upload an excel sheet to be added to the system

2017-07-26 Thread Dave S
On Wednesday, July 26, 2017 at 2:30:11 AM UTC-7, kesh wrote: > > how can i import excel row into a web2py sqlite table > > If the excel data is in CSV format, you can import that directly. http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Exporting-and-importing-data>

[web2py] Re: More complicated grid question, using field.sum()

2017-07-26 Thread Dave S
On Wednesday, July 26, 2017 at 12:18:17 AM UTC-7, kesh wrote: > > sorry if i am off topic, i am abit stuck >> > What is your question? /dps > i got the model > > db.define_table('t_stck_issue', > Field('f_name', type='reference t_items', > label=T('Name')), > Field('f_stck_

[web2py] Re: upload an excel sheet to be added to the system

2017-07-26 Thread kesh
how can i import excel row into a web2py sqlite table On Wednesday, 2 February 2011 16:30:26 UTC+3, Neveen Adel wrote: > > Hello, > > Is there a library that can be used to import an excel file that > insert records in a specific table ? > > If there is no a library how can i do that ? > > T

[web2py] Re: More complicated grid question, using field.sum()

2017-07-26 Thread kesh
> > sorry if i am off topic, i am abit stuck > i got the model db.define_table('t_stck_issue', Field('f_name', type='reference t_items', label=T('Name')), Field('f_stck_client', type='reference t_clients', label=T('Client Assgn')), Field('f_stck_quantity', type='in