On 18/09/13 09:10, memilanuk wrote:
that I'm missing, but I can't seem to spot it. Below is the tail end of
the traceback error message, followed by the code from the file in
question. Any help would be much appreciated.
line 57, in main
cur = g.db.execute('SELECT * FROM posts')
OperationalError: no such table: posts
def connect_db():
#return sqlite3.connect(app.config['DATABASE'])
return sqlite3.connect('fblog.db')
You may need to specify a relatie path rather than
just the filename.
def main():
g.db = connect_db()
cur = g.db.execute('SELECT * FROM posts')
You are trying to execute on the database rather
than on a cursor. You need to create a cursor
first to hold your results.
Something like;
cur = g.db.cursor()
cur.execute(.....)
HTH
--
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.flickr.com/photos/alangauldphotos
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor
