Hey thanks alot! let me work on this then. Kind regards On Tue, Sep 9, 2014 at 3:55 PM, Anthony <abasta...@gmail.com> wrote:
> On Tuesday, September 9, 2014 8:40:04 AM UTC-4, Maurice Waka wrote: >> >> Thanks for the input. Yes it is part of a web2py app game. >> I have about 1000 rows, but when a user types in the keyword(stored in >> any of the rows) i should get a boolean answer which for now displays the >> row(different code on this) >> > > OK, but how are the rows stored in SQLite? Are they just strings, like > "['123', '1234', '12345', ]"? If so, you can do a query searching for the > string "'[keyword]'," within each row to return rows with a matching > keyword. Again, I would recommend using the DAL with a list:string field: > > db.define_table('keywords', > Field('x', 'list:string')) > > This allows you to insert and extract actual Python lists from the field, > though the lists will be stored in the database as a string in the form > "|item1|item2|item3|". So, to find rows that match a keyword, you would > just do: > > keyword = '123' # in reality, this is obtained via user input > match_row = db(db.keywords.x.contains('|%s|' % keyword)).select().first() > > Your boolean test would then simply be "if match_row:". The list of > keywords in the matching row would be in match_row.x, which would be an > actual Python list rather than a string representation of a list. > > Anthony > > -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/dNtVIOucH9Q/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Dr Maurice Waka, MBCHB. Nairobi -- 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.