Viniciusban, Thank you for the help. But I don't know if the name is "John" or whatever. I hope the name such as "John" can be fetched dynamically from another table (e.g. db.student). Now, I think maybe it is not possible.
On Monday, October 28, 2013 3:04:29 PM UTC-4, viniciusban wrote: > > rows = db(db.person.name.startswith("John")).select() > > On Mon, Oct 28, 2013 at 1:50 PM, Mark <czhan...@gmail.com <javascript:>> > wrote: > > Hello, > > > > I want to use startswith in a query like following, but it didn't work: > > > > db.person.name.startswith(db.student.name) > > > > What is wrong in this query? Is there a better way for it or a work > around? > > Any help would be greatly appreciated. > > > > Thanks > > > > -- > > 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+un...@googlegroups.com <javascript:>. > > For more options, visit https://groups.google.com/groups/opt_out. > -- 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/groups/opt_out.