8 Replies Latest reply: Jan 7, 2010 7:22 AM by Andris_Sh RSS

    for...next cycle problem

    Andris_Sh

      Hello, everybody.

      I have a table [URLS] with a field [URL], which contains the web address.

      I want to make a script, which would proceed through this table and load a certain data, for example, age information from web addresses in each field.

      I made script similar to this:


      set i = 0;

      for i = 0 to 1000

      let v_url = PEEK('URL',i,'URLS');

      [Data]:

      LOAD [Age:] as [Age]
      FROM
      $(v_url)
      (html, unicode, embedded labels, table is @4);

      next i

      Script works only for the first iteration. After that it for some reason does not recreate v_url variable, it is empty and script fails.

      What am I doing wrong?

      Thanks in advance!