Try it on your local machine then. It's faster and safer. And you don't have to reveal your database's password either. (I recommend changing the password you pasted earlier, too.)
It's also not a bad idea to see if it's your particular setup on your hosting account, or something else. On Wed, Jan 20, 2010 at 3:15 PM, Greg Milby <[email protected]> wrote: > Thanks - my hosting is the cheapest package, so i can't restart the servers > after i kill them... i'll try your paste in a bit as soon as the restart > script runs. > Thanks, > greg > class search: #under construction - gets errors - webpy has no > concession for "LIKE" in query? > def POST(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='eputureoa', db='gmilby_geekbuntu') > to try#results = db.select('books', where='title LIKE $search', > vars= {'title': '$i.search'}, _test=True) > #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) > ----------------------- > Visit My Sites! > www.syrbot.com | My Site > www.attackr.com | Latest Blog Posts > > > > On Wed, Jan 20, 2010 at 9:05 AM, Branko Vukelic <[email protected]> wrote: >> >> 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. >> >> >> > > > -- > 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.
