Single - Double Quotes Problem In Query

Hi All,

I am facing quotes problem. Without using the quotes
my query is running fine, but I need to use IIF condition so for that I
need quotes adjustment. I didn't figured it out how to adjust them, try
several techniques but no success.


I am using dotnetnuke.
 
{IIF,"[frmradio,form]=text","

SELECT Docs.FileName, Dept_LegalLaw.MediaID, Dept_LegalLaw.ID,
Dept_LegalLaw.LevelID, Dept_LegalLaw.LawID, Dept_LegalLaw.LawDate,
Dept_LegalLaw.Agreement, Dept_LegalLaw.Name, Dept_LegalLaw.NameSearch,
Dept_LegalLawType.LawType, Dept_LegalLaw.LawNo, Dept_LegalMinistries.RegID, Dept_LegalLaw.IssueNo,
Dept_LegalLaw.Attachment, Dept_LegalLaw.Amendment, Dept_LegalLaw.Scanned,
Dept_LegalLaw.Html, Dept_LegalMinistries.Description
FROM OPENQUERY(LEGALDBSERVER, 'SELECT Filename FROM SCOPE() WHERE Contains('" @FilterAnyWrd ")' ) AS Docs
INNER JOIN Dept_LegalLaw ON Docs.FileName = Dept_LegalLaw.FileName
INNER JOIN Dept_LegalMinistries ON Dept_LegalLaw.RegID = Dept_LegalMinistries.RegID
INNER JOIN Dept_LegalLawType ON Dept_LegalLaw.LawID = Dept_LegalLawType.LawID


",
"
"}

{IIF,"'[frmradio,form]'='title'","

SELECT MediaID, Dept_LegalLaw.ID, Dept_LegalLaw.LevelID, Dept_LegalLaw.LawID, LawDate, Agreement, Name,
NameSearch, Dept_LegalLawType.LawType, LawNo, Dept_LegalMinistries.RegID, IssueNo, Attachment, Amendment,
Scanned, Html, Dept_LegalMinistries.Description, Dept_LegalLaw.FileName
FROM Dept_LegalLaw
LEFT JOIN Dept_LegalMinistries ON Dept_LegalLaw.RegID COLLATE DATABASE_DEFAULT =
Dept_LegalMinistries.RegID COLLATE DATABASE_DEFAULT
INNER JOIN Dept_LegalLawType ON Dept_LegalLaw.LawID COLLATE DATABASE_DEFAULT = Dept_LegalLawType.LawID
COLLATE DATABASE_DEFAULT
WHERE @FilterLawNo AND @FilterLawID AND @FilterRegID AND @FilterIssueNo AND @FilterFromDate AND
@FilterToDate AND @FilterNtContNew AND @FilterAgreement AND @FilterAllWrdNew AND @FilterExWrdNew AND @FilterAnyWrdNew
ORDER BY [SORTTAG]
",
"
"}

Thanks for any help