Databases
StackOverflow2013
Postsdbo
POProblems when combine several fields to 1 input field
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POProblems when combine several fields to 1 input field
    primarykey
    data
    text
    <p>I have some codes to combine several fields and pass to 1 input field F on user's profile page. After loading, #Salary_para1 will pass value to field F first, then when user enter value in #Salary_value, it will pass its value to field F too. Same condition with checkbox #Salary_para2.</p> <p>There is problem after user save their profile page. Let say, field F have value "MYR1000 + Allowance" after saved. After loading, field F still shown value of #Salary_para1 ('MYR' in sample) instead of "MYR1000 + Allowance". </p> <p>1) How to make sure that field F shown "MYR1000 + Allowance" after loading?? 2) How to make it don't pass value of #Salary_para1 (MYR) if user didn't input value to #Salary_value? 3) How to make sure that if field F after loading have value of "MYR" and "+ Allowance", then field #Salary_para1 will show 'MYR' and checkbox #Salary_para2 will be checked? (revert back)</p> <p><a href="http://jsfiddle.net/e2ScF/69/" rel="nofollow">http://jsfiddle.net/e2ScF/69/</a></p> <p>CODE:</p> <pre><code>&lt;select id="Salary_para1"&gt; &lt;option value=""&gt;Choose...&lt;/option&gt; &lt;option value="0" selected&gt;MYR&lt;/option&gt; &lt;option value="1" &gt;SGD&lt;/option&gt; &lt;/select&gt; &lt;input id="Salary_value" type="text"/&gt; + &lt;input type="checkbox" id="Salary_para2" name="Salary_para2" value=" + Allowance" /&gt;Allowance&lt;br/&gt; &lt;input type="text" id="targetTextField" name="targetTextField" size="31" tabindex="0" maxlength="99" value="MYR1000 + Allowance"&gt; $(function() { setTarget(); $("#Salary_para1,#Salary_para2").change(setTarget); $("#Salary_value").keyup(setTarget); function setTarget() { var tmp = $("option:selected", "#Salary_para1").text(); tmp += $("#Salary_value").val(); tmp += $("#Salary_para2:checked").val() || ''; $('#targetTextField').val(tmp); } }); </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USHkachhia
    1. USRobert Chan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POProblems when combine several fields to 1 input field
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. CORetrieving a value back on page load/refresh would be difficult but you can store it in a cookie and onpage load you can clear the existing values and fill the values you have captured in cookies.
      singulars
      1. POProblems when combine several fields to 1 input field
      1. USKarthik
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload