|
tpc at csua.berkeley.edu
tpc at csua.berkeley.edu
Mon Oct 27 12:53:45 EST 2003
ok I take that back. I just switched it again as per your suggestion and I now see that "url, title" gives me invalid literal errors whereas "title, url" does not, even for the old SELECT statement. This perplexes me, as I know at least once I saw: ValueError: invalid literal for float(): <insert any mp3 URL here> However, I now make sure to <shift> RELOAD to make sure memory cache is cleared, so you may be on to something. 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 > > >
|