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.
