VonFranzken
MIS
How can I put a Request.Query String into this sql statement so that my records are filtered by selection?
I want so if your on a list page and you click the link to drill into the details, the details will be filtered for that unique "id"
How could I accomplish this?
SELECT a2.aid, a2.articletitle, a2.shordescrp, a2.imagetitle, a2.image, a2.details, a2.eventdate, a2.datenow, t.commentcount
FROM (SELECT a.aid, COUNT(c.aid) AS commentcount
FROM articles a
LEFT JOIN comments c on a.aid = c.aid
GROUP BY a.aid) t
JOIN articles a2 ON t.aid = a2.aid
STeve
I want so if your on a list page and you click the link to drill into the details, the details will be filtered for that unique "id"
How could I accomplish this?
SELECT a2.aid, a2.articletitle, a2.shordescrp, a2.imagetitle, a2.image, a2.details, a2.eventdate, a2.datenow, t.commentcount
FROM (SELECT a.aid, COUNT(c.aid) AS commentcount
FROM articles a
LEFT JOIN comments c on a.aid = c.aid
GROUP BY a.aid) t
JOIN articles a2 ON t.aid = a2.aid
STeve