The pragmas would help... sqlite> PRAGMA short_column_names = 0; sqlite> PRAGMA full_column_names = 1; sqlite> select t1.*, t2.* from t1, t2; t1.a|t2.a 4|5
--- Joe Wilson <[EMAIL PROTECTED]> 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. > > sqlite> select E.*, t2.* from t1 E, t2; > E.a|t2.a > 4|5 > > --- Joe Casadonte <[EMAIL PROTECTED]> wrote: > > When querying multiple tables I was relying on SQLite to return the > > column names with the table name/designator prepended to it. The > > following works in 2.x but not in 3.x: > > > > SQLite version 2.8.17 > > Enter ".help" for instructions > > 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|P.Name > > 130|126|Roads & Boats|46||Splotter Spellen > > > > > > SQLite version 3.3.3 > > Enter ".help" for instructions > > 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; > > EditionID|GameID|Name|PublisherID|Own|Name > > 130|126|Roads & Boats|46||Splotter Spellen > > > > > > This is reflected in my Perl program, where my scripts are now broken > > after upgrading to a new version of SQLite, as I am looking for data > > in E.Name and P.Name, and finding neither (in fact, I have no value > > for Name returned at all). Is there any way to get the old behavior > > back? Is there some other work-around? > > > __________________________________________________ > 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] -----------------------------------------------------------------------------
