[Tutor] Re: [mod_python] invalid literal for float int or long
solved !
tpc at csua.berkeley.edu
tpc at csua.berkeley.edu
Mon Oct 27 15: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
> >
>
More information about the Tutor
mailing list