[thelist] substring and a join?

Lauri Vain optima at hot.ee
Sun Mar 4 13:37:29 CST 2001


Hi again...

Sorry, held the Control button down while pressing enter :-)

As I was saying, the query looks like this now:
"SELECT thara_plane.id,thara_plane.name,thara_plane.nick,substring(bodytext,255)
as bodytext,thara_category.category "
   ."FROM thara_plane,thara_category "
   ."WHERE ((thara_plane.category = thara_category.id)) "
   ."ORDER BY thara_plane.time_last DESC";

Thanks for your help,
Lauri





More information about the thelist mailing list