[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