|
Gregory (Grisha) Trubetskoy
grisha at modpython.org
Mon Oct 27 14:45:38 EST 2003
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 >
|