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 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
