Technical References - [SQLinfo]

[SQLinfo Params]...[/SQLinfo]
Reports back information about a SQL connection that has already been established via [SQLconnect].


[SQLconnect dbType=MySQL&host=]
Connected successfully

SQLinfo reports:
[SQLinfo conn_ref=conn1]
Host: [SQL_HOST]
Server Version: [SQL_SERVERVER]
Client Version: [SQL_CLIENTVER]

conn_ref (or just 'ref')The name of a SQLConnect variable created (via the conn_var or var variable) by the successful execution of [SQLconnect].

The following tags are available inside a [SQLinfo] context:

[SQL_HOST] The IP Address/host name of the database server.
[SQL_SERVERTYPE]The RDBMS type of the database server; type returned: MYSQL, MSSQL, or ORACLE.
[SQL_SERVERVER]The version number of the SQL server; e.g. 7.0.
[SQL_CLIENTVER]The version number of the client being used to connect to the database server.
[SQL_DBNAME]The name of the database you have connected to, if any.


Top Articles:

AWS Raw WebDNA LAMP-Plus WebServer

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

Tips and Tricks

A list of user-submitted tips ...

WebDNA Libraries

A list of available libraries for WebDNA...

WebDNA Modules

A list of the currently available modules...


A compilation of some user's questions...

Technical Change History

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

Related Readings:


A powerful feature to connect to a TCP port of another computer on the Internet...


Deletes a folder from your website...


Prevents other threads from simultaneously accessing a group of databases...


[addfields db=...


Lists all the fields in the specified database...

Web Hosting Control Panels and WebDNA

Web Hosting Control Panels are becoming prevelant in the industry...