if you have an alternative solution to this one then i'm all ears.
it would be alot easier for me if i'll be using smart tag. @eclipsed4utoo: Then you have not truly delved into Grid Views, grasshopper.
Entry, (SELECT avg(rating) FROM tb_comments WHERE " _ & "tb_comments.entry=tb_entity.id) as Rating, tb_kind. Info " _ & "FROM tb_entity INNER JOIN tb_hijack ON tb_= tb_hijack. Kind = tb_" _ & "WHERE tb_entity.entry='" & strline.
Replace("'", "''") & "'" Else SQL = SQL & " OR tb_entity.entry='" & strline.
It displays 2 columns Contact Name and City of which city is editable via ASP.