SQLinfo
[SQLinfo Params]...[/SQLinfo]
Reports back information about a SQL connection that has already been established via [SQLconnect].
Example WebDNA code:
The following tags are available inside a [SQLinfo] context:
Reports back information about a SQL connection that has already been established via [SQLconnect].
Example WebDNA code:
[SQLconnect dbType=MySQL&host=192.168.1.1&database=base&uid=sa&pwd=pass&conn_var=conn1]
Connected successfully
[/SQLConnect]
SQLinfo reports:
[SQLinfo conn_ref=conn1]
Host: [SQL_HOST]
Server Version: [SQL_SERVERVER]
Client Version: [SQL_CLIENTVER]
[/SQLinfo]
Parameter | Description |
---|---|
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:
Tag | Description |
---|---|
[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. |