i am starting to web2py and using shell for all db related stuff. today i 
notice a bizarre behavior on db select. Instead of selecting a record, it 
is insert value of last insert query. am i making any mistake here.. this 
my shell log:
In [5] : for x in row: print x
<Row {'id': 1L, 'name': 'dog'}>
<Row {'id': 2L, 'name': 'bug'}>
<Row {'id': 3L, 'name': 'y'}>

In [6] : db.dog.insert(name='hello')
4L

In [7] : db(db.dog).select()
<Rows (5)>

In [8] : db(db.dog._id > 0).select()
<Rows (6)>

In [11] : rows = db(db.dog).select()

In [12] : for x1 in rows: print x1
<Row {'id': 1L, 'name': 'dog'}>
<Row {'id': 2L, 'name': 'bug'}>
<Row {'id': 3L, 'name': 'y'}>
<Row {'id': 4L, 'name': 'hello'}>
<Row {'id': 5L, 'name': 'hello'}>
<Row {'id': 6L, 'name': 'hello'}>
<Row {'id': 7L, 'name': 'hello'}>

In [13] : db._lastsql
'SELECT  dog.id, dog.name FROM dog WHERE (dog.id > 0);'

In [14] : db(db.dog).select()
<Rows (10)>
 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
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/d/optout.

Reply via email to