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 each of the tables in a db, using DBD::SQLite"
Specifically I'm trying to get this mysql query to run:
>
> $sth = $dbh->prepare("show tables")
perl DBD::SQLite won't know how to handle a non-standard command from a
database s/w like mysql.
> But in SQLite, "show tables" is ".tables", so my new query is:
That's not a query, that's a command to the commandline processor, sqlite3
> $sth = $dbh->prepare(".tables")
>
> Only the DBD croaks whenever I pass in a period, even if it's escaped. The
> messages vary between win & linux, but the linux message is:
>
> DBD::SQLite::db prepare failed: near ".": syntax error(1) at dbdimp.c line 271
"prepare" is shorthand for "prepare an SQL query for execution" -- so
try something that starts with select ...
> Any ideas or workarounds would be greatly appreciated.
... or stop thrashing about wildly and resign yourself to having to read
the documentation: http://www.sqlite.org/faq.html#q7
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
