the code you posted (of course, correctly spaced in the controller function) works without problems. Check your database/sql.log for details about the table being effectively created....
On Wednesday, May 22, 2013 8:14:41 PM UTC+2, ewon...@gmail.com wrote: > > What I really wanted to do was connect to an existing postgres database > and read/display the data, but I kept getting this error: ValueError: invalid > literal for int() with base 10: 'SELECT' > > I've pared down to some stupidly simple code that works with sqlite, but > when I change to use my postgres database, I still get that error! > This is what I have: > *db.py*: Just create a table called mydata with one field of type > string. For this example I'm trying, table mydata does not yet exist in my > postgres db. > > db = DAL('postgres://dbuser:dbu...@xxx.xx.xxx.xx/erinstest',pool_size=1, > check_reserved=['all']) > > #db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all']) > > db.define_table('mydata', > > Field('det_data_type', 'string', length=32)) > > > *default.py*: Insert something into the mydata table and query/return > everything from the table. > > def index(): > response.flash = T("Welcome to web2py!") > db.mydata.insert(det_data_type="type1") > pkts = db().select(db.mydata.ALL) > return dict(pkts=pkts) > > > > *default/index.html*: Display each of the results from the query of the > mydata table. > {{ for pkt in pkts: }} > {{=pkt.id}} > {{=pkt.det_data_type}} > {{pass}} > > When I run this, the mydata table is created in my postgres database (so I > assume my connection is working at least somewhat correctly), but nothing > is inserted into it and the ValueError comes up. After doing this, I also > tried inserting something into the table (outside of web2py) and then > commented out the line in default.py that inserts into the table to see if > I could just display what was in mydata table. Same error. What am I > doing wrong? > > I am using web2py v2.4.6 and postgres 8.4.13. > > > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.