Error occured while executing the script. The execution is stopped since the number of deluge statements that can be executed in an action has exceeded the maximum limit.

Here's the version that runs fine, but gives me no access to the results:

1. htmlpage test_dup1()
   displayname = "Test Duplicate Phone numbers in RefUSA Data"
   content
   <%{%>
   
                 
          <%myList = List();
       dupRIDList = List:Int();
       for each record in RefUSA_Data  [ID != 0]
       {
           if (myList.contains(record.Phone_Number_Combined))
           {
               dupRIDList.add(record.ID);
           }
           else
           {
               myList.add(record.Phone_Number_Combined);
           }
       }%>
   
                      
   
   <%}%>
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   

I've tried every way I can think of ...

first I tried to output the data in an html table, but the script also barfed and said data could not be accessed for form variable.

Below is the simplest I could think of - which attempts to add the resulting record id to a different form, that I could then view in list. But it returns the above error.

Here's the line I add to the script, which breaks it:

1.             NewRecord = insert into Duplicates
               [
                   ID1 = record.ID
                   Phone = record.Phone_Number_Combined
                   Added_User = zoho.loginuser
               ];
   
   
   
   
   

Here's the entire form with broken script:

1. htmlpage test_dup1()
   displayname = "Test Duplicate Phone numbers in RefUSA Data"
   content
   <%{%>
   
                 
          <%myList = List();
       dupRIDList = List:Int();
       for each record in RefUSA_Data  [ID != 0]
       {
           if (myList.contains(record.Phone_Number_Combined))
           {
               dupRIDList.add(record.ID);
               NewRecord = insert into Duplicates
               [
                   ID1 = record.ID
                   Phone = record.Phone_Number_Combined
                   Added_User = zoho.loginuser
               ];
           }
           else
           {
               myList.add(record.Phone_Number_Combined);
           }
       }%>
   
                      
   
   <%}%>
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   

I hope someone can give me a clue. Seems like it must be a simple problem.
The DB has only 2500 records, and probably less than a couple dozen duplicates.

Identifying the duplicates takes about 10 seconds, and seems to be no problem.
Trying to access the results suddenly causes problems.

Thanks!

Kenny