Some help required text entry converting to numbers?

Hi I am new to CF and getting there slowly,

I have created a form here http://www.c2canalysis.com/register, which is ok so far although when I view the data in the backend the company filed which is text, for strange reasons is converted to numbers in the backend. For example I just did a test and entered Walmart as the company and the number 7 is what appears in the DB ?

Any thought on what this could be ?

One last thing I cant seem to get the after submit text to display ?

Appreciate any help

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">Please enter all fields as we will be shipping items to your business address and need to contact you leading up to the event.</span> </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Name</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_1" name="text_1" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Last Name</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_3" name="text_3" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Title</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_10" name="text_10" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Company</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_19" name="text_19" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Industry</label>
    <select class="cf_inputbox validate-selection" id="select_9" size="1" title=""  name="select_9">
    <option value="">Choose Industry</option>
      <option value="Agriculture">Agriculture</option>
<option value="Automotive">Automotive</option>
<option value="Aviation">Aviation</option>
<option value="Banking / Finance">Banking / Finance</option>
<option value="Charity">Charity</option>
<option value="Communications & Media Services">Communications & Media Services</option>
<option value="Construction">Construction</option>
<option value="Consulting">Consulting</option>
<option value="Education">Education</option>
<option value="Energy">Energy</option>
<option value="Engineering / Professional Services">Engineering / Professional Services</option>
<option value="Entertainment">Entertainment</option>
<option value="Federal Government">Federal Government</option>
<option value="FMCG">FMCG</option>
<option value="Freight / Transport">Freight / Transport</option>
<option value="Gaming">Gaming</option>
<option value="Healthcare">Healthcare</option>
<option value="ICT">ICT</option>
<option value="Legal Services">Legal Services</option>
<option value="Local Government">Local Government</option>
<option value="Manufacturing">Manufacturing</option>
<option value="Marketing Services">Marketing Services</option>
<option value="Mining / Resources">Mining / Resources</option>
<option value="Pharmaceutical">Pharmaceutical</option>
<option value="Property / Real Estate">Property / Real Estate</option>
<option value="Publishing">Publishing</option>
<option value="Retail">Retail</option>
<option value="State Government">State Government</option>
<option value="Travel / Hospitality">Travel / Hospitality</option>
<option value="Utilities">Utilities</option>
<option value="Other">Other</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Address</label>
    <input class="cf_inputbox required" maxlength="150" size="80" title="" id="text_11" name="text_11" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">City</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_12" name="text_12" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">State</label>
    <select class="cf_inputbox validate-selection" id="select_13" size="1" title=""  name="select_13">
    <option value="">Choose State</option>
      <option value="Vic">Vic</option>
<option value="NSW">NSW</option>
<option value="QLD">QLD</option>
<option value="ACT">ACT</option>
<option value="WA">WA</option>
<option value="SA">SA</option>
<option value="TAS">TAS</option>
<option value="NT">NT</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Email</label>
    <input class="cf_inputbox required validate-email" maxlength="150" size="30" title="" id="text_15" name="text_15" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Postcode</label>
    <input class="cf_inputbox required validate-digits" maxlength="150" size="5" title="" id="text_14" name="text_14" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Phone</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_16" name="text_16" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Mobile</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_18" name="text_18" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;"># of Offices in Australia</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_20" name="text_20" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;"># of Employees in Australia</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_19" name="text_19" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_checkbox">
    <label class="cf_label" style="width: 170px;">Have you deployed any UC technologies?</label>
    <div class="float_left">
      <input value="Yes" title="" class="radio validate-one-required" id="check00" name="check0[]" type="checkbox" />
      <label for="check00" class="check_label">Yes</label>
      <br />
      
<input value="No" title="" class="radio validate-one-required" id="check01" name="check0[]" type="checkbox" />
      <label for="check01" class="check_label">No</label>
      <br />
      

    </div>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_checkbox">
    <label class="cf_label" style="width: 170px;">Is UC in your current plans?</label>
    <div class="float_left">
      <input value="Yes" title="" class="radio" id="check10" name="check1[]" type="checkbox" />
      <label for="check10" class="check_label">Yes</label>
      <br />
      
<input value="No" title="" class="radio" id="check11" name="check1[]" type="checkbox" />
      <label for="check11" class="check_label">No</label>
      <br />
      

    </div>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_checkbox">
    <label class="cf_label" style="width: 170px;">I will be attending for:</label>
    <div class="float_left">
      <input value="Golf and Conference" title="" class="radio" id="check20" name="check2[]" type="checkbox" />
      <label for="check20" class="check_label">Golf and Conference</label>
      <br />
      
<input value="Conference Only" title="" class="radio" id="check21" name="check2[]" type="checkbox" />
      <label for="check21" class="check_label">Conference Only</label>
      <br />
      

    </div>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_button">
    <input value="Submit" name="button_17" type="submit" />
  </div>
  <div class="cfclear"> </div>
</div>

Hi deanandeva,

What type of column did you specify in the Create Table setup? It sounds as though it may be an integer rather than VARCHAR or TEXT

It looks as though you have a ReDirect URL set - that redirects to the page you chose rather than showing the OnSubmit After text.

Bob

Hi Firstly thanks for a rapid response,

I checked the tables and they are all VARCHAR255 except for cf_id ?

Hi deanandeva,

Hmmm . . . OK, there's nothing I can think of that ChronoForms does to convert data types :-(

I notice that 7 is the character length of Walmart - is that coincidence or a clue?

Bob

hmm very weird I checked through PHPmyadmin and it is definantly VARChar ?

Going to recreate the form and tables🙂

Hi,

I deleted all the tables and created new ones. 3 times now

Once again I completed the form with the company name Challenger and ended up with the number 1111 in the backend ?

Appreciate any further thoughts as I am not sure what else I can do.

I checked through PHPmyadmin and all the tables are VarChar

So the fault must be in my form somewhere but I simply created it in the wizard

EDIT, tried deleting the company field and recreating still the same result.

I have also just noticed that one of my drop downs with Yes or No returns a 0 in the backend

Hi deanadneva,

[sendfb][/sendfb]

Bob

Hi deanandeva,

That took a bit of finding but I think I solved it.

You have two 'text_19' fields in the form: one is 'Company Name', the second is 'Number of employees in Australia' - the second overwrites the first and you get a number in the Company Name field.

I'd suggest that you go through and change the names and ids to something more meaningful like name='co_name', name='num_employees', etc.

Bob

Hey you guys Rock !!

I even posted a glowing review on the JED, probably only the 2nd time in 4 years.

Thanks you so much for your help.

I love this product and the support

Hi deanandeva,

Thank you

Bob

Hey Bob,

It's the least I could do !

One more thing I am trying to use lightbox, I have managed to get the form to open in a box using JCE. However I now want to close it on submit. I have read the forum and are now more confused than ever. I have tried yoo lightbox, and it work on a normal URL such as google but when I put the form it throws it to the left on a new page.

I saw in the forum the CF has its own frame but can see how to use it and close it on submit ?

Thanks again


Dean

Hi Dean,

I think that Max only uses the lightbox (it's smoothbox) to display info, not to submit.

But, if I recall corrrectly, someone did work out how to do this a couple of months ago and posted a full set of instructions.

Bob