[sqlite] Re: aliasing columns in views

[Puneet Kishor]

Pierre-Yves Delens wrote:

Bonjour,

as a newbie I'm interested in knowing more about tools you seem to be using
:
- Data-Dumper
- DBI
- DBD-SQLite
(I already know about DbManager, SqLitePlus, SqLiteAnalyzer)
Thanks on forward

DBI: http://search.cpan.org/~timb/DBI-1.42/DBI.pm
DBD-SQLite: 
http://search.cpan.org/~msergeant/DBD-SQLite-0.31/lib/DBD/SQLite.pm
Data-Dumper: http://search.cpan.org/~ilyam/Data-Dumper-2.121/Dumper.pm

and a fun thing called Perl ;-)
Perl: http://www.perl.com
Simple script --

#!perl -w

# Import the modules
use strict;
use Data::Dumper;
use DBI;
# Create a database handle
my $dbh = DBI->connect('dbi:SQLite:contactsdb', '', '');
# Here is your sql query
my $sql = <<E;
  SELECT firstname, lastname
  FROM contacts
  WHERE lastname = 'Delens'
E
# Create a statement handle and prepare the sql
my $sth = $dbh->prepare(qq{$sql});
$sth->execute;
my $res = $sth->fetchall_arrayref({});
print Dumper($res);

#######################################
Will produce the following output --
$VAR1 = [
          {
            'firstname' => 'Pierre-Yves',
            'lastname' => 'Delens'
          }
        ];
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]