cannot believe that worked... very nice ty vm
just not putting out the results - do i need to adjust this?
$def with (title, name, results)
$var title:$title
$var name:$name
$results just put this in to see if it was passing anything at all - it
displays<web.utils.IterBetter instance at 0x7f618cba29e0>
<ul>
$for result in results:
<li>
<b>
$result.title
</b>
</li>
</ul>
-----------------------
Visit My Sites!
www.syrbot.com | My Site
www.attackr.com | Latest Blog Posts
On Sat, Jan 23, 2010 at 2:49 AM, Jingchao Hu <[email protected]> wrote:
> try to add double quotes around your search_var
>
> In standard sql syntax, keywords should put in quotes(?I'm not
> sure,but without quotes they won't work)
> =============================================
> db.select('books', where='title LIKE "$search_var"', vars=locals())
> ==============================================
>
> On Jan 20, 5:46 am, 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] <webpy%[email protected]>.
> For more options, visit this group at
> http://groups.google.com/group/webpy?hl=en.
>
>
--
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.
