@UrlQueryString (Formula Language)

Syntax

@UrlQueryString( parameterName )

Parameters

parameterName

Text. Optional. The name of a parameter in the URL command.

Return value

query

Text or text list.

• If the parameter is not specified, the return value is the URL command name (first list element) followed by the parameters (name, equal sign, value).
• If the parameter is specified, the return value is the value of the parameter or null if the parameter does not exist.

Usage

@UrlQueryString is useful in formulas that run in the context of a browser.

This function can be used to compose dynamic DB2® query views in Web applications.

The Notes® client always returns null for this formula.

Examples

http://www.acme.com/marketing.nsf?OpenForm&ID=986574&Category=Golf

1. This example:

   @UrlQueryString

   returns the list:

   • OpenForm
   • ID=986574
   • Category=Golf
2. This example:

   @UrlQueryString("Category")

   returns the text:

   • Golf
3. This code allows a DB2 Query View to be composed dynamically, by passing the Department information as part of the URL. To prevent SQL injection from the URL parameter, truncate at the first apostrophe, or if the data may contain apostrophes, escape your quotes using @ReplaceSubstring.

      URLParam := @UrlQueryString("Dept");
   Clause := @If( URLParam ="" ; "" ; " AND DeptName='"+ @Word(URLParam; "'"; 1) +"'");
      
      "SELECT D.DeptID , D.DeptName As DeptName , E.DeptID , E.Lastname AS Lastname FROM " + T1 +"  AS D, " + T2 + " AS E WHERE D.DeptID=E.DeptID" + Clause