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.
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
More advanced fetch methods exist such as DBIRecordset.fetchArray, DBIRecordset.fetchDict and DBIRecordset.fetchObject.