1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
/*#
@main Falcon DBI module suite.
This is the Falcon DBI module (and related modules) reference.
The DBI module provides an abstract interface to many database servers.
Falcon handles making the methods and data appear to Falcon scripts to
be identical, thus making it possible to change only your connect string
when a new database server type is to be used.
@section dbi_setup Setup
A minimal setup for this module may be something like the
following:
@code
load dbi
try
db = DBIConnect( "sqlite3:sample.db" )
r = db.query("SELECT name, dob FROM names")
while r.next() == 0
name = r.asString( 0 )
dob = r.asDate( 1 )
> name, " was born on ", dob
end
r.close()
db.close()
catch DBIError in e
> "DBI failed: "
> e
end
@endcode
More advanced fetch methods exist such as @a DBIRecordset.fetchArray,
@a DBIRecordset.fetchDict and @a DBIRecordset.fetchObject.
*/
|
