Filter by URL parameter 1

[VonFranzken]

I need to try and filter this query from a link in dreamweaver. its a Request.QueryString("id")

How would I do that?

SELECT a.aid, a.articletitle, a.shortdescrp, a.details, a.imagetitle, a.image, a.eventdate, a.datenow, count(c.aid) as commentCount
FROM articles a left join comments c on a.aid = c.aid group by a.aid, a.articletitle, a.shortdescrp, a.details, a.imagetitle, a.image, a.eventdate, a.datenow

 

[jdgonzalez]

Sounds like it's more of an asp question rather than SQL Server. You could try something like:

where <<whateverfieldyouwanttofilteron>> = request.querystring("id").value

or pass the URL parameter as a stored procedure parameter.