Technical References - [SQLinfo]

numero = 279
interpreted = N
texte = [SQLinfo Params]...[/SQLinfo]Reports back information about a SQL connection that has already been established via [SQLconnect].Example:

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

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

Example:

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

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

WebDNA Modules

A list of the currently available modules...

F.A.Q

A compilation of some user's questions...

WebDNA Libraries

A list of available libraries for WebDNA...

Technical Change History

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

Related Readings:

[founditems]

[founditems]...

[sendmail]

There is hardly a website that doesn't at some point need to send an email...

[username]

Using [password] and [username] is an easy was to show the browser login dialog box...

[scope]

Explicitly define a block of WebDNA code that has a separate variable space...

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

[array]

Array Operation...