1 Reply Latest reply on Mar 31, 2007 9:06 AM by Opyuse

    Where am I going wrong?


      The following code is attempting to search a small collection of fields I have setup in my movie as a database of sorts using a key word entered by the user.

      each field in the db has the name firstname followed by a number which is why i use the code below
      set dbfirstname = "FirstName" & n

      the problem i'm having is here
      if firstname = member(dbfirstname) then
      set sresult = member(dbfirstname)
      when i try to compare the keyword the user entered with the text in the field pointed to by dbfirstname it doesn't work.
      I've tried this with the "the text of field" code added also.

      Can anyone help me with this our tell me of another method Thank you