i already changed it - it happens sometimes... get paste happy.
----------------------- Visit My Sites! www.syrbot.com | My Site www.attackr.com | Latest Blog Posts On Wed, Jan 20, 2010 at 9:26 AM, Branko Vukelic <[email protected]> wrote: > 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]<webpy%[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]<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]<webpy%[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] <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.
