Differences

This shows you the differences between two versions of the page.

--- code:data:sql [2011/01/26 18:58] – jmgr
+++ code:data:sql [2011/04/20 20:33] (current) – removed jmgr
@@ Line 1: / Line 1: @@
-====== Sql ======
-This object allows you to establish a connection to a SQL database like MySQL, PostgreSQL, SQLite and others.
-===== Functions =====
-==== Sql ====
-Constructor function.
-=== Syntax ===
-<code javascript>
-var myObject = new Sql(driver);
-</code>
-=== Arguments ===
-  - driver - ([[#driver|Driver]]) the database driver to use
-=== Exceptions ===
-  * (NoDatabaseDriverError) no database driver specified
-=== Example ===
-Create a Sql object operating on a MySQL database.
-<code javascript>
-var myObject = new Sql(Sql.MySQL);
-</code>
-=== Notes ===
-On Windows only the MySQL, PostgreSQL, SQLite 3, Firebird and ODBC drivers are installed by default.
-To see all available drivers call the [[#drivers|drivers]] function.
-===== Enumerations =====
-==== Driver ====
-SQL drivers. On Windows only the MySQL, PostgreSQL, SQLite 3, Firebird and ODBC drivers are installed by default.
-=== Values ===
-  - SQLite2: SQLite 2
-  - SQLite: SQLite 3
-  - PostgreSQL: PostgreSQL (versions 7.3 and above)
-  - MySQL: MySQL
-  - ODBC: Open Database Connectivity (ODBC) - Microsoft SQL Server and other ODBC-compliant databases
-  - InterBase: Borland InterBase (Firebird)
-  - OCI: Oracle Call Interface Driver
-  - TDS: Sybase Adaptive Server (obsolete)
-  - DB2: IBM DB2 (version 7.1 and above)