Even more confusing to me is that if I just set a database name, it doesn't even connect:
> Rose::DB->register_db(
> domain => 'handel',
> type => 'default',
> driver => 'SQLite'
> );
>
>
> my $db = Rose::DB->new(
> domain => 'handel',
> type => 'default',
> database => 'F:\CPAN\Handel-Storage-RDBO\t\var\handel.db'
> );
>
> dump $db;
>
> eval {$db->dbh->do("SELECT * FROM cart")};
> print $@ if $@;
>
> dump $db;
> F:\CPAN>perl test.pl
> bless({
> _origin_class => "Rose::DB",
> connect_options => undef,
> connect_options_for => { handel => { default => 1 } },
> database => "F:\\CPAN\\Handel-Storage-RDBO\\t\\var\\handel.db",
> domain => "handel",
> driver => "sqlite",
> dsn => "dbi:SQLite:",
> id => "handel\0default",
> type => "default",
> }, "Rose::DB::__RoseDBPrivate__::Rose::DB::SQLite")
> DBD::SQLite::db do failed: no such table: cart(1) at dbdimp.c line 269 at
> test.pl line 22.
> DBD::SQLite::db do failed: no such table: cart(1) at dbdimp.c line 269 at
> test.pl line 22.
> bless({
> _dbh_refcount => 1,
> _origin_class => "Rose::DB",
> auto_create => 1,
> connect_options => { AutoCommit => 1, ChopBlanks => 1, PrintError => 1,
> RaiseError => 1, Warn => 0 },
> connect_options_for => { handel => { default => 1 } },
> database => "F:\\CPAN\\Handel-Storage-RDBO\\t\\var\\handel.db",
> database_version => undef,
> dbh => bless({}, "DBI::db"),
> domain => "handel",
> driver => "sqlite",
> dsn => "dbi:SQLite:",
> error => undef,
> id => "handel\0default",
> type => "default",
-=Chris
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ Rose-db-object mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/rose-db-object
