|
tpc at csua.berkeley.edu
tpc at csua.berkeley.edu
Mon Oct 27 12:26:39 EST 2003
hi Grisha, I switched url, title before, and got the invalid literal error. I am not sure why since the return values are exactly the same, but it seems like the "FROM URLs, URLs_WITH_MATCHES WHERE" was causing problems, though I am not sure for which module, mod_python or MySQLdb or both or maybe neither. I am still testing and hoping the bug doesn't all of a sudden appear. On Mon, 27 Oct 2003, Gregory (Grisha) Trubetskoy wrote: > > The first one is "url, title", the second is "title, url" - was that the > problem, or was it the WHERE instead of INNER JOIN (which are same thing > IIRC). > > Grisha > > > On Mon, 27 Oct 2003 tpc at csua.berkeley.edu wrote: > > > > > fingers crossed, here's hoping the bug doesn't rear its creepy head again, > > can't really say wherefore the bug but I found a workaround, I changed the > > basic MySQL statement below: > > > > SELECT url, title FROM URLs, URLs_WITH_MATCHES WHERE URLs.id = > > URLs_WITH_MATCHES.url_id; > > > > to: > > > > SELECT title, url from URLs INNER JOIN URLs_WITH_MATCHES ON URLs.id = > > URLs_WITH_MATCHES.url_id; > > > > and voila ! I am a complete idiot. > > > > _______________________________________________ > > Mod_python mailing list > > Mod_python at modpython.org > > http://mailman.modpython.org/mailman/listinfo/mod_python > > >
|