[mod_python] invalid literal for float int or long solved !

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
> >
>



More information about the Mod_python mailing list