In the past I’ve blogged about how to generate dynamic HTML content based on the query string using the “HTML From Stored Procedure” module. With the latest release of Arena (v 2008.1) the “Advanced HTML Text” module also has some smarts built into it to render content specific to the query string. We took advantage [...]
Something that has helped us make considerable performance improvements in Arena is the use of Common Table Expressions. Common Table Expressions are especially useful when we need a list of hierarchal data. For example below are two stored procedures that were previously used to get a list of tag members in a hierarchal list of [...]
I’ve gotten a few questions about how Arena determines the appropriate portal to load when someone requests an Arena site. Here’s the steps that Arena goes through to determine which portal should be loaded…
The first thing it checks is if a “portal” query string parameter was specified. If so, it loads the portal with the [...]
