Thread: Mass insert
View Single Post
  #1 (permalink)  
Old 30th June 2009, 17:53
goitalia goitalia is offline
D4PHP Enthusiast
 
Join Date: Apr 2007
Location: Milano
Posts: 182
goitalia is on a distinguished road
Default Mass insert

Hi,
sure that i lost something. But when i want insert say 5000 record in a table all is stopped after 2800~2850 record, i try to encapsulate the insert loop between try catch but no message the page is blank that's all.
How can i solve this kind of problem?
PHP Code:
 try {

               
$this->Query1->SQL "INSERT INTO table  (
                                    v1,
                                    v2,
                                    codice_1,
                                    codice_2,
                                    codice_3,
                                    codice_4,
                                    completato) VALUES ('"
.
                                    
$v1."','".
                                    
$v2."','".
                                    
$c1."','".
                                    
$c2."','".
                                    
$c3."','".
                                    
$c4."','".
                                    
$completato."')";
               
$this->Query1->refresh(); 
No errors only stop to run.

Many thank's for help.
Paolo.
Reply With Quote
Sponsored Links