a little closer - at least not throwing errors now - page just times
out - error log is not even offering any suggestions now
class search: #under construction - gets errors - webpy has no
concession for "LIKE" in query?
def GET(self):
web.header('Content-Type', 'text/html')
i = web.input()
db = web.database(host='127.0.0.1', port=3307, dbn='mysql',
user='gmilby', pw='56j6j56jGGEGEG56j', db='gmilby_geekbuntu')
results = db.query('books', where="title LIKE '$i.search'")
return render_sub.search(results)
On Jan 19, 1:46 pm, geekbuntu <[email protected]> wrote:
> does anyone have a good sql statement for webpy to query results by
> "LIKE" (e.g. results = db.select('books', where='title LIKE
> $search_var', vars=locals()) )? (this suggestion was from Justin but
> doesn't work)
>
> i just found something on github/webpy repository
> it offered another way to do the 'like' - it didn't work
> eitherhttp://github.com/webpy/webpy/issues/issue/2
>
> logically this shouldn't be much of an issue... it's just a mysql
> statement like any other really
>
> hope someone knows of a way to do this.
>
> tia,
> greg
--
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/webpy?hl=en.
