hi,
i have an existing firebird database, and i need to create a web
interface for this db.
i trying some simple test, but don't work :(
enviroment test :
firebird 2.1/2.5
python 2.6.5
kinterbasdb 0.3.3
web.py 0.34
test.py
---
import web
In [20]: db=web.database(dbn='firebird', db='localhost:test',
user='SYSDBA', password='masterkey')
In [21]: res=db.select('mytable')
0.0 (7): SELECT * FROM mytable
In [22]: res[0]
---------------------------------------------------------------------------
ProgrammingError Traceback (most recent call
last)
/home/pie/<ipython console> in <module>()
/usr/local/lib/python2.6/dist-packages/web.py-0.34-py2.6.egg/web/
utils.pyc in __getitem__(self, i)
650 # now self.c == i
651 self.c += 1
--> 652 return self.i.next()
653 except StopIteration:
654 raise IndexError, str(i)
/usr/local/lib/python2.6/dist-packages/web.py-0.34-py2.6.egg/web/
db.pyc in iterwrapper()
614 names = [x[0] for x in db_cursor.description]
615 def iterwrapper():
--> 616 row = db_cursor.fetchone()
617 while row:
618 yield storage(dict(zip(names, row)))
ProgrammingError: (-504, 'fetch: \n Dynamic SQL Error\n SQL error
code = -504\n Invalid cursor reference\n Cursor is not open')
--------------------------
thanks
--
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/webpy?hl=en.
