I have a equipment table contains different equipments with model numbers such as "SVP701", "SVP710", "SVP755". Another lookup table contains their expected life time for model numbers such as "SVP7" for 10 years, "TPU3" for 20 years. I want the wildcard "SVP7" match all "SVP701", "SVP710", "SVP755", so that the lookup table is simple and short.
I think the query is like: query = db.equipment.model.startswith(db.life_time.model) Then, I want to put the query in the SQLFORM.grid to display results. Thanks On Monday, October 28, 2013 4:07:56 PM UTC-4, viniciusban wrote: > > Could you supply an example of what you intend to achieve, preferably a > query? > > On Mon, Oct 28, 2013 at 5:17 PM, Mark <czhan...@gmail.com <javascript:>> > wrote: > > 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> 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. > >> > 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+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.