Oleg Broytmann wrote: > On Tue, Feb 03, 2009 at 06:14:24PM +0100, Stef Mientki wrote: > >>> Well, we use sqlite:///path/to/data.base syntax with ':' replaced by >>> '|': sqlite:///C|program/data.db. This is how we do it: >>> >> This is absolutely weird >> > > Not at all. This is how web-browsers used to support file://-URLs on > w32. > That must be a long time ago, for decades I use "file:///D:/...." > >> There seems to have been more problems with table names and columns names, >> but the above states clear that underscores are allowed. >> The error complains about invalid column names, >> so apparently it has read the table information, >> and the table names are so simple 'Field1', 'Field2' , etc >> >> Or I'm doing something completely wrong, >> or I do things different from other users ( e.g. starting with already >> existing database), >> or no-one has really tested SQLObject with sqlite3. >> Any other possibilities ? ;-) >> > > Or trying to use SQLObject with a database that SQLObject fails to > handle. SQLObject has some requirements, most notable - there have to be > a primary key in the table, of type INT or CHAR, with the name 'id'; if > it's not named 'id' you have to provide an explicit name: > > class MyTable(SQLObject): > class sqlmeta: > idName = 'my_id' > > That explains. thanks Oleg,
cheers, Stef ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
