Technical References - [lookup]

numero = 186
interpreted = N
texte =

[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]

[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:

WebDNA Libraries

A list of available libraries for WebDNA...

F.A.Q

A compilation of some user's questions...

Download WebDNA Applications

WebDNA applications...

WebDNA Modules

A list of the currently available modules...

Tips and Tricks

A list of user-submitted tips ...

AWS Raw WebDNA LAMP-Plus WebServer

Amazon Web Services (AWS) README for Machine Image ID...

Related Readings:

[sendmail]

There is hardly a website that doesn't at some point need to send an email...

[closedatabase]

[CLOSEDATABASE db=FileName]...

[scope]

Explicitly define a block of WebDNA code that has a separate variable space...

[append]

[append db=base...

[lowercase]

Changes all upper case letters to lower case...

[cart]

Putting [cart] in your template automatically creates a unique shopping cart...