numero = 279
[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]. |
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. |
[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]. |
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!
WebDNA applications...
AWS Raw WebDNA LAMP-Plus WebServerAmazon Web Services (AWS) README for Machine Image ID...
WebDNA LibrariesA list of available libraries for WebDNA...
WebDNA ModulesA list of the currently available modules...
Technical Change HistoryThis Technical Change History provides a reverse chronological list of WebDNA changes...
Tips and TricksA list of user-submitted tips ...
[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...
[object]Embeds the results of an external function...
[SQLconnect]Opens and persists a 'named' connection to a SQL server...
[protect]...
[listwords]Breaks a string of text into separate words...
[listfields]Lists all the fields in the specified database...