Inserting multiple rows in a single query

[iker]

Is there a way to do something like this with the filemaker php api?

 

        INSERT INTO Table ( Column1, Column2 ) VALUES
        ( Value1, Value2 ), ( Value1, Value2 )

 

I know I could do something like this but I have to insert 37000 records and I would prefer not to make 37000 commits:

 

                $valuesArray = array('Name' => 'Robin', 'Year' => 2011, 'Week' => '6/5/2011')
                $rec = $fm->createRecord('web_layout'; $valuesArray);
                $result = $rec->commit();

 

Any ideas? Thank you!

[David Jondreau]

You could load the array into a parameter and send it to a Filemaker script. A server-side script creating 3,700 records will still take some time though. And I don't know if there's a limit to parameter size.