Thank you for pointing out that there was an issue with the database. After
deleting the content of the database folder everything works. Tanks for the
help!
On Friday, 7 July 2023 at 16:16:06 UTC+2 Rick wrote:
> Thanks Massimiliano for the answering quickly. The suggested code produces
> this error:
> IntegrityError(FOREIGN KEY constraint failed)
>
> If I change the model file lines to
> db.define_table('next_list', Field('node'), Field('next_node', text))
> then the error changes to:
> NameError(name 'text' is not defined)
>
>
> On Thursday, 6 July 2023 at 16:12:59 UTC+2 Massimiliano wrote:
>
>> Maybe on your model there is more than you showed :
>>
>> db.define_table('next_list', Field('node'), Field('next_node'))
>>
>> db.next_list.insert(**db.next_list._filter_fields({ "node" : "test1" ,
>> "next_node":"test2" }))
>>
>> print(db(db.next_list).select())
>>
>> next_list.id,next_list.node,next_list.next_node
>>
>> 1,test1,test2
>>
>>
>> db.next_list.insert(**db.next_list._filter_fields({ "node" : "test1" ,
>> "next_node":"test2" }))
>>
>> print(db(db.next_list).select())
>>
>> next_list.id,next_list.node,next_list.next_node
>>
>> 1,test1,test2
>>
>> 2,test1,test2
>>
>>
>>
>> Il giorno gio 6 lug 2023 alle ore 16:07 Rick <sababa...@gmail.com> ha
>> scritto:
>>
>>> That unfortunately gives a ticket with this information:
>>> sqlite3.IntegrityError: FOREIGN KEY constraint failed
>>> On Thursday, 6 July 2023 at 15:02:05 UTC+2 Massimiliano wrote:
>>>
>>>> try this:
>>>>
>>>> {{db.next_list.insert(**db.next_list._filter_fields({ "node" : "test1"
>>>> , "next_node":"test2" }))}}
>>>>
>>>> Il giorno gio 6 lug 2023 alle ore 13:47 Rick <sababa...@gmail.com> ha
>>>> scritto:
>>>>
>>>>> How to insert rows from a view-file? The site doesn't produce any
>>>>> error, but an empty row is added to the database.:
>>>>>
>>>>> From the model file
>>>>> db.define_table('next_list', Field('node'), Field('next_node'))
>>>>>
>>>>>
>>>>> From the view file:
>>>>> {{nextrows = db(db.next_list)}}
>>>>> {{db.next_list.insert(**db.next_list._filter_fields({
>>>>> "db.next_list.node" : "test1" , "db.next_list.next_node":"test2" }))}}
>>>>>
>>>>>
>>>>>
>>>>> What's wrong? Thanks in advance for help and ideas!
>>>>> ------------------------------
>>>>>
>>>>>
>>>>> --
>>>>> 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+un...@googlegroups.com.
>>>>> To view this discussion on the web visit
>>>>> https://groups.google.com/d/msgid/web2py/ac174d5a-8245-44e5-b708-08258a60f70fn%40googlegroups.com
>>>>>
>>>>> <https://groups.google.com/d/msgid/web2py/ac174d5a-8245-44e5-b708-08258a60f70fn%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>> .
>>>>>
>>>>
>>>>
>>>> --
>>>> Massimiliano
>>>>
>>> --
>>> 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+un...@googlegroups.com.
>>>
>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/web2py/4e07ad77-4727-44a8-8710-bda5909cb287n%40googlegroups.com
>>>
>>> <https://groups.google.com/d/msgid/web2py/4e07ad77-4727-44a8-8710-bda5909cb287n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>>
>>
>> --
>> Massimiliano
>>
>
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/3b7dcd0f-275f-415e-bd2c-2d7d40e2f3e8n%40googlegroups.com.
