Help with Request.QueryString 1

[VonFranzken]

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

 

[FesterSXS]

strSQL = "SELECT this, that, theother FROM myTable WHERE id=" & CInt(Request.QueryString("id")) & ";"

assuming id is a number. If its a string then dont use CInt() and surround the value with single quotes

Tony
[red]_________________________________________________________________[/red]
Webmaster -

http://www.SpiraxSarco.com/

 

[VonFranzken]

Thanks Fester but I had figured it out just a sec ago.
The glory of this forum is that everyone is so helpful, and it gives you the opp to try to think it through