- Executing Context, Request Attribute, SQL Replacement Text

ExecutingContext Parameter

??+<key>

ExecutingContext Parameter is similar to the request attribute. An ExecutingContext is created with each request that comes into WOW and exists for the duration of the request. Developers can put Objects on the ExecutingContext to be used later in code or referenced via parameters. ExecutingContext.getObject(Object) and ExecutingContext.putObject(Object) can be used to get/set objects programmatically.

Request Attribute Parameter

??*<request attribute key>

Request Attribute is different from Request Parameter.

• • HttpServletRequest.getParameter(String) returns a string that comes in from a parameter on a URL or the page being submitted (i.e. think input parameter).

  • HttpServletRequest.getAttribute(Object) returns an object that has been stored on the current request. It's more of something that would have been set by a developer at some point from the time the request was started to when it is finished.

SQL Replacement Text Parameter

??<

Replacement Text parameter replaces a specified column being used and replaces it with a portion of SQL being specified. This happens at runtime then renders the results.

Here is an example of how it's used:

??<column_name

So if I wanted to use this in my SELECT portion of my SQL statement I can do something like this:

SELECT ??<select_column

FROM PJDATA.EMPLOYEE

Then in my select_column, I will input the following statement:

firstname, lastname, job

This will then at runtime take the portion:

??<select_column

and replace it with

firstname, lastname, job

so the final result that is ran will be:

SELECT firstname, lastname, job

FROM PJDATA.EMPLOYEE

This allows the ability to choose what type of statement to run by choosing a specific row. This can come handy for printing out reports or even just to run a variety of SQL from one page.

Click here for more information on Replacement Text.