Can Not get info to the Database -SOLVED

ponyack 30 May, 2012
Hi,
EDIT : Spoke to soon - I created a new database and that solved the problem 😶


I have a custom form and just the check boxes are working. But I can not get any of the new information to the database.

I am using the handle arrays and database save on the submit button.

I know its a bunch of code but if I could get some help that would be great.

John

<div class="ccms_form_element cfdiv_custom" id="input_id_7_container_div"><label for="input_id_7">Account Information</label><table width="100%" border="0" cellpadding="1">
  <tr>
  <table width="100%" border="0" cellpadding="1">
  <tr>
    <td><div class="ccms_form_element cfdiv_text" id="autoID-3680417c36a52a2c2531b3eb2b0eda68_container_div"><label>First Name</label><input maxlength="150" size="30" class="" title="" type="text" value="" name="firstName" />
<div class="clear"></div><div id="error-message-firstName"></div></div></td>
    <td><div class="ccms_form_element cfdiv_text" id="autoID-bfb9e9fdf18f3f2457e842aa55b470ca_container_div"><label>Last Name</label><input maxlength="150" size="30" class="" title="" type="text" value="" name="lastName" />
<div class="clear"></div><div id="error-message-lastName"></div></div></td>
    <td><div class="ccms_form_element cfdiv_text" id="autoID-473e6faae14e49c5820f97f616635b1c_container_div"><label>Telephone Number</label><input maxlength="150" size="30" class="" title="" type="text" value="" name="phone" />
<div class="clear"></div><div id="error-message-phone"></div></div></td>
  </tr>
</table><div class="clear"></div><div id="error-message-input_custom_7"></div></div><div class="ccms_form_element cfdiv_text" id="autoID-856274243530be6423795fc391eedd24_container_div"><label>Street Address</label><input maxlength="150" size="100" class="" title="" type="text" value="" name="address" />
<div class="clear"></div><div id="error-message-address"></div></div><div class="ccms_form_element cfdiv_text" id="autoID-b97c88610a5df43245b3a5162eab2f99_container_div"><label>Address Line 2</label><input maxlength="150" size="100" class="" title="" type="text" value="" name="address2" />
<div class="clear"></div><div id="error-message-address2"></div></div><div class="ccms_form_element cfdiv_custom" id="input_id_16_container_div"><table width="100%" border="0" cellpadding="1">
  <tr>
    <td><div class="ccms_form_element cfdiv_text" id="autoID-faac9b3de7a5ff2488d27536c5323963_container_div"><input maxlength="150" size="30" class="" title="" type="text" value="" name="city" /><label>City</label>
<div class="clear"></div><div id="error-message-city"></div></div></td>
    <td><div class="ccms_form_element cfdiv_text" id="autoID-00840003bbb7bd134c801716bbbe7d95_container_div"><input maxlength="150" size="30" class="" title="" type="text" value="North Carloina" name="state" /><label>State</label>
<div class="clear"></div><div id="error-message-state"></div></div></td>
    <td><div class="ccms_form_element cfdiv_text" id="autoID-c1e4d727e85038b9d6ea950907767338_container_div"><input maxlength="150" size="30" class=" validate['alpha']" title="" type="text" value="" name="zip" /><label>Zip Code</label>
<div class="clear"></div><div id="error-message-zip"></div></div></td>
  </tr>
</table><div class="clear"></div><div id="error-message-city"></div></div><div class="ccms_form_element cfdiv_custom" id="input_id_17_container_div"><table width="100%" border="0" cellpadding="1">
  <tr>
    <td><div class="clear"></div><div id="error-message-city"></div></div><div class="ccms_form_element cfdiv_text" id="autoID-910d9fb70203b8b9d7cb1b9983574e57_container_div"><label>Email</label><input maxlength="150" size="50" class=" validate['required','email']" title="" type="text" value="" name="email" />
<div class="clear"></div><div id="error-message-email"></div></div></td>


    <td>
