my $dbh = DBI->connect($db);
...
$dbh->do('PRAGMA full_column_names=1');
$dbh->do('PRAGMA short_column_names=0');
The aliases in SQLite have always been finicky.
Instead of using aliases, just use the table names throughout, as in
SELECT Edition.*, Publisher.Name FROM Edition, Publisher WHERE ...
And the output will be more predictable, at the cost of more verbose SELECTs.
--- Joe Casadonte <[EMAIL PROTECTED]> wrote:
> On Wed, 27 Dec 2006, Joe Wilson wrote:
>
> > Search for these pragmas in the perl module. There might be a method
> > wrapping them. If there isn't, just execute these pragmas just after
> > opening the database.
>
> Can't figure out how to execute them via Perl (yet). Interestingly,
> they only half work in the command-line version (I get Publisher.Name
> instead of P.Name):
>
> SQLite version 3.3.3
> Enter ".help" for instructions
> sqlite> PRAGMA full_column_names=1;
> sqlite> PRAGMA short_column_names=0;
> sqlite> .header on
> sqlite> SELECT E.*, P.Name FROM Edition AS E, Publisher AS P WHERE E.GameID =
> 126 AND
> E.PublisherID = P.PublisherID ORDER BY E.Name, E.EditionID;
> E.EditionID|E.GameID|E.Name|E.PublisherID|E.Own|Publisher.Name
> 130|126|Roads & Boats|46||Splotter Spellen
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
