Re: [sqlite] Querying with dot commands using Perl DBD

On 10/02/2009 8:25 AM, Paulson, Ariel wrote: > Hi all, > > Does anyone know how grab the output of a dot command using DBD::SQLite? Here's a big fat hint: that's *not* what you really want to know; go for the helicopter view ... describe your *real* problem e.g. "I'd like to get the name of ea

Re: [sqlite] Querying with dot commands using Perl DBD

2009/2/9 Paulson, Ariel : > Hi all, > > Does anyone know how grab the output of a dot command using DBD::SQLite? > Specifically I'm trying to get this mysql query to run: > > $sth = $dbh->prepare("show tables") > > But in SQLite, "show tables" is ".tables", so my new query is: > > $sth = $dbh->pr

[sqlite] Querying with dot commands using Perl DBD

Hi all, Does anyone know how grab the output of a dot command using DBD::SQLite? Specifically I'm trying to get this mysql query to run: $sth = $dbh->prepare("show tables") But in SQLite, "show tables" is ".tables", so my new query is: $sth = $dbh->prepare(".tables") Only the DBD croaks when