<div class="ccms_form_element cfdiv_radio" id="autoID-bf678dc5a8c8043c48a9093efdc4596d_container_div"><label>Pick Up / Delivery</label><input type="hidden" name="pickup_delivery" value="" alt="ghost" />
<div style="float:left; clear:none;"><input type="radio" name="pickup_delivery" id="pickup_delivery_0" title="" value="pick_up" class="" />
<label for="pickup_delivery_0">Pick Up</label>
<input type="radio" name="pickup_delivery" id="pickup_delivery_1" title="" value="delivery" class="" />
<label for="pickup_delivery_1">Delivery</label>
</div><div class="clear"></div><div id="error-message-pickup_delivery"></div></div></td>
  </tr>
</table><div class="clear"></div><div id="error-message-input_custom_17"></div></div><div class="ccms_form_element cfdiv_custom" id="input_id_18_container_div"><label for="input_id_18">Preferences</label><div class="clear"></div>
<div id="error-message-input_custom_9"></div>
<div class="ccms_form_element cfdiv_checkboxgroup radios_over multiline_add" id="autoID-f8c971ad1c1abb5800e696e33da6e97d_container_div">
<table width="100%" border="0" cellpadding="1">
  <tr>
   
       <td><input type="hidden" name="input_checkbox_group_10" value="" alt="ghost" />
<div style="float:left; clear:none;">
<input type="checkbox" name="input_checkbox_group_10[]" id="input_checkbox_group_10_0" title="" value="Folded" class="" />
<label for="input_checkbox_group_10_0">Folded</label>
<input type="checkbox" name="input_checkbox_group_10[]" id="input_checkbox_group_10_1" title="" value="Ironed" class="" />
<label for="input_checkbox_group_10_1">Ironed</label>
<input type="checkbox" name="input_checkbox_group_10[]" id="input_checkbox_group_10_2" title="" value="Starch" class="" />
<label for="input_checkbox_group_10_2">Starch</label></td>
   
   
   
    <td><input type="hidden" name="input_checkbox_group_11" value="" alt="ghost" />
<div style="float:left; clear:none;">
<input type="checkbox" name="input_checkbox_group_10[]" id="input_checkbox_group_11_0" title="" value="Boxed" class="" />
<label for="input_checkbox_group_11_0">Boxed</label>
<input type="checkbox" name="input_checkbox_group_10[]" id="input_checkbox_group_11_1" title="" value="Gift Wraped" class="" />
<label for="input_checkbox_group_11_1">Gift Wrap</label>
<input type="checkbox" name="input_checkbox_group_10[]" id="input_checkbox_group_11_2" title="" value="Cleaned" class="" />
<label for="input_checkbox_group_11_2">Cleaned</label></td>



    <td><input type="hidden" name="input_checkbox_group_12" value="" alt="ghost" />
<div style="float:left; clear:none;">
<input type="checkbox" name="input_checkbox_group_10[]" id="input_checkbox_group_12_0" title="" value="Bundled" class="" />
<label for="input_checkbox_group_12_0">Bundled</label>
<input type="checkbox" name="input_checkbox_group_10[]" id="input_checkbox_group_12_1" title="" value="Tied" class="" />
<label for="input_checkbox_group_12_1">Tied</label>
<input type="checkbox" name="input_checkbox_group_10[]" id="input_checkbox_group_12_2" title="" value="Beaded" class="" />
<label for="input_checkbox_group_12_2">Beaded</label></td>
  </tr>
</table>

</div>
<div class="clear"></div>
<div id="error-message-input_checkbox_group_10"></div>
<div class="clear"></div><div id="error-message-input_custom_18"></div></div><div class="ccms_form_element cfdiv_submit" id="autoID-c03e4b2f8b6ae1d27efad32663b4100d_container_div"><input name="input_submit_20" class="" value="Submit" type="submit" />
<div class="clear"></div><div id="error-message-input_submit_20"></div></div>
This topic is locked and no more replies can be posted.