I have the following:
Model:
dbhlx=SQLDB("sqlite://contacts.db")
dbhlx.define_table('contact',
dbhlx.Field('firstname'),
dbhlx.Field('lastname'))
Using the Web2Py command line --
The complete data set --
In [64]: rows = dbhlx((dbhlx.contact.id>0)).select
(dbhlx.contact.lastname)
In [65]: print rows
contact.lastname
McGinnis
McGinnis
tester
Sue
Adams
Zammie
The dataset filtered --
In [66]: rows = dbhlx((dbhlx.contact.lastname >='M')).select
(dbhlx.contact.lastname)
In [67]: print rows
contact.lastname
McGinnis
McGinnis
tester
Sue
Zammie
Whereas --
In [68]: rows = dbhlx((dbhlx.contact.lastname <='M')).select
(dbhlx.contact.lastname)
In [69]: print rows
contact.lastname
Adams
I would have expected
In [69]: print rows
contact.lastname
McGinnis
McGinnis
Adams
Is this an unexplained boundary condition?
Thx
JohnMc
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
