Hi guys,
I am trying to write a row with 140 fields into the database, with the
following script:
controller:
*WCEL={item1:value1,item2:value2,.......item140:value140}*
*db.WCEL.update_or_insert(**(WCEL))*
model:
*db = DAL('sqlite://storage.sqlite1')*
*db.define_table('WCEL',*
* Field('item1'),*
* Field('item2),*
* ......*
* Field('item139'),*
* Field('item140')*
* )*
but I am getting the following error:
<class 'sqlite3.OperationalError'> parser stack overflow
File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 412, in
execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
OperationalError: parser stack overflow
Function argument list
(self=<pydal.adapters.sqlite.SQLite object>, *args=('SELECT "WCEL"."id",
"WCEL."it.."."item140" = \'0\')) LIMIT 1 OFFSET 0;',), **kwargs={})
I tried the same set of 140 fields by importing from a csv, it was
successful.
*db.WCEL.import_from_csv_file(open('WCEL.csv', 'r'))*
Is there a way to rectify this issue?
I am actually extracting data from a xml and writing to the DB, if i have
to write from xml to csv and import to dB, that is not efficient.
Pls advise.
Regards,
Jaison
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
