>> Please advise how to create multiple rows insert by usung SQL form .
You have to create a form with multiple rows and then loop through multiple
records when the form is accepted.
To give you a better idea, here is a snippet from some code I used in the
distant past. It updates multiple
I'm not sure that is possible Sanka. At least I have not read it in the
book nor seen it referenced by anyone.
I expect you have to write a custom form and handle it manually. But web2py
can still help with those tasks.
On Mon, 20 Jul 2020, 12:45 pm Sanka kanaka krupakar,
wrote:
> Dear group
Dear group members
Please advise how to create multiple rows insert by usung SQL form .
On Mon 20 Jul, 2020, 05:37 AGRogers, wrote:
> Great. It's a cool feature.
>
> You would have read that you can turn it off in code temporarily just by
> setting common_filter =none.
>
> That has caught me a
Great. It's a cool feature.
You would have read that you can turn it off in code temporarily just by
setting common_filter =none.
That has caught me a few times.
On Sun, 19 Jul 2020, 11:06 pm mostwanted, wrote:
> Hey AGRogers, thanks for that suggestion, I added the highlited lines to
> my
Hey AGRogers, thanks for that suggestion, I added the highlited lines to my
model code & it gave results, thank you very much:
db.define_table('lecturer',
Field('surname'),
Field('name'),
Field('title'),
Field('posted_by',
I would try using a common_filter on the drop down list table. Could that
work?
On Sun, 19 Jul 2020, 6:10 pm mostwanted, wrote:
> In my application I have 4 tables, 3 of them referenced in the fourth
> table but every user should be able to view only what they have entered
> into the database.
In my application I have 4 tables, 3 of them referenced in the fourth table
but every user should be able to view only what they have entered into the
database. Is there a way that in a dropdown list of a referenced table in
an SQLFORM users can only view & select from items they have entered?
7 matches
Mail list logo