[web2py] Re: Two forms

2017-09-22 Thread T.R.Rajkumar
The order table id will be returned by the insert statement. There will be no race. We can use the returned id in items table. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Cassandra and web2py

2017-09-22 Thread 黄祥
tryin to use cassandra with web2py using cassandra-driver but return an error: e.g. *cassandra side* pip install cassandra-driver systemctl restart cassandra cqlsh cqlsh> show version [cqlsh 5.0.1 | Cassandra 3.11.0 | CQL spec 3.4.4 | Native protocol v4] cqlsh> CREATE KEYSPACE mykeyspace WITH

[web2py] Re: Two forms

2017-09-22 Thread 黄祥
face this before, usually created the form with web2py components 1 for items (up first), save the value of items on the sessions then another component for order table (below to submit all the data (data in sessions input to items and order data) during the form.process() or form.validate()

[web2py] form replacing elements

2017-09-22 Thread Pierre
Hi everyone, trying to replace a list:string form data attribute (data-fuu) value am doing the following: form = SQLFORM(db.listfoo, record=rec, fields=['foo'], showid=False) for i,fe in enumerate(form.elements('input.string')): fe['_data-fuu'] = form.record.fuu[i]

Re: [web2py] Re: Support for BIT(1) as boolean?

2017-09-22 Thread Alfonso Serra
Yan's example worked. But still there are some quirks with the scheduler using connections for long processes. You are able to change T and F for good editing gluon.packages.dal.dialects.base.py line 36 then use Field(.., type = "boolean") as usual. No adapter change with problems or

[web2py] Two forms

2017-09-22 Thread Balaji Nagisetty
I need to Insert a record into a table where you have a foreign key that references a primary key that is not yet created. For example two tables : 1. Orders table 2. Items table I want to submit these two form on same page but items table records have a reference from orders

Re: [web2py] Re: Support for BIT(1) as boolean?

2017-09-22 Thread Alfonso Serra
Thanks Yan, i will use your example if i cant fix this. I can confirm the problem on Version 2.15.3-stable+timestamp.2017.08.07.12.51.45. This is dal declaration working fine on previous versions db = DAL("mysql://myuser:mypassw@localhost/myapp", pool_size = 10, check_reserved=False, migrate