Technical References - [lookup]

[lookup db=databasePath&[!]
[/!]value=searchValue&[!]
[/!]lookInField=searchField&[!]
[/!]returnField=fieldName&[!]
[/!]notFound=TextIfNotFound]

There is no need to close this tag: it will be directly replaced by the result

Using [lookup] in your template performs an extremely fast search through the specified database and returns either the value of the returnField in the found record, or the literal text of the notFound value. The search is a case-sensitive, exact match, so "Grant" does not equal "grant." If you want more control over the search criteria, use a [search] context instead.

You can specifiy a WebDNA table, in place of a db file.
For example: [Lookup table=TableName&...].

[lookup] is about 40 times faster than [search]. Using several [lookup] to recover data from your bases might be faster than a single [search]

DOWNLOAD WEBDNA NOW!

Top Articles:

Download WebDNA Applications

WebDNA applications...

F.A.Q

A compilation of some user's questions...

Tips and Tricks

A list of user-submitted tips ...

WebDNA reference

A list of all WebDNA instructions...

WebDNA Libraries

A list of available libraries for WebDNA...

Technical Change History

This Technical Change History provides a reverse chronological list of WebDNA changes...

Related Readings:

[listfiles]

When listing files...

[httpmethod]

Displays the method...

[array]

Array Operation...

[xslt]

The [xslt] Context allows the WebDNA programmer to 'apply' an XSL style sheet to an XML document and thus 'transform' the XML data into any format the programmer desires (usually HTML)...

[listpath]

Breaks a path into separate foldernames and a filename...

[table]

[table] allows you to quickly create a temporary 'in line' database that is local to the template and not part of the global database cache...