I got a table like this one:
db.define_table('Movie',
    Field('Title',length=64),
    Field('Content',length=512),
   )
Now I like to search this table Title with a string like "Star Wars".
My problem is that there are 6 Star Wars Movies: Star Wars: Episode I...
I want to have all of those 6 as a result.
any idea how I can do that?
My first attempt failed miserable
Movies=db(db.Movie.Title[:len(Searchstr)]==Searchstr)
which gives me this: Set (SUBSTR(Movie.Title,1,(2 - 1)) = '2')

-- 

--- 
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.


Reply via email to