How can I iterate through incoming form fields? I can list all the fields and values that are being posted to the page using [Request.Form] and count the number of fields with [Request.Form.Count] but can't quite figure out how to pull the names of the fileds using a key. Or pull all the field names and values by looping through the [Request.Form]

Thanks for the help.

-Jeff

The problem with iterating through [Request.Form] is that DNN has a lot of form values that gets passed along as well as your form. What I have done is create a small jQuery script that iterates through my form and puts the field names in a hidden text field, then I can use that field to iterate through the form values of my form.

<div id="form_validate" class="FormBox">***MY FORM***</div>

<div><input type="hidden" name="formFields" id="formFields" /></div>

<script>

var formFields = $(".FormBox :input").map(function(){

      return $(this).attr('name');

    }).get().join(", ")

$('#formFields').val(formFields);

 

</script>

So the value of the formFields will be something like: Firstname,Lastname,Email,Phone (ie, the field names in a comma delimited format).

Run the attached file in a SQL query to create the function SplitText

Then: 

Create a variable,Type: Form,  Source:formFields  Value: @formFields

Create a named query  "formData"  query: Select * from SplitText(1,@formFields,',')

The result will be each field split up into rows so that you can run actions agaist each field.