
   function prepString(sStringToPrep2)
   {
      var sPrepedString = "";
      sStringToPrep = sStringToPrep2;
      // single quote change
      //sPrepedString = stringReplace(sStringToPrep,"'","\\\'");
      sPrepedString = stringReplace(sStringToPrep,"'","''");
    
      return sPrepedString;
   }
 
   function stringReplace(originalString, findText, replaceText)
   {
      var pos = 0;
      var lenFindText = findText.length;
      var lenReplaceText = replaceText.length;
      var preString = "";
     
      originalString = originalString.toString();
      var lenOriginalString = originalString.length;
     
      iCounter = 0;
      pos = originalString.indexOf(findText);
      postString = originalString;
      while (pos != -1)
      {
         preString = preString + postString.substring(0, pos) + replaceText;
         postString = originalString.substring(pos + 1, originalString.length);
         pos = postString.indexOf(findText);
      }
      originalString = preString + postString;
     
    
      return originalString;
   }
