> Should this work?
>
> >>> import web
> >>> web.config.db_parameters = dict(dbn='sqlite', db='test.sqlite')
> >>> rows=web.query("SELECT  * FROM domuinfo WHERE SERVER = 'test1' and DOMAIN 
> >>> = 'bob.com'", vars=locals())

when I want to use it at command line I call db.connect() before
starting with the queries

see below:

>>> import web
>>> web.db.connect('sqlite', db='test.sqlite')
>>> rows=web.query("SELECT  * FROM domuinfo WHERE SERVER = 'test1' and DOMAIN = 
>>> 'bob.com'", vars=locals())

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to