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.
> 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'
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ p...@phd.pp.ru
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
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
