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)
Regards
On Tue, Sep 9, 2014 at 3:30 PM, Anthony <abasta...@gmail.com> wrote:
> On Tuesday, September 9, 2014 8:08:00 AM UTC-4, Maurice Waka wrote:
>>
>> I have several lists in sqlite rows as follows:
>>
>> ROWID x
>> 1 ['123', '1234', '12345',]
>> 2 ['abc', 'abcd', 'abcde',]
>> 3 ['1a2b3c', '1a2b3c4d', '1a2b3c4d5e',]
>>
>> How are you storing the lists in a single SQLite column? Did you convert
> Python lists to strings?
>
>
>> def types():
>> location = ""
>> conn = sqlite3.connect("types.db")
>> c = conn.cursor()
>> c.execute('select * from types ORDER by X')
>> for rowid,X in c.execute("select rowid,X from types order by X"):
>> return row[:]
>>
>> Given that the identifier "row" has not been defined, the final line
> should raise an exception. Also, you don't want to return in the for loop,
> as that will terminate the function on the first pass through the loop.
>
> Is this in a web2py app? If so, I would recommend using the DAL and store
> your lists in a list:string field. As far as looping and returning values,
> it's hard to say without more details regarding what you are trying to do.
> Are you just trying to display all the rows in an HTML page?
>
> 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.
