On Tuesday 09 January 2007 06:08, Ed Leafe wrote: > On Jan 9, 2007, at 8:52 AM, johnf wrote: > > I don't understand the need to do anything with database name??? I > > doubt your > > code does any harm - so why not. > > Getting the information from the database will only work if you > select fields directly from the table: no aliases, no functions, > nothing. Once you get a column in your result set that is not the > actual column in a table in the database, this will fail. > > I think you all need to read the dbapi spec before you start messing > with the internals. There is a reason that it was created the way it > was. > > -- Ed Leafe > -- http://leafe.com > -- http://dabodev.com > > > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
OK. But all Carl is doing is passing the database name into the connection string - right? When I said his code change will not hurt - I mean the providing the database name. I still see no reason to do this. As far as the other stuff I don't know what issue he is attempting to solve. That's why I asked my questions. I did not see any issues with my old code. Also I'm not to sure normal users have access to the "information_schema". I only know that access is assumed OK on public "sysobjects tables". -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
