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:

[biotype]

BioType is a behavioral biometrics WebDNA function based on ADGS research and development (from version 8...

Tips and Tricks

A list of user-submitted tips ...

AWS Raw WebDNA LAMP-Plus WebServer

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

WebDNA Modules

A list of the currently available modules...

WebDNA Libraries

A list of available libraries for WebDNA...

Download WebDNA Applications

WebDNA applications...

Related Readings:

[cookie]

Cookies are a great way to remember visitors...

[if]

This context displays HTML or executes WebDNA conditionally only if the expression is true...

[function]

This context enables the WebDNA programmer to call a previously defined block of WebDNA code...

[replacefounditems]

Replaces each found record in a database with the new field values...

[SQLdisconnect]

...

[listvariables]

Lists all the text and/or math variables which have been set earlier on a page...