I see. OK about to make the name change and will try it. Yeah, I guess your right about that thread and its relevance (I was probably grasping ;) ). I think, sooner or later, something will open up! If can just get passed having an empty table list (other wise I do have a DAL object, just can't connect with it.
One question though: SO, I have the existing DB (SQLite). Then, I scripted the model (basically a copy and paste of the original), with minor changes like different name for the DAL object -> existing DB has 'db', and the one trying to connect uses dbx. should the 1st db have the migrate=False as well as in the model of the 2nd? (so both are set to false?) i think this is the third time you're helping me with this, so thank you! :) Mart :) On Feb 25, 3:17 am, pbreit <[email protected]> wrote: > The first bit about the database only applies to SQLite DBs: an SQLite > database will need to go in the "databases" directory and the name must > match the connection string. The two I mentioned are two that I have seen > used with Web2py. > > I'm not sure what to make of that thread. It doesn't seem relevant. > > I presume you've read > this:http://web2py.com/book/default/chapter/06?search=migrate#Legacy-Datab... > > The only other thing I was saying is that web2py is typically expecting > there to be an auto-incrementing, primary key column named "id". It's > possible you can get by without it. I'm just not sure. It is usually how a > join is made.
