in reply to Re: DBI modules for database representation in plain files
in thread DBI modules for database representation in plain files
this get Fred", "Bloggs", "fred\@bloggs.com". So i must assume that DBD::SQLite don't test for type size?#!/usr/bin/perl -w use strict; use warnings; use DBI; use DBD::SQLite; my $dbh = DBI->connect("dbi:SQLite:dbname=foo", "", "", {AutoCommit => + 1, RaiseError => 1}); $dbh->do("CREATE TABLE info (f1 char(3) primary KEY, f2 char(3), f3 ch +ar(3))"); $dbh->do('create unique index info_idx on info (f1)'); my $sth = $dbh->prepare("INSERT INTO info VALUES (?, ?, ?)"); $sth->execute("Fred", "Bloggs", "fred\@bloggs.com"); $sth = $dbh->prepare("SELECT * FROM info"); $sth->execute(); while (my @row = $sth->fetchrow_array ) { print "@row\n"; } $dbh->disconnect;
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: DBI modules for database representation in plain files
by phemes (Scribe) on Feb 26, 2004 at 10:36 UTC |