Initiating many records - HELP

Initiating many records - HELP

UPDATE:::

I seemed to have found the issue, but it bring up another issue. 

First off, what i thought was a limit on the number of records that i was able to initiate at a single time, was wrong. The problem was in the special charters that existed in the zoho reports database such as  [ & , - \ () ]... After I manually removed them, the record initiation worked as it should...

Now my next issue is how do i get it so it will except the special charters listed above?






------------------------------------------------
Original  Post 

I have an application that is used to pull a range of records defined by 2 different numbers from Zoho reports, into zoho creator. The pulling of the range of records works fine. On submit of the form (which the range of records are pulling into) each record in the range initiates a record. At time I have 30-50 records being initiated at a single time. 

My problem is when I do more then 15-20 records it locks up and gives me an error saying it is unable to update the record variable. It works fine for less then 20 records, however i need it to work for any number of records that I require. 

Below is my on click script for the form:

  2. delete from Trip_Number1[ ID != 0 ];
  3. for each key in input.trip_no
  4. {
  5.     ticketDetails = getUrl(("https://accounts.zoho.com/login?servicename=ZohoReports&FROM_AGENT=true&LOGIN_ID=jpiajr&PASSWORD=sexisfun!23"));
  6.     ticket = (ticketDetails.toString()).subString(((ticketDetails).indexOf("TICKET=")  +  7),((ticketDetails).indexOf("RESULT")  -  1));
  7.     query = "select * from trip_info where trip_no = '" + key + "'";
  8.     url = "http://reports.zoho.com/api/jpiajr/Trans/trip_info?ZOHO_ACTION=EXPORT&ZOHO_OUTPUT_FORMAT=XML&ZOHO_ERROR_FORMAT=XML&ZOHO_API_KEY=e6fb7417b6be1b79f5917bcb24afd91d&ticket=" + ticket + "&ZOHO_API_VERSION=1.0&ZOHO_SQLQUERY=" + query;
  9.     response = getUrl(url);
  10.     result = response.executeXPath("/response/result/rows/row");
  11.     trip_no1 = result.executeXPath("/row/column [@name = 'trip_no' ] /text()");
  12.     carrier1 = result.executeXPath("/row/column [@name = 'carrier' ] /text()");
  13.     region1 = result.executeXPath("/row/column [@name = 'region' ] /text()");
  14.     trucktype1 = result.executeXPath("/row/column [@name = 'trucktype' ] /text()");
  15.     tripdate1 = result.executeXPath("/row/column [@name = 'tripdate' ] /text()");
  16.     insert into Trip_Number1
  17.     [
  18.         Added_User = zoho.loginuser
  19.         carrier = carrier1
  20.         region = region1
  21.         trip_no = trip_no1
  22.         trucktype = trucktype1
  23.         tripdate = tripdate1
  24.     ]
  25. }
  26. openUrl("https://creator.zoho.com/jpiajr/call-in-report/csv/Trip_Number1_View/YVUd2qrpuwpBSE7OKQkrJf7A44gnMFUKnvmmUNMDExJ6NRHy3S2DCuCrHO9KR5fWNqSTTs2hTut83DmA4FbrVuVTKxE1NTg1sVZC/", "same window");
Thank you in advance for your help.