Ricardo Aráoz wrote: > Ed Leafe wrote: >> On Mar 3, 2009, at 4:17 PM, Ricardo Aráoz wrote: >> >>> Finally I'd like to report that crsr.getDataSet() is not as comfortable >>> as it might be. Sometimes the key will be only 'Name' (in the example >>> above), some other times it will be 'menu.name' (notice in the previous >>> case 'Name' was cased) but some other times I use menu.name in the query >>> and the key will be 'Name'. So I haven't found a rule for the naming of >>> keys and I have to previously test the queries in order to know the key >>> names and get the data I need into a list. >> I'm not exactly clear as to what the confusion is here. When you >> run a query, the result returned by the database has some sort of name >> identifying each column in the result set: either the actual column >> name, or an alias if your query used the 'as' clause, or a >> DB-determined name such as 'SUM(mycol)'. The key in the dataset will >> always be the value returned by the dbapi for that column. >> > I've got an example here (after each query there is an output and a > comment) : > -------------------------------------------------------------------------- > ci = dabo.db.dConnectInfo(DbType='SQLite') > ...
Can you please descibe what the inconsisty is you are seeing? Did you run the same statements in sqlite client? Was the output different from what you get in Dabo? Dabo should use the cursor description which you get from the python dbapi and use this for the dictionary keys. Uwe _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/49aeffb0.6020...@googlemail.com