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 PROTECTED]> wrote:
> 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:
> LastName FirstName Address City
>
> And this SQL statement:
>
> INSERT INTO Persons
> VALUES ('Hetland', 'Camilla', 'Hagabakka 24', 'Sandnes')
>
> thanks
>
> Petr Jakes
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sqlobject-discuss mailing list
> sqlobject-discuss@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
