9 Replies Latest reply on Mar 16, 2007 5:27 PM by Charles Parcell

    Get data of ouf a list to put in sql

    ajrobson
      I have a script that checks which checkboxes are checked then adds ticked ones into a list, I now want to get the data out of the list and put it into a sql select something like select * from table where title in(list), my problem is not only getting the data out of the list but also getting it so it is the correct format (single quotes with a comma between items)
      Attached is the part of the code where i am creating the list i have also included the sql part to make more sense, can anybody help me or tell me what i need to do to split the list into something like: 'item1', 'item2', etc