this.configurations.put( "message", "hello world" ); dispContentListAttrs = StructNew(); dispContentListAttrs.clientid=client.OwnerID; dispContentListAttrs.clienttype=client.OwnerType; dispContentListAttrs.dsn=client.datasource; dispContentListAttrs.slctflds="itm.itemid, itm.title, itm.teaserTxt, itm.subtitle, itm.text, itm.image, itm.customfld_1"; dispContentListAttrs.getthumb="yes"; dispContentListAttrs.isprivate=1; dispContentListAttrs.fspro_userid = client.userID; dispContentListAttrs.brokerid = client.brokerid; dispContentListAttrs.groupids = client.listgroups; dispContentListAttrs.categories = "yes"; //TODO: fix these to be dynamic dispContentListAttrs.sectionId = 1582; dispContentListAttrs.categoryId = 5713; dispContentListAttrs.customFieldLabel = "Related Products"; dispContentListAttrs.customFieldValue = arguments.product;

#left(paragraph,arguments.maxLengthOut)#

#paragraph#

#contentList.title#

#contentList.subtitle#
writeHTMLParagraphs( contentList.teaserTxt );
[##macro ATTACHMENTS]
select distinct categoryId, categoryName, categorySortRank from qcf_dispAttchDocs order by categorySortRank

#categoryName#Uncategorized

select DocTitle, DocPath, DocID, FileExt, FileSize, sortRank from qcf_dispAttchDocs where categoryId = categoryId is null order by sortRank
#docs.DocTitle#
[/##macro]
#contentList.text#
curl = ListToArray( curlString ); if( ArrayLen( curl ) gte 2 ) { private = curl[1]; contentSelector = curl[2]; contentSelectorArray = ListToArray( contentSelector, ":" ); sectionId = contentSelectorArray[1]; if( ArrayLen( contentSelectorArray ) gt 1) { categoryId = contentSelectorArray[2]; } else { categoryId = 0; } if( ArrayLen( curl ) gt 2) { itemId = curl[3]; if( ArrayLen( curl ) gt 3 ) { single = curl[4]; } else { if( itemId neq 0 ) { single = 1; } else { single = 0; } } } else { itemId = 0; single = 0; } } else { private = 1; sectionid = 0; categoryid = 0; itemid = 0; single= 0; } dispContentListAttrs = StructNew(); dispContentListAttrs.clientid = client.ownerID; dispContentListAttrs.clienttype = client.ownerType; dispContentListAttrs.dsn = client.datasource; dispContentListAttrs.slctflds = "itm.itemid, itm.title, itm.teaserTxt, itm.subtitle, itm.text, itm.privateYesNo, itm.publishDate, itm.linkToUrl, itm.linkToText, itm.linkToTarget"; dispContentListAttrs.sectionid = sectionid; dispContentListAttrs.isprivate = private; dispContentListAttrs.itemid = itemid; dispContentListAttrs.fspro_userid = client.userID; dispContentListAttrs.brokerid = client.brokerid; dispContentListAttrs.groupids = client.listgroups; if( categoryId neq 0 ) { dispContentListAttrs.categories = "yes"; dispContentListAttrs.categoryid = categoryid; } if( single neq 0 and itemid neq 0) { dispContentListAttrs.singleItem = "YES"; } // add the CURL for reference dispContentListAttrs.curl = StructNew(); dispContentListAttrs.curl.raw = arguments.curlString; dispContentListAttrs.curl.sectionid = sectionid; dispContentListAttrs.curl.categoryid = categoryid; dispContentListAttrs.curl.private = private; dispContentListAttrs.curl.single = single; dispContentListAttrs.curl.itemid = itemid; dispContentListAttrs.getimage = "yes"; dispContentListAttrs.getthumb = "yes"; dispContentListAttrs.addlflds = ",itm.image"; SELECT w.portal_name, w.portal_theme, w.portal_ownerID, w.portal_ownerType, w.auth_clntCd, w.portal_dataSource, w.portal_dataSource_preview, w.portal_dataSource_dev, w.portal_corpSiteURL, w.portal_corpSiteURL_preview, w.portal_corpSiteURL_dev, w.portal_ssoRole, w.portal_gaTrackingCode, w.websiteid, rtrim( w.name ) portalFullName, w.auth_custFldr FROM tbl_CUS_WebSiteDomains d INNER JOIN tbl_CUS_WebSites w ON w.websiteid = d.websiteid WHERE d.domainname = AND w.portal_type = 'MFR' this.configurations.put( client.portalSiteName & client.portalSiteNameSuffix, configuration ); SELECT wss.name FROM tbl_CUS_WebSiteDomains d INNER JOIN tbl_CUS_WebSites w ON w.websiteid = d.websiteid INNER JOIN tbl_CUS_WebSiteSections wss ON wss.websiteid = w.websiteid WHERE d.domainname = AND w.portal_type = 'MFR' SELECT p.paramname, p.defaultValue, c.paramvalue FROM tbl_CUS_WebsiteParameters p LEFT OUTER JOIN tbl_CUS_WebsiteConfigurations c ON c.paramid = p.paramid AND c.websiteid = attributeName = REReplace( paramname, "\s", "_", "ALL" ); if( paramValue neq "" ) { Evaluate( "configParameters.#attributeName# = ""#paramvalue#"""); } else if ( defaultValue neq "") { Evaluate( "configParameters.#attributeName# = ""#defaultvalue#"""); } --->