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

tpc at csua.berkeley.edu tpc at csua.berkeley.edu
Mon Oct 27 14:20:10 EST 2003


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.




More information about the Tutor mailing list