On 21/08/2009, at 2:39 AM, Dirkjan Bussink wrote: > Well, the reason is actually very simple... Most RDBMS don't provide a > mass insert option and it's certainly not standardized with SQL. > > For MySQL there is the multiple tuples for VALUES method, for > PostgreSQL there is the COPY FROM which loads data from CSV. For most > RBDMS the best approach would be to use prepared statement, this is a > good option that works for almost all databases.
For my MSSQL adapter, you can issue an execute with multiple SQL statements separated by semi-colons. It uses this to insert a new record and get back the generated ID value in one operation. Clifford Heathj. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/datamapper?hl=en -~----------~----~----~----~------~----~------~--~---
