On Tue, Dec 04, 2007 at 02:29:10PM -0800, Frank Conradie wrote: > I don't want to fight with you, but INSERT also supports SET:
No, it doesn't (meaning "standard" SQL). http://www.postgresql.org/docs/7.3/static/sql-insert.html : INSERT INTO table [ ( column [, ...] ) ] { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...]) | SELECT query } http://sqlite.org/lang_insert.html : INSERT [OR conflict-algorithm] INTO [database-name .] table-name [(column-list)] VALUES (value-list) SQLObject produces that (more or less) standard INSERT, not MySQL variant. PS. But if you want to teach SQLObject to generate MySQLish INSERT - you know where to send patches. Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
