Opens and persists a 'named' connection to a SQL server, for the durration of the template.[SQLConnect Params]...[/SQLConnect]
|dbtype||(Optional) - Can be one of three reserved values - MYSQL, MSSQL, or ORACLE - depending on the type of RDBMS you wish to connect to.If 'dbType' is not given, WebDNA defaults to MYSQL. For WebDNA 6.0, MYSQL is the only type supported.|
|host||(Required) - Either the IP Address or the host name of the database server you wish to connect to.|
|port||(Optional) - The non-standard/non-default port of the database host you wish to connect to; do not provide a value unless your database administrator has informed you that the you must use a specific port in order to connect to the server.|
|database||(Optional) - The name of the database to which you wish to connect; almost all the time you will want to provide a database name to connect to; if you do not supply the "database" parameter, the engine assumes you wish to connect to the RDBMS as admin in order to execute admin-type tasks, such as creating tables, etc.; please note that in this case you will more than likely only be required to provide admin credentials in order to connect successfully.|
|uid||(Optional) - The username credential you want to use to connect to the SQL server.|
|pwd||(Optional unless uid is used) - The password credential you want to use to connect to the SQL server.|
|(Required) - the name of the connection variable that will be created on successful connection.|
|[SQL_HOST]||The IP Address/host name of the database server.|
|[SQL_SERVERTYPE]||The type of the database server; types returned: MYSQL, MSSQL, or ORACLE.|
|[SQL_SERVERVER]||The SQL database server version number.|
|[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!
This Technical Change History provides a reverse chronological list of WebDNA changes...AWS Raw WebDNA LAMP-Plus WebServer
Amazon Web Services (AWS) README for Machine Image ID...Download WebDNA Applications
A compilation of some user's questions...WebDNA Libraries
A list of available libraries for WebDNA...WebDNA reference
A list of all WebDNA instructions...
Web Hosting Control Panels are becoming prevelant in the industry...[raw]
Displays enclosed text without interpreting the [xxx] tags in any way...[if]
This context displays HTML or executes WebDNA conditionally only if the expression is true...[listfields]
Lists all the fields in the specified database...[purchase]
Create an empty folder on your webspace...