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.

 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.