I need to add a extra filter to this records, the table field 'Soort' has to be the same as the entered valua 'News'. Can somebody help me add this extra to the existing code below ?

----------------------------------------------------------
SELECT *, (SELECT COUNT (*)
FROM NEWS_COMMENTS
WHERE NEWS_COMMENTS.NIEUWS_ID = ALGEMEENNIEUWS.NIEUWS_ID) AS LINK_COUNT FROM ALGEMEENNIEUWS
ORDER BY NIEUWS_ID DESC
----------------------------------------------------------

+ -
|Name |Default Value |Run-time Value

MMColParam 'News' Request("EmptyValue"

----------------------------------------------------------

*The field 'Soort' is in the table ALGEMEENNIEUWS.SOORT

Please help me, I try'd alot of things, it's something like 'WHERE Soort = 'MMColParam'' but where do I put it !?

I hope this is clear


<b></b><i></i>

let me see...

Have you tried something like:

SELECT *
FROM NEWS_COMMENTS
WHERE SOORT = MMColParam AND NEWS_COMMENTS.NIEUWS_ID = ALGEMEENNIEUWS.NIEUWS_ID
ORDER BY NIEUWS_ID DESC

+ -
|Name |Default Value |Run-time Value
MMColParam 'News' Request("MM_EmptyValue"

I believe that should work, it first looks for a value "News" in the 'Soort' fields and then it gets the rest of the comments on the news articles based on the article_id of your news item.

Hope this helps you...
Bovenop het nieuws...

With kind regards,

Dennis van Galen
Webmaster KPN Nederland
Financial and Information Services

Thank you for the reply, I already solved the problem with the conditional region extension !