Technical References - [SQLdisconnect]

numero = 277
interpreted = N
texte = [SQLdisconnect conn_ref=] [SQLdisconnect] will close the database connection, releasing any resources (including any and all SQLResult variables) associated with the connection, and the [SQLConnect] variable name is freed and available for use again. All SQL connections are terminated at the end of template execution anyway, so it is not required to use [SQLdisconnect]. However, it can come in handy if you wish to iterate several connections, re-using the same connection variable name for each connection.
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.
[SQLdisconnect conn_ref=]

[SQLdisconnect] will close the database connection, releasing any resources (including any and all SQLResult variables) associated with the connection, and the [SQLconnect] variable name is freed and available for use again.
All SQL connections are terminated at the end of template execution anyway, so it is not required to use [SQLdisconnect]. However, it can come in handy if you wish to iterate several connections, re-using the same connection variable name for each connection.

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:

WebDNA Libraries

A list of available libraries for WebDNA...

AWS Raw WebDNA LAMP-Plus WebServer

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

F.A.Q

A compilation of some user's questions...

WebDNA Modules

A list of the currently available modules...

Download WebDNA Applications

WebDNA applications...

Tips and Tricks

A list of user-submitted tips ...

Related Readings:

formulas.db

The formulas...

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

[listvariables]

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

[SQLexecute]

Executes and persits the results of an SQL statement...

[uppercase]

Changes all lower case letters to upper case...

[flushcache]

...