Technical References - [SQLrelease]

[SQLrelease result_ref=]

[SQLrelease] will close the result set and variable name created by a [SQLexecute] context. The name is freed and available for use again.
All SQL result objects are released at the end of template execution anyway, so it is not required to use [SQLrelease]. However, it can come in handy if you wish to iterate several [SQLexecute] contexts, re-using the same result variable name for each SQL execution.

ParametersDescription
conn_ref (or just 'ref')(Required) - The name of the SQLConnect variable you have created via the conn_var (or var) parameter of a [SQLconnect] context you have already successfully executed.

DOWNLOAD WEBDNA NOW!

Top Articles:

Download WebDNA Applications

WebDNA applications...

F.A.Q

A compilation of some user's questions...

WebDNA reference

A list of all WebDNA instructions...

WebDNA Modules

A list of the currently available modules...

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:

[listwords]

Breaks a string of text into separate words...

[browsername]

Displays the browser name...

[scope]

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

[removelineitem]

...

[boldwords]

Highlights matching words with boldface HTML tags...

[redirect]

...