2 Replies Latest reply on Jul 30, 2010 7:01 AM by PTS21

    Multiple Checkbox Values Into One Field

    PTS21 Level 1

      Hopefully someone can help me with this issue I'm having.

       

      I'm trying to save the values of multiple selected checkboxes into one field separated by commas through ADDT's Insert Transaction code. I can do this easily with DW's standard insert record wizard by using the PHP implode() function but I haven't been able to figure it out with ADDT's code.

       

      <form>
      <input type="checkbox" value="1" name="program[]" /> Program One
      <input type="checkbox" value="2" name="program[]" /> Program Two
      <input type="checkbox" value="3" name="program[]" /> Program Three
      <input type="checkbox" value="4" name="program[]" /> Program Four
      </form>
      
      THIS IS ADDT'S CODING
      $ins_quoteManager->addColumn("programs", "STRING_TYPE",  "POST", "programs");
      
      THIS WORKS VIA DREAMWEAVER'S INSERT RECORD WIZARD
      Original: GetSQLValueString($_POST['programs'], "text"),
      Modified: GetSQLValueString(implode(',',$_POST['programs']), "text"),

       

      Anyone know how to modify the ADDT code with the implode function to get this to work?