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

[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='integer',
  label=T('Stock Quantity')),
Field('f_unit_price', type='double',
  label=T('Unit Price')),
Field('f_sub_total',type='double', compute=lambda 
r:r['f_unit_price']*r['f_stck_quantity'],
  label=T('Sub Total')),
auth.signature,
format='%(f_name)s',
migrate=settings.migrate)

db.define_table('t_stck_issue_archive',db.t_stck_issue,Field('current_record','reference
 
t_stck_issue',readable=False,writable=False)) 

AND THE CONTROLLER
def stck_issue_manage():
#form = SQLFORM.smartgrid(db.t_stck_issue,onupdate=auth.archive)
form = SQLFORM.grid(db.t_stck_issue)
myrow=db().select(db.t_stck_issue.f_sub_total.sum())[0]
answer=myrow._extra['SUM(t_stck_issue.f_sub_total)']
return locals()

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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 ? 
>
> Thanks in Advance

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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_client', type='reference t_clients',
>   label=T('Client Assgn')),
> Field('f_stck_quantity', type='integer',
>   label=T('Stock Quantity')),
> Field('f_unit_price', type='double',
>   label=T('Unit Price')),
> Field('f_sub_total',type='double', compute=lambda 
> r:r['f_unit_price']*r['f_stck_quantity'],
>   label=T('Sub Total')),
> auth.signature,
> format='%(f_name)s',
> migrate=settings.migrate)
>
> db.define_table('t_stck_issue_archive',db.t_stck_issue,Field('current_record','reference
>  
> t_stck_issue',readable=False,writable=False)) 
>
> AND THE CONTROLLER
> def stck_issue_manage():
> #form = SQLFORM.smartgrid(db.t_stck_issue,onupdate=auth.archive)
> form = SQLFORM.grid(db.t_stck_issue)
> myrow=db().select(db.t_stck_issue.f_sub_total.sum())[0]
> answer=myrow._extra['SUM(t_stck_issue.f_sub_total)']
> return locals()
>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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>

/dps
 

> 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 ? 
>>
>> Thanks in Advance
>
>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] how to use sum() in grid

[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', type='reference t_clients',
  label=T('Client Assgn')),
Field('f_stck_quantity', type='integer',
  label=T('Stock Quantity')),
Field('f_unit_price', type='double',
  label=T('Unit Price')),
Field('f_sub_total',type='double', compute=lambda 
r:r['f_unit_price']*r['f_stck_quantity'],
  label=T('Sub Total')),
auth.signature,
format='%(f_name)s',
migrate=settings.migrate)

db.define_table('t_stck_issue_archive',db.t_stck_issue,Field('current_record','reference
 
t_stck_issue',readable=False,writable=False))
CONTROLLER
def stck_issue_manage():
#form = SQLFORM.smartgrid(db.t_stck_issue,onupdate=auth.archive)
form = SQLFORM.grid(db.t_stck_issue)
myrow=db().select(db.t_stck_issue.f_sub_total.sum())[0]
answer=myrow._extra['SUM(t_stck_issue.f_sub_total)']
return locals()
VIEW
{{extend 'layout.html'}}

Manage stck_issue{{=form}}
All Issue Totals: {{=answer}}

well it calculates the sub total field for all properly, but i would like 
it to change when i filter by client to do the sub total for that 
particular client only

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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 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 ? 
>>
>> Thanks in Advance
>
>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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 create a new table base on user input on 
> that table
> *e.g.*
> *models/db_schema_1_chart_of_account.py*
> def __after_insert_chart_of_account(f, id):
> name = f['name']
> table_name = name.replace(' ','_').lower()
> filename = os.path.join(request.folder, 'models', 'db_schema_3_%s.py') % 
> (table_name)
> if not os.path.exists(filename):
> define_table = "db.define_table('%s', detail_coa)"  % (table_name)
> file = open(filename, "w")
> file.write('# -*- coding: utf-8 -*-')
> file.write('\n')
> file.write(define_table)
> file.close()
>
> *models/db_schema_2_account.py*
> def __after_insert_account(f, id):
> name = f['name']
> query_ar = (db.chart_of_account.classification == 'Account Receivable')
> row_ar = db(query_ar).select().last()
> code_ar = int(row_ar.code) + 1
> db.chart_of_account.insert(code = code_ar, name = 'Account Receivable %s' 
> % (name), 
>   classification = 'Account Receivable')
> query_ap = (db.chart_of_account.classification == 'Account Payable')
> row_ap = db(query_ap).select().last()
> code_ap = int(row_ap.code) + 1
> db.chart_of_account.insert(code = code_ap, name = 'Account Payable %s' % 
> (name), 
>   classification = 'Account Payable')
>
> *controllers/install.py*
> def index():
> db.chart_of_account.bulk_insert([
> {"code" : "110", "name" : "Account Receivable", 
>  "classification" : "Account Receivable"}, 
> {"code" : "200", "name" : "Account Payable", 
>  "classification" : "Account Payable"}, 
>  ] )
> db.account.bulk_insert([
> {"name" : "Account0"}, 
> {"name" : "Account1"}, ] )
>
> *Question :*
> - is it best practice to do like example code above? tested it with small 
> data (install/index) but feel slow respond, because perhaps, the table in 
> models is load in every request, even the current data is small. any others 
> ideas?
>
> thanks and best regards,
> stifan
>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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/Desktop/web2py/applications/vr/controllers/default.py" 
, line 101, 
in 
  File "/home/joao/Desktop/web2py/gluon/globals.py", line 409, in 
self._caller = lambda f: f()
  File "/home/joao/Desktop/web2py/applications/vr/controllers/default.py" 
, line 55, 
in register_student
form = SQLFORM.factory(db.Pessoa,db.Aluno)
  File "/home/joao/Desktop/web2py/gluon/sqlhtml.py", line 1922, in factory
return SQLFORM(DAL(None).define_table(table_name, *[field.clone() for field 
in fields]),
AttributeError: 'Table' object has no attribute 'clone'



These are my controller and model:
Model:
db.define_table('Pessoa',
Field('nome',required=True,notnull=True),
Field('cpf',required=False,notnull=True,length=11),
Field('data_de_nascimento',type='date',required=False,notnull=True),
Field('cep',notnull=True,length=8),
Field('uf',notnull=True,length=2),
Field('pai',notnull=True),
Field('mae',notnull=True),
Field('identidade',notnull=True,length=13),
Field('expedicao_identidade',type='date',required=False,notnull=True),
Field('tipo_sanguineo',notnull=True,length=3),
Field('orgao_emissor',notnull=True,length=20),
Field('doador',type='boolean', notnull=True),
Field('origem',notnull=True,length=40),
Field('observacao',notnull=True),
auth.signature,
)
db.define_table('Aluno',
Field('pessoa_id', 'reference Pessoa', writable=False, readable=False),
# Field('nota_fiscal_id', 'reference Nota_fiscal', writable=False, 
readable=False),
Field('matricula', notnull=True, length=7),
Field('renach', notnull=True, length=40),
Field('categoria', notnull=True, length=5),
Field('servico', notnull=True),
Field('status', notnull=True),
auth.signature,
)

Controller:
def register_student():
form = SQLFORM.factory(db.Pessoa,db.Aluno)

if form.process().accepted:

id = db.Pessoa.insert(**db.Pessoa._filter_fields(form.vars))
form.vars.client=id
id = db.Aluno.insert(**db.Aluno._filter_fields(form.vars))
response.flash='Aluno cadastrado com sucesso!'

return dict(form=form)

As I said, the controller is like what I read in documentation.
If someone can help I'll be grateful.

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] MS-SQL DAL Problem

[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={FreeTDS};SERVER=SERVERNAME\\INSTANCE;DATABASE=DATABASE;UID=USER;PWD=PASSWORD")
>>> py.define_table('quelle',
... Field('quelleID', type='id', writable=False, 
readable=False, rname='Id',label = 'Quelle ID'),
... Field('QName', readable=False, 
writable=False,rname='Name'),
... Field('quelle_datum', type = 'date',comment='Datum der 
Quelle', label = 'Quellendatum'),
... Field('bemerkung','text', comment='Bemerkung zur 
Quelle', label = 'Bemerkung'),
... rname = 'tQuelle',
... fake_migrate=True
...)

>>>
... rows = py().select(py.quelle.ALL)
>>> for row in rows[0:5]:
... print row.quelleID
...
4514
4515
4516
4517
4518
>>> for row in rows[0:5]:
... print row.quelle_datum
...
2016-09-16
2016-09-16
2016-11-14
2016-09-16
2016-10-18
>>>

and this is with the new one:
>>> from gluon import DAL, Field
>>> py = 
DAL("mssql://DRIVER={FreeTDS};SERVER=SERVERNAME\\INSTANCE;DATABASE=DATABASE;UID=USER;PWD=PASSWORD")
>>> py.define_table('quelle',
... Field('quelleID', type='id', writable=False, 
readable=False, rname='Id',label = 'Quelle ID'),
... Field('QName', readable=False, 
writable=False,rname='Name'),
... Field('quelle_datum', type = 'date',comment='Datum der 
Quelle', label = 'Quellendatum'),
... Field('bemerkung','text', comment='Bemerkung zur 
Quelle', label = 'Bemerkung'),
... rname = 'tQuelle',
... fake_migrate=True
...)

>>> rows = py().select(py.quelle.ALL)
Traceback (most recent call last):
  File "", line 1, in 
  File "/home/jacob/gluon/packages/dal/pydal/objects.py", line 2211, in 
select
return adapter.select(self.query, fields, attributes)
  File "/home/jacob/gluon/packages/dal/pydal/adapters/base.py", line 760, 
in select
return self._select_aux(sql, fields, attributes, colnames)
  File "/home/jacob/gluon/packages/dal/pydal/adapters/base.py", line 716, 
in _select_aux
rows = self._select_aux_execute(sql)
  File "/home/jacob/gluon/packages/dal/pydal/adapters/base.py", line 710, 
in _select_aux_execute
self.execute(sql)
  File "/home/jacob/gluon/packages/dal/pydal/adapters/__init__.py", line 
67, in wrap
return f(*args, **kwargs)
  File "/home/jacob/gluon/packages/dal/pydal/adapters/base.py", line 410, 
in execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
pyodbc.ProgrammingError: ('42000', "[42000] [FreeTDS][SQL Server]Incorrect 
syntax near 'quelle_datum'. (102) (SQLExecDirectW)")
>>>

The table already exists and I am just trying to access the Data. 
If am am trying to only access the ID Field, it works.

>>> rows = py().select(py.quelle.quelleID)
>>> for row in rows:
... print row.quelleID
...
4514
4515
4516

Does anyone know a workaround?

Thanks in advance :)

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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.  What does this state mean 
and how could a scheduler process get stuck in this state?  The only way 
I've recovered is to restart the framework.
Thanks

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Master-detail code example

[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)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Master-detail code example

[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 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)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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, July 26, 2017 at 10:41:58 AM UTC-4, 
joaovictor...@poli.ufrj.br wrote:
>
> 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/Desktop/web2py/applications/vr/controllers/default.py" 
> , line 
> 101, in 
>   File "/home/joao/Desktop/web2py/gluon/globals.py", line 409, in 
> self._caller = lambda f: f()
>   File "/home/joao/Desktop/web2py/applications/vr/controllers/default.py" 
> , line 
> 55, in register_student
> form = SQLFORM.factory(db.Pessoa,db.Aluno)
>   File "/home/joao/Desktop/web2py/gluon/sqlhtml.py", line 1922, in factory
> return SQLFORM(DAL(None).define_table(table_name, *[field.clone() for 
> field in fields]),
> AttributeError: 'Table' object has no attribute 'clone'
>
>
>
> These are my controller and model:
> Model:
> db.define_table('Pessoa',
>   Field('nome',required=True,notnull=True),
>   Field('cpf',required=False,notnull=True,length=11),
>   Field('data_de_nascimento',type='date',required=False,notnull=True),
>   Field('cep',notnull=True,length=8),
>   Field('uf',notnull=True,length=2),
>   Field('pai',notnull=True),
>   Field('mae',notnull=True),
>   Field('identidade',notnull=True,length=13),
>   Field('expedicao_identidade',type='date',required=False,notnull=True),
>   Field('tipo_sanguineo',notnull=True,length=3),
>   Field('orgao_emissor',notnull=True,length=20),
>   Field('doador',type='boolean', notnull=True),
>   Field('origem',notnull=True,length=40),
>   Field('observacao',notnull=True),
>   auth.signature,
> )
> db.define_table('Aluno',
>   Field('pessoa_id', 'reference Pessoa', writable=False, readable=False),
>   # Field('nota_fiscal_id', 'reference Nota_fiscal', writable=False, 
> readable=False),
>   Field('matricula', notnull=True, length=7),
>   Field('renach', notnull=True, length=40),
>   Field('categoria', notnull=True, length=5),
>   Field('servico', notnull=True),
>   Field('status', notnull=True),
>   auth.signature,
> )
>
> Controller:
> def register_student():
>   form = SQLFORM.factory(db.Pessoa,db.Aluno)
>
>   if form.process().accepted:
>
>   id = db.Pessoa.insert(**db.Pessoa._filter_fields(form.vars))
>   form.vars.client=id
>   id = db.Aluno.insert(**db.Aluno._filter_fields(form.vars))
>   response.flash='Aluno cadastrado com sucesso!'
>   
>   return dict(form=form)
>
> As I said, the controller is like what I read in documentation.
> If someone can help I'll be grateful.
>
>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: sqlform.grid maxtextlengths shoots blanks

[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'),
>   default = '',
>   represent=lambda text, row: HTML(XML('' if text is 
> None else text.replace('\n', '')), sanitize=True, 
> permitted_tags=['br/'])
>  )
>
> Any suggestions how to keep the formatting, but still have field 
> truncated?  Thanks!!!
>

The built-in truncation works only with single strings -- it will not 
inspect your HTML and figure out how to do something intelligent with it 
(it is not even clear how you would want to handle truncation with 
multi-line HTML text). You should instead handle any truncation yourself in 
the represent function and set maxtextlength to a large value so the grid 
doesn't do any further truncation.

Anthony

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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.scheduler_worker.status = 'PICK'.
> I don't see this in the web2py docs anywhere.  What does this state mean 
> and how could a scheduler process get stuck in this state?  The only way 
> I've recovered is to restart the framework.
> Thanks
>
>
Roughly speaking, this indicates that you're in the middle of assigning a 
worker to a task (for a detailed answer, look in gluon/scheduler.py). 

I have never seen my scheduler get stuck in that state, so I can't tell you 
much about it.  (The scheduler works very well for me, but I have simple 
needs.)


I think we need more information:

What OS is the server running on?
What database engine are you using?
What is the overall load on your server?
Are there error messages in the scheduler_run table?
How many queued tasks are shown in the scheduler_task table?
If you're not using the defaults, how many workers and how many groups?

/dps


-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[黄祥]

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 the account which is goes to 
"account payable" + str(account.name) or "account receivable" + 
str(account.name) will be calculate for their balance AP or AR

if i'm not separate it into several table when user posting the data the 
calculation to calculate the *balance* field, base on previous record in 
*balance* field on the same table will be messed up

in the past i just use after insert callback for that to update the value 
of balance, but here again we met the condition if there is human error, so 
we can not trace back and update to the correct value, because all of the 
data is updating the balance field without any single history transaction 
track on table, which is i think the best is to store it to separate table 
for that

currently, the new table for separate table, i think when user have a 
mistake before they posting the data, they can correct it in their 
transaction and automatically update the new table base on their coa's data 
in transaction. if they already posting it, it simply just unpost, correct 
and posting again

the problem i met right now is when user update the coa data, how can it 
affect the table created, e.g. change the coa name, i can handle for after 
insert or before delete case, but for update, too many scenario will 
happen. 

so not sure if this best practice or not, in terms of performance or 
complexiity system, any ideas or correction to do it, using web2py way are 
welcome

thanks and best regards,
stifan

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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 ≤: 

In this case, not only was the ≤ *not recognized* by the sanitizer, it 
actually DE-SANITZED it by removing the ampersand and sanitizing it 
separately.

This is the problem with automatic "stuff" -- such as hidden magic 
sanitization.  When it goes wrong, it goes very wrong.  And you need to 
spend hours with the source trying to figure out where it went wrong and if 
there's an easy fix without modifying the distro.

-- 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 Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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 has *recognized* the character ">" and 
> changed it to ">"  But the field "LCM ≤" was sanitized into:
>
>  id="event_join_lcm_le__label">LCM ≤: 
>
> In this case, not only was the ≤ *not recognized* by the sanitizer, it 
> actually DE-SANITZED it by removing the ampersand and sanitizing it 
> separately.
>

Both of the above are encoded as expected -- the ">" character is converted 
to ">", and the "&" character in "<" is converted to "&". This is 
consistent and expected behavior. If you want to end up with "<", then 
why not just start with "<"?

What is your ultimate goal? Do you not want the final HTML to include the 
">" and "<" HTML entities so they display as ">" and "<" on the page?

Also, what do you mean by, "If I use the Field titles directly in a table 
on my own, they work as expected?" In each case, what do you want to 
display on the page, and what are you expecting in the raw HTML?

Anthony

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Error with autocomplete in version 2.15.2

[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 insert record, invoked by the (+) button of a sqlform.grid.

It worked correctly in version 2.14.6 and 2.15.1
This problem occurs in a panel that has been running for months, and has 
not had updates.
Regards.

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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 printing "≤" in the 
column heading.  So SQLTABLE behavior differed from SQLFORM in this manner.

I have found a workaround, finally, which lets me have symbols in both 
forms and tables:

elapsed_time_field("lcm_gt",label=CAT(T("LCM"),XML(" >"))),
elapsed_time_field("lcm_le",label=CAT(T("LCM"),XML(" ≤"))),
elapsed_time_field("scm_gt",label=CAT(T("SCM"),XML(" >"))),
elapsed_time_field("scm_le",label=CAT(T("SCM"),XML(" ≤"))),
elapsed_time_field("scy_gt",label=CAT(T("SCY"),XML(" >"))),
elapsed_time_field("scy_le",label=CAT(T("SCY"),XML(" ≤"))),

I first tried the obvious, letting T() handle the substitution but again, 
that doesn't work.  The &xx; character escapes get printed literally in the 
form label instead of creating the symbol I intended.  So I got around the 
problem with CAT().  Still, an awful amount of work and hassle to 
reverse-engineer and make a work around for something that just should have 
worked.

I'm not sure why &xx; is "sanitized" to begin with.  It seems like an 
extreme form of sanitizing, to eliminate any and all special characters 
from form labels.

-- Joe

On Wednesday, July 26, 2017 at 5:16:55 PM UTC-7, Anthony wrote:
>
> 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 has *recognized* the character ">" and 
>> changed it to ">"  But the field "LCM ≤" was sanitized into:
>>
>> > id="event_join_lcm_le__label">LCM ≤: 
>>
>> In this case, not only was the ≤ *not recognized* by the sanitizer, 
>> it actually DE-SANITZED it by removing the ampersand and sanitizing it 
>> separately.
>>
>
> Both of the above are encoded as expected -- the ">" character is 
> converted to ">", and the "&" character in "<" is converted to 
> "&". This is consistent and expected behavior. If you want to end up 
> with "<", then why not just start with "<"?
>
> What is your ultimate goal? Do you not want the final HTML to include the 
> ">" and "<" HTML entities so they display as ">" and "<" on the page?
>
> Also, what do you mean by, "If I use the Field titles directly in a table 
> on my own, they work as expected?" In each case, what do you want to 
> display on the page, and what are you expecting in the raw HTML?
>
> Anthony
>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Error with autocomplete in version 2.15.2

[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.
> 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 insert record, invoked by the (+) button of a 
> sqlform.grid.
>
> It worked correctly in version 2.14.6 and 2.15.1
> This problem occurs in a panel that has been running for months, and has 
> not had updates.
> Regards.
>
>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Error with autocomplete in version 2.15.2

[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 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 insert record, invoked by the (+) button of a 
> sqlform.grid.
>
> It worked correctly in version 2.14.6 and 2.15.1
> This problem occurs in a panel that has been running for months, and has 
> not had updates.
> Regards.
>
>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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",label=XML(T("SCM %s",("≤",,
elapsed_time_field("scy_gt",label=XML(T("SCY %s",(">",,
elapsed_time_field("scy_le",label=XML(T("SCY %s",("≤",,

-- Joe


On Wednesday, July 26, 2017 at 5:28:01 PM UTC-7, Joe Barnhart wrote:
>
> 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 printing "≤" in the 
> column heading.  So SQLTABLE behavior differed from SQLFORM in this manner.
>
> I have found a workaround, finally, which lets me have symbols in both 
> forms and tables:
>
> elapsed_time_field("lcm_gt",label=CAT(T("LCM"),XML(" >"))),
> elapsed_time_field("lcm_le",label=CAT(T("LCM"),XML(" ≤"))),
> elapsed_time_field("scm_gt",label=CAT(T("SCM"),XML(" >"))),
> elapsed_time_field("scm_le",label=CAT(T("SCM"),XML(" ≤"))),
> elapsed_time_field("scy_gt",label=CAT(T("SCY"),XML(" >"))),
> elapsed_time_field("scy_le",label=CAT(T("SCY"),XML(" ≤"))),
>
> I first tried the obvious, letting T() handle the substitution but again, 
> that doesn't work.  The &xx; character escapes get printed literally in the 
> form label instead of creating the symbol I intended.  So I got around the 
> problem with CAT().  Still, an awful amount of work and hassle to 
> reverse-engineer and make a work around for something that just should have 
> worked.
>
> I'm not sure why &xx; is "sanitized" to begin with.  It seems like an 
> extreme form of sanitizing, to eliminate any and all special characters 
> from form labels.
>
> -- Joe
>
> On Wednesday, July 26, 2017 at 5:16:55 PM UTC-7, Anthony wrote:
>>
>> 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 has *recognized* the character ">" and 
>>> changed it to ">"  But the field "LCM ≤" was sanitized into:
>>>
>>> >> id="event_join_lcm_le__label">LCM ≤: 
>>>
>>> In this case, not only was the ≤ *not recognized* by the sanitizer, 
>>> it actually DE-SANITZED it by removing the ampersand and sanitizing it 
>>> separately.
>>>
>>
>> Both of the above are encoded as expected -- the ">" character is 
>> converted to ">", and the "&" character in "<" is converted to 
>> "&". This is consistent and expected behavior. If you want to end up 
>> with "<", then why not just start with "<"?
>>
>> What is your ultimate goal? Do you not want the final HTML to include the 
>> ">" and "<" HTML entities so they display as ">" and "<" on the page?
>>
>> Also, what do you mean by, "If I use the Field titles directly in a table 
>> on my own, they work as expected?" In each case, what do you want to 
>> display on the page, and what are you expecting in the raw HTML?
>>
>> Anthony
>>
>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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 manner.
>

Can you show your SQLTABLE code? When I do SQLTABLE(..., headers='labels'), 
which uses the field labels to generate the headers, I get the exact same 
output as in a SQLFORM (i.e., the values are escaped).
 

> I have found a workaround, finally, which lets me have symbols in both 
> forms and tables:
>
> elapsed_time_field("lcm_gt",label=CAT(T("LCM"),XML(" >"))),
> elapsed_time_field("lcm_le",label=CAT(T("LCM"),XML(" ≤"))),
> elapsed_time_field("scm_gt",label=CAT(T("SCM"),XML(" >"))),
> elapsed_time_field("scm_le",label=CAT(T("SCM"),XML(" ≤"))),
> elapsed_time_field("scy_gt",label=CAT(T("SCY"),XML(" >"))),
> elapsed_time_field("scy_le",label=CAT(T("SCY"),XML(" ≤"))),
>

Why bother with the CAT()? Just do:

label=XML(T("LCM ≤"))

which is your original label simply wrapped in XML().
 

> I first tried the obvious, letting T() handle the substitution but again, 
> that doesn't work.  The &xx; character escapes get printed literally in the 
> form label instead of creating the symbol I intended.  So I got around the 
> problem with CAT().  Still, an awful amount of work and hassle to 
> reverse-engineer and make a work around for something that just should have 
> worked.
>

First, I'm not sure why the complaint. The book clearly states that all 
text injected in views is escaped, and this is to protect against XSS 
vulnerabilities (as well as for proper HTML parsing and displaying of 
special characters intended as page content). The book also clearly states 
how you can override the default escaping -- by wrapping the content in 
XML(), which works exactly as expected in this case. No need for any 
reverse-engineering or workarounds -- just use the documented functionality.

Second, before you vent, keep in mind that the framework, documentation, 
and support are all being provided by folks who are volunteering their time 
and energy for free.
 

> I'm not sure why &xx; is "sanitized" to begin with.  It seems like an 
> extreme form of sanitizing, to eliminate any and all special characters 
> from form labels.
>

I think that's fairly standard -- see 
https://www.owasp.org/index.php/XSS_(Cross_Site_Scripting)_Prevention_Cheat_Sheet#Output_Encoding_Rules_Summary.
 
Aside from security issues, the escaping also serves to ensure that various 
special characters are displayed properly (e.g., converting "&" to "&" 
results in the "&" being displayed on the page, which is typically what we 
want). Of course there are cases where we don't need/want the escaping, but 
the framework cannot know for sure where those cases are, so we err on the 
side of better security and leave it up to the developer to explicitly mark 
text that should not be escaped.

Anthony

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Error with autocomplete in version 2.15.2

[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 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 insert record, invoked by the (+) button of a 
> sqlform.grid.
>
> It worked correctly in version 2.14.6 and 2.15.1
> This problem occurs in a panel that has been running for months, and has 
> not had updates.
> Regards.
>
>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Error with autocomplete in version 2.15.2

[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 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.
>> 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 insert record, invoked by the (+) button of a 
>> sqlform.grid.
>>
>> It worked correctly in version 2.14.6 and 2.15.1
>> This problem occurs in a panel that has been running for months, and has 
>> not had updates.
>> Regards.
>>
>>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Error with autocomplete in version 2.15.2

[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/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 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 insert record, invoked by the (+) button of a 
>> sqlform.grid.
>>
>> It worked correctly in version 2.14.6 and 2.15.1
>> This problem occurs in a panel that has been running for months, and has 
>> not had updates.
>> Regards.
>>
>>

-- 
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" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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 Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.