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