[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