Re: [SQLObject] Insert a row without knowing the names of the columns

2007-12-22 Thread Frank Wagner
I think you can do it like this (untested): from sqlobject.sqlbuilder import * qA = Persons._connection.queryAll sql = sqlrepr(Insert(table=Persons.q, values=["Hetland", "Camilla", "Hagabakka 24", "Sandnes"])) qA(sql) HTH & Merry Christmas, Frank On Dec 23, 2007 1:49 AM, Petr Jakeš <[EMAIL PRO

[SQLObject] Insert a row without knowing the names of the columns

2007-12-22 Thread Petr Jakeš
Hi, is there a way how to insert the whole row dataset without knowing the names of the columns? In the SQL it is possible (I mean it is not necessary to specify the names of the columns if the data in the dataset are ordered correspondingly with the columns in the table): This "Persons" table: La