1 Reply Latest reply on Aug 30, 2006 5:17 AM by Newsgroup_User

    how to get rid of brackets

    farhanakhan Level 1
      hi
      i m using ARCA database when i m getting the value from the database then i m getting valus in this form
      global gdb
      gdb=new(xtra "arca")
      gdb.opendb(the moviepath & "vision-internation")
      myresult=gdb.executesql("select vclips from player")

      EA1=myresult.rows
      put ilk(EA1)
      put EA1

      -------[["@\B1_EA-1.wmv"], ["@\B2_EA-1.wmv"], ["@\B3_EA-1.wmv"], ["@\B4_EA-1.wmv"]]-------this is the all row data

      when i get one row data then i m geting in this form-------------["@\B1_EA-1.wmv"]

      but i want data without bracket liek this "@\B1_EA-1.wmv"
      ---------------
      put ilk(EA1)
      #list

      what i do tell me what i do





        • 1. Re: how to get rid of brackets
          Level 7
          farhanakhan wrote:
          > when i get one row data then i m geting in this
          > form-------------["@\B1_EA-1.wmv"]
          >
          > but i want data without bracket liek this "@\B1_EA-1.wmv"
          > ---------------
          >
          > what i do tell me what i do

          Use EA1[1] to get the first item in the list EA1.

          put ilk(EA1[1])
          #string

          Andrew