Is your database file is called "testDB" without any extension (like
"testDB.db")?
Do you really call your table "table.A" and the field "field.B"? The
dot "." is generally used when you have multiple tables.
SELECT fizz.id, buzz.id FROM fizz, buzz;
Is the actually performed SQL request (_test=True) the one you want?
Cheers,
-- Yoan
Check with _test=True is it's the SQL query you're actually trying to perform.
On Sun, Apr 13, 2008 at 8:17 PM, dineshv <[EMAIL PROTECTED]> wrote:
>
> Below is code that gets user input ('q') from a web page and then
> finds all strings in a database with the substring 'q':
>
> import web
> import sqlite3
>
> render = web.template.render('/templates', cache=False)
>
> urls = (
> '/', 'index',
> '/act', 'acGET',
> )
>
> class index():
> def GET(self):
> web.header("Content-Type", "text/html; charset=iso-8859-1")
> print render.act()
>
> class acGET():
> def GET(self):
> entry = web.input()
> web.debug()
> q = entry.q
> q = str('%' + q + '%')
> limit = int(entry.limit)
> """
> the sqlite SELECT statement is
> "SELECT field.B FROM table.A WHERE field.B LIKE '%s' LIMIT
> '%s'" %
> (q, limit)
> ie. looking for the substring '%q%' in string field.B
>
> """
> for row in web.select('table.A',
> what='field.B',
> where='field.B LIKE $q',
> limit=limit,
> vars={'q':q}):
> print row
>
> web.webapi.internalerror = web.debugerror
> if __name__== "__main__":
> web.config.db_parameters = dict(dbn='sqlite', db="testDB")
> web.httpserver.runsimple = web.httpserver.runbasic
> web.run(urls, globals(), web.reloader)
>
>
> The program doesn't return any data from table.A. The sqlite
> statement does work when used standalone (ie. outside of webpy). Any
> ideas what might be the problem?
>
>
>
>
>
> On Apr 13, 9:34 am, dineshv <[EMAIL PROTECTED]> wrote:
> > Anand
> >
> > Am I replacing the web.connect statement with the
> > web.config.bd_parameters statement?
> >
> > Also, are there any other administrative db.py statements that I
> > should include before executing sql statements?
> >
> > On Apr 13, 4:19 am, "Anand Chitipothu" <[EMAIL PROTECTED]> wrote:
> >
> > > > The database connection statement is placed before web.run and is:
> >
> > > > [L61] web.connect(
> >
> > > try adding web.config.db_parameters = dict(dbn='sqlite', db="testDB.db")
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
