What version of Dreamweaver are you using?
What do you mean by:
"It works for one recordset."
I only see one recordset on your page? the recordset code is duplicate, but there is only the one recrdset named news.
for the code in the repeat region:
echo WA_getCMSContent($database_PowerCMSConnection, $PowerCMSConnection, 'ISCI latest News', 'ISCIlatestnewstitle', false, $row_iscinewsRS['ContentPageSetOrder'] );
you refer to a recordset named iscinewsRS but this recordset does not exist on the page.