Plase use dpaste.com for code samples. It's hard to read like this. BTW, is web.config.debug set to True? Please try that. Also, try to do it all in console on your test machine:
http://dpaste.com/147910/ Note that the last argument to select is _test=True, which prints the SQL rather than hitting the database. You can also use a debugger like WinPDB to see what's going on. I usually do it when something really complicated is going on (like possible trouble on any of the many layers without a concrete error message). On Wed, Jan 20, 2010 at 2:53 PM, geekbuntu <[email protected]> wrote: > Just did: > search class with suggested changes: > > 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='epheivoa', db='gmilby_geekbuntu') > results = db.select('books', where='title LIKE $search', vars= > {'title': i.search}) > #results = db.query('books', where="title LIKE $i.search") > return render_sub.search(results) > > search.html excerpt: > <!-- Search Field --> > <fieldset id="search_wrapper"> > <form name="search" action="search"> > <input type="text" value="Search" > class="search" name="search" /> > <input type="submit" value="Search" > class="hide" /> > </form> > </fieldset> > > Page crashed: http://www.syrbotwebdesign.com/search?search=red > > no readable errors. > > Branko - thank you very much for suggesting something - it's nice to > get replies to try to fix a problem. > Thank you very much, > greg > > > > On Jan 20, 8:44 am, Branko Vukelic <[email protected]> wrote: >> On Wed, Jan 20, 2010 at 2:39 PM, geekbuntu <[email protected]> wrote: >> > results = db.query('books', where="title LIKE '$i.search'") >> >> Have you tried this: >> >> db.select('books', where='title LIKE $search', vars={'search': i.search}) >> >> ? >> >> Best regards, >> >> -- >> Branko Vukelić >> >> http://foxbunny.tumblr.com/http://www.flickr.com/photos/16889...@n04/http://www.twitter.com/foxbunnyhttp://github.com/foxbunny > > -- > 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. > > > > -- Branko Vukelić http://foxbunny.tumblr.com/ http://www.flickr.com/photos/16889...@n04/ http://www.twitter.com/foxbunny http://github.com/foxbunny
-- 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.
