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:

Download WebDNA Applications

WebDNA applications...

WebDNA reference

...

WebDNA Libraries

A list of available libraries for WebDNA...

AWS Raw WebDNA LAMP-Plus WebServer

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

Technical Change History

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

Tips and Tricks

A list of user-submitted tips ...

Related Readings:

[listdatabases]

Lists all the currently-open databases...

[authenticate]

WebDNA provides a few options for password protecting your pages...

[referrer]

Displays the URL of the referring page...

[SQLresult]

...

[addfields]

[addfields db=...

[lastautonumber]

displays the last auto-generated number...