I am wondering if somone can genorate a small and simple piece of code in Formula that will work in a browser using DbLookup
Subject: Always look to your “Help” file first
Here is the example directly from the help file…
- This formula retrieves from the inventory database the complete list of colors in which company uniforms are available. The data is stored like this:
Item Size Color
Shirt Small Red
Skirt Small Green
Sweater Medium Red
Trousers Medium Yellow
To retrieve the entire contents of the Color column (column 3) for all records where the first sorted column (column 1, Item) contains “Shirt” or “Trousers”:
@DbLookup(“ODBC”; “INVENTORY”; “”; “”; “UNIFORMS”; “Color”; “Item”; “Shirt” : “Trousers”)
Since multiple records contain at least one of the keys, the result is a list:
Red:Yellow
Values in the resulting list appear just as they were encountered in the database; they are not sorted and duplicate values are retained.
This is also in the help…
Usage
@DbLookup is intended mainly for keyword formulas. Instead of hardcoding a list of keywords and then periodically updating that list, @DbLookup lets you dynamically retrieve a list of values from an external database table.
@DbLookup can’t be used in mail agents, although it does work in paste agents. This function only works in Web applications if the remote server hosting the table from which data is being retrieved exists on the same machine as the Domino server, which is rarely the case.
Good Luck,
Brent
Subject: DbLookup Example
Tomas,
You have all the information you need. If you do not address the fundamental issues of data enrty, user authentication, and security I raised in my earlier responses to your posts, nothing will work correctly